/* Formatted on 2011/04/21 14:22 (Formatter Plus v4.8.8) */
SELECT sfb01 x1, sfb28 x2, nsfb02 x3, nsfb03 ps, sfb05 x4, ima021 x5,
sfb04 x6, sfb13 x7, sfb15 x8, sfb25 x9, ROUND (sfb08) x10,
ROUND (sfb081) x11, ROUND (sfb09) x12,
DECODE (srg16, 'X', '未報工', '已有報工單') x13,
CASE
WHEN sfb08 = sfb09
THEN sfu02
ELSE ''
END AS x14
FROM (SELECT DISTINCT NVL (nsfb02, '尚未填寫') nsfb02,
NVL (nsfb03, '尚未填寫') nsfb03, sfb01, sfb05,
ima021, NVL (srg16, 'X') srg16,
DECODE (sfb04,
'1', '確認生產',
'2', '工單已發放-料表尚未列印',
'3', '工單已發放-料表以列印',
'4', '工單已發料',
'5', '在製過程中',
'6', '工單已完工(FQC)',
'7', '完工入庫',
'8', '結案'
) sfb04,
TO_CHAR (sfb13, 'YYYY/MM/DD') AS sfb13,
TO_CHAR (sfb15, 'YYYY/MM/DD') AS sfb15,
TO_CHAR (sfb25, 'YYYY/MM/DD') AS sfb25, sfb08,
sfb081, sfb09, NVL (sfb28, '未結') AS sfb28,
TO_CHAR (sfu02, 'YYYY/MM/DD') AS sfu02
FROM ds01.sfb_file,
ds01.ima_file,
ds01.srg_file,
ds.tc_nsfb_file,
(SELECT sfv11, sfu02
FROM (SELECT sfu01, sfu02, sfv11,
ROW_NUMBER () OVER (PARTITION BY sfv11 ORDER BY sfu02 DESC)
rn
FROM ds01.sfv_file, ds01.sfu_file
WHERE sfv01 = sfu01
AND sfuconf = 'Y'
AND sfupost = 'Y')
WHERE rn <= 1) mfg
WHERE sfb01 = nsfb01(+)
AND sfb05 = ima01(+)
AND sfb04 > 3
AND sfb87 = 'Y'
AND sfb28 IS NULL
AND sfb15 <= SYSDATE
AND sfb01 = srg16(+)
AND sfb01 = mfg.sfv11(+))
ORDER BY 1
全站熱搜
留言列表
站台介紹 (1)