eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMIFV_BATCH_QC_V

Source

View Text - Preformatted


SELECT BtchHdr.PLANT_CODE, OrgnMst.CO_CODE, BtchHdr.WIP_WHSE_CODE, BtchHdr.BATCH_ID, BtchHdr.BATCH_NO, BtchHdr.ACTUAL_CMPLT_DATE, BtchDtl.ITEM_ID, ItemMst.ITEM_NO, ItemMst.ITEM_DESC1, ItemMst.PLANNING_CLASS, PMI_PRODUCTION_SUM.NO_OF_SAMPLES_TAKEN(BtchHdr.BATCH_ID), PMI_PRODUCTION_SUM.NO_OF_SAMPLES_COMPLET(BtchHdr.BATCH_ID), PMI_PRODUCTION_SUM.NO_OF_SAMPLES_PASSED(BtchHdr.BATCH_ID), PMI_PRODUCTION_SUM.NO_OF_TIMES_ADJUSTED(BtchHdr.BATCH_ID), Calendr.PERIOD_YEAR, Calendr.PERIOD_NUM, Calendr.PERIOD_NAME FROM GME_BATCH_HEADER BtchHdr, GME_MATERIAL_DETAILS BtchDtl, IC_ITEM_MST ItemMst, SY_ORGN_MST OrgnMst, PMI_GL_CALENDAR_V Calendr, FM_FORM_MST_B Formula WHERE BtchHdr.BATCH_ID = BtchDtl.BATCH_ID AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID AND Formula.formula_id = BtchHdr.formula_id AND BtchHdr.BATCH_STATUS > 2 AND BtchDtl.LINE_TYPE=1 AND BtchHdr.PLANT_CODE = OrgnMst.ORGN_CODE AND OrgnMst.CO_CODE = calendr.CO_CODE AND trunc(BtchHdr.ACTUAL_CMPLT_DATE) between Calendr.start_date and Calendr.end_date AND (BtchHdr.PLANT_CODE IN (SELECT secorg.orgn_code FROM sy_orgn_mst secorg WHERE PMI_SECURITY_PKG.show_record(secorg.orgn_code) = 'TRUE')) with read only

View Text - HTML Formatted

SELECT BTCHHDR.PLANT_CODE
, ORGNMST.CO_CODE
, BTCHHDR.WIP_WHSE_CODE
, BTCHHDR.BATCH_ID
, BTCHHDR.BATCH_NO
, BTCHHDR.ACTUAL_CMPLT_DATE
, BTCHDTL.ITEM_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, PMI_PRODUCTION_SUM.NO_OF_SAMPLES_TAKEN(BTCHHDR.BATCH_ID)
, PMI_PRODUCTION_SUM.NO_OF_SAMPLES_COMPLET(BTCHHDR.BATCH_ID)
, PMI_PRODUCTION_SUM.NO_OF_SAMPLES_PASSED(BTCHHDR.BATCH_ID)
, PMI_PRODUCTION_SUM.NO_OF_TIMES_ADJUSTED(BTCHHDR.BATCH_ID)
, CALENDR.PERIOD_YEAR
, CALENDR.PERIOD_NUM
, CALENDR.PERIOD_NAME
FROM GME_BATCH_HEADER BTCHHDR
, GME_MATERIAL_DETAILS BTCHDTL
, IC_ITEM_MST ITEMMST
, SY_ORGN_MST ORGNMST
, PMI_GL_CALENDAR_V CALENDR
, FM_FORM_MST_B FORMULA
WHERE BTCHHDR.BATCH_ID = BTCHDTL.BATCH_ID
AND BTCHDTL.ITEM_ID = ITEMMST.ITEM_ID
AND FORMULA.FORMULA_ID = BTCHHDR.FORMULA_ID
AND BTCHHDR.BATCH_STATUS > 2
AND BTCHDTL.LINE_TYPE=1
AND BTCHHDR.PLANT_CODE = ORGNMST.ORGN_CODE
AND ORGNMST.CO_CODE = CALENDR.CO_CODE
AND TRUNC(BTCHHDR.ACTUAL_CMPLT_DATE) BETWEEN CALENDR.START_DATE
AND CALENDR.END_DATE
AND (BTCHHDR.PLANT_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY