SELECT
A.SERIAL_NUMBER "Barcode",
B.PART_NO "Model Name",
C.PDLINE_NAME "Line",
C.PDLINE_DESC "Line DESC",
A.STAGE_ID,
A.PROCESS_ID,
A.TERMINAL_ID,
A.OUT_PROCESS_TIME,
A.EMP_ID
FROM G_SN_TRAVEL A,
SYS_PART B,
SYS_PDLINE C
WHERE
A.MODEL_ID=B.PART_ID(+) AND
A.PDLINE_ID=C.PDLINE_ID(+) AND
TRUNC(A.OUT_PROCESS_TIME)=TO_DATE('2008-12-29','yyyy-mm-dd')
ORDER BY OUT_PROCESS_TIME
沒有留言:
張貼留言