היי יאיר,
ניסיתי..אבל הדו"ח כל כך איטי והוא תוקע לי בכל פעם את המחשב… ואני לא מבינה למה.
הנה הדו"ח אם זה עוזר,יש לך רעיון מה הבעיה?
תודה תודה!
שירן.
SELECT ROY_HTRANS.DOCNO AS 'תעודה',
ROY_HTRANS.CURDATE AS 'תאריך',
ALN_SERIAL.SERNUM AS 'ע"הפק שם',
FAMILY.FAMILYNAME AS 'משפחה',
FAMILY.FAMILYDES AS 'משפחה תאור',
ASSEMBLYSTATUSES.CODE AS 'הרכבה סטטוס',
PART1.PARTNAME AS 'גזיר',
PART1.PARTDES AS 'מוצר תאור',
REALQUANT(ROY_HTRANSPART.ORDQUANT) AS 'בהזמנה כמות',
REALQUANT(ROY_HTRANSPART.TQUANT) AS 'שנגזרה כמות',
REALQUANT(ROY_HTRANSPART.CQUANT) AS 'לגזור כמות',
(ORDQUANT – TQUANT > 0 ? ORDQUANT – TQUANT : 0) AS 'לגזור שנותר כמות',
(0.0 + (REALQUANT(TQUANT) / REALQUANT(ORDQUANT) * 100)) AS 'ביצוע אחוז',
PART2.PARTNAME AS 'בד ט"מק',
PART2.PARTDES AS 'מוצר תאור',
CUSTOMERS.CUSTNAME AS '10 סטטוס',
REALQUANT(WARHSBAL.BALANCE) AS '10ב מפעל \'ביח יתרה',
UNIT1.UNITNAME AS 'מפעל \'יח',
CUSTOMERS1.CUSTNAME AS '11 סטטוס',
REALQUANT(WARHSBAL1.BALANCE) AS '11ב מפעל \'ביח יתרה',
PART2.PARTNAME AS 'ט"מק',
WAREHOUSES.WARHSNAME AS 'מחסן',
WAREHOUSES.LOCNAME AS 'איתור',
SERIAL.SERIALNAME AS 'ע"פק/מנה',
ACT.ACTNAME AS 'פעולה',
EXEC.ENAME AS 'ישות שם'
FROM EXEC , ACT , SERIAL , WAREHOUSES WAREHOUSES1 , WAREHOUSES
, PARTARC , WARHSBAL WARHSBAL1 ?, CUSTOMERS CUSTOMERS1 , UNIT UNIT1
, WARHSBAL ?, CUSTOMERS , PART PART2 , ROY_HTRANSPART , PART PART1
, ASSEMBLYSTATUSES , FAMILY , ALN_SERIAL , ROY_HTRANS
WHERE (EXEC.ENAME = (ACT.ACT >= -1000 ? 'ACT' : 'PALLETS'))
AND (EXEC.TYPE = 'F')
AND (PART2.PUNIT = UNIT1.UNIT)
AND (WARHSBAL1.ACT -5 /* RELEASE */)
AND (WARHSBAL.ACT -5 /* RELEASE */)
AND (WARHSBAL.ACT = ACT.ACT)
AND (WARHSBAL.SERIAL = SERIAL.SERIAL)
AND (WARHSBAL1.WARHS = WAREHOUSES1.WARHS)
AND (WAREHOUSES1.WARHS =14)
AND (WAREHOUSES.WARHS =-2)
AND (WARHSBAL.WARHS = WAREHOUSES.WARHS)
AND (WARHSBAL1.CUST = CUSTOMERS1.CUST)
AND (WARHSBAL.CUST = CUSTOMERS.CUST)
AND (PARTARC.SON = WARHSBAL1.PART)
AND (PARTARC.SON = WARHSBAL.PART)
AND (PARTARC.SON = PART2.PART)
AND (ROY_HTRANSPART.PART = PARTARC.PART)
AND (ROY_HTRANSPART.PART = PART1.PART)
AND (ROY_HTRANS.HTRANS = ROY_HTRANSPART.HTRANS)
AND (ROY_HTRANS.STATUS = ASSEMBLYSTATUSES.ASSEMBLYSTATUS)
AND (ROY_HTRANS.FAMILY = FAMILY.FAMILY)
AND (ROY_HTRANS.SERIAL = ALN_SERIAL.ALN_SERIAL)
AND ( 1=1 )
ORDER BY 21 ASC, 15 ASC, 14 ASC, 22 ASC, 23 ASC, 24 ASC, 16 ASC, 25 ASC,
26 ASC ;
.
