Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT QR.QC_RESULT_ID||'-'||INST.INSTANCE_CODE||'-'||'OPM'
, BH.PLANT_CODE||'-'||BH.PLANT_CODE||'-'||'PORG'||'-'||INST.INSTANCE_CODE||'-'||'OPM'
, '0'||'-'||IM.ITEM_NO||'-'||BH.WIP_WHSE_CODE
, QR.ORGN_CODE||'-'||QR.ASSAY_CODE||'-'||INST.INSTANCE_CODE||'-'||'OPM'
, SUBSTR(EDW_TIME_PKG.CAL_DAY_FK(BH.ACTUAL_CMPLT_DATE
, SOB.SET_OF_BOOKS_ID)
, 1
, 120)
, RH.ROUTING_NO||'-'||RH.ROUTING_VERS||'-'||INST.INSTANCE_CODE||'-'||'OPM'
, QS.SAMPLE_STATUS||'-'||'GMD_SAMPLE_STATUS'||'-'||'OPM'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, DECODE(QR.NUM_RESULT
, NULL
, QR.TEXT_RESULT
, QR.NUM_RESULT)
, PMI_PRODUCTION_SUM.NO_OF_TIMES_ADJUSTED(BH.BATCH_ID)
, QR.ACCEPT_ANYWAY
, 0
, 0
, 0
, 0
, 0
, BH.BATCH_NO
, QR.ROUTINGSTEP_NO
, OP.OPRN_NO
, QR.QCUNIT_CODE
, BH.ACTUAL_CMPLT_DATE
, QR.RESULT_DATE
, QS.SAMPLE_NO
, QS.SAMPLE_DESC
, INST.INSTANCE_CODE
, GREATEST(QR.LAST_UPDATE_DATE
, QS.LAST_UPDATE_DATE
, NVL(RH.LAST_UPDATE_DATE
, QR.LAST_UPDATE_DATE)
, NVL(OP.LAST_UPDATE_DATE
, QR.LAST_UPDATE_DATE)
, BH.LAST_UPDATE_DATE
, IM.LAST_UPDATE_DATE
, OM.LAST_UPDATE_DATE
, PM.LAST_UPDATE_DATE
, SOB.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM QC_RSLT_MST QR
, QC_SMPL_MST QS
, FM_ROUT_HDR RH
, FM_OPRN_MST OP
, PM_BTCH_HDR BH
, IC_ITEM_MST IM
, SY_ORGN_MST OM
, GL_PLCY_MST PM
, GL_SETS_OF_BOOKS SOB
, EDW_LOCAL_INSTANCE INST
WHERE QR.BATCH_ID = BH.BATCH_ID
AND QR.ITEM_ID = IM.ITEM_ID
AND QR.SAMPLE_ID = QS.SAMPLE_ID
AND QR.ROUTING_ID = RH.ROUTING_ID(+)
AND QR.OPRN_ID = OP.OPRN_ID(+)
AND BH.PLANT_CODE = OM.ORGN_CODE
AND OM.CO_CODE = PM.CO_CODE
AND PM.SET_OF_BOOKS_NAME =SOB.NAME
AND BH.BATCH_STATUS IN (3
, 4)