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_OPRN_DETAIL_V

Source

View Text - Preformatted


SELECT BtchHdr.PLANT_CODE, ORGNMST.CO_CODE, BtchHdr.WIP_WHSE_CODE, BtchHdr.BATCH_ID, BtchHdr.BATCH_NO, BtchHdr.PLAN_START_DATE, BtchHdr.ACTUAL_START_DATE, BtchHdr.PLAN_CMPLT_DATE, BtchHdr.ACTUAL_CMPLT_DATE, BtchHdr.BATCH_STATUS, BtchDtl.ITEM_ID, ItemMst.ITEM_NO, ItemMst.ITEM_DESC1, ItemMst.PLANNING_CLASS, Btchsteps.BATCHSTEP_NO, OprnDtl.RESOURCES , RsrcMst.RESOURCE_DESC , RsrcMst.RESOURCE_CLASS , BtchActs.ACTIVITY , OprnDtl.PRIM_RSRC_IND , OprnDtl.SCALE_TYPE , OprnDtl.PLAN_RSRC_COUNT, OprnDtl.ACTUAL_RSRC_COUNT , nvl(OprnDtl.PLAN_RSRC_QTY,0), nvl(OprnDtl.ACTUAL_RSRC_QTY,0), nvl(OprnDtl.PLAN_RSRC_USAGE,0) , nvl(OprnDtl.ACTUAL_RSRC_USAGE,0) , OprnDtl.USAGE_UOM , OprnDtl.PLAN_START_DATE , OprnDtl.ACTUAL_START_DATE, OprnDtl.PLAN_CMPLT_DATE , OprnDtl.ACTUAL_CMPLT_DATE, Calendr.PERIOD_YEAR, Calendr.PERIOD_NUM, Calendr.PERIOD_NAME FROM GME_BATCH_HEADER BtchHdr, GME_MATERIAL_DETAILS BtchDtl, GME_BATCH_STEPS Btchsteps, GME_BATCH_STEP_ACTIVITIES BtchActs, IC_ITEM_MST ItemMst, GME_BATCH_STEP_RESOURCES OprnDtl, SY_ORGN_MST OrgnMst, CR_RSRC_MST RsrcMst, PMI_GL_CALENDAR_V Calendr, FM_FORM_MST_B Formula WHERE BtchHdr.BATCH_ID = Btchsteps.BATCH_ID(+) AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID AND BtchHdr.PLANT_CODE = OrgnMst.ORGN_CODE AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID AND OprnDtl.RESOURCES = RsrcMst.RESOURCES(+) AND Btchsteps.BATCH_ID = BtchActs.BATCH_ID (+) AND Btchsteps.BATCHSTEP_ID = BtchActs.BATCHSTEP_ID(+) AND BtchActs.BATCH_ID = OprnDtl.BATCH_ID(+) AND BtchActs.BATCHSTEP_ID = OprnDtl.BATCHSTEP_ID(+) AND BtchActs.BATCHSTEP_ACTIVITY_ID = OprnDtl.BATCHSTEP_ACTIVITY_ID(+) AND BtchHdr.BATCH_STATUS in (3,4) AND BtchDtl.LINE_TYPE=1 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')) AND BtchHdr.FORMULA_ID=Formula.Formula_ID 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.PLAN_START_DATE
, BTCHHDR.ACTUAL_START_DATE
, BTCHHDR.PLAN_CMPLT_DATE
, BTCHHDR.ACTUAL_CMPLT_DATE
, BTCHHDR.BATCH_STATUS
, BTCHDTL.ITEM_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, BTCHSTEPS.BATCHSTEP_NO
, OPRNDTL.RESOURCES
, RSRCMST.RESOURCE_DESC
, RSRCMST.RESOURCE_CLASS
, BTCHACTS.ACTIVITY
, OPRNDTL.PRIM_RSRC_IND
, OPRNDTL.SCALE_TYPE
, OPRNDTL.PLAN_RSRC_COUNT
, OPRNDTL.ACTUAL_RSRC_COUNT
, NVL(OPRNDTL.PLAN_RSRC_QTY
, 0)
, NVL(OPRNDTL.ACTUAL_RSRC_QTY
, 0)
, NVL(OPRNDTL.PLAN_RSRC_USAGE
, 0)
, NVL(OPRNDTL.ACTUAL_RSRC_USAGE
, 0)
, OPRNDTL.USAGE_UOM
, OPRNDTL.PLAN_START_DATE
, OPRNDTL.ACTUAL_START_DATE
, OPRNDTL.PLAN_CMPLT_DATE
, OPRNDTL.ACTUAL_CMPLT_DATE
, CALENDR.PERIOD_YEAR
, CALENDR.PERIOD_NUM
, CALENDR.PERIOD_NAME
FROM GME_BATCH_HEADER BTCHHDR
, GME_MATERIAL_DETAILS BTCHDTL
, GME_BATCH_STEPS BTCHSTEPS
, GME_BATCH_STEP_ACTIVITIES BTCHACTS
, IC_ITEM_MST ITEMMST
, GME_BATCH_STEP_RESOURCES OPRNDTL
, SY_ORGN_MST ORGNMST
, CR_RSRC_MST RSRCMST
, PMI_GL_CALENDAR_V CALENDR
, FM_FORM_MST_B FORMULA
WHERE BTCHHDR.BATCH_ID = BTCHSTEPS.BATCH_ID(+)
AND BTCHHDR.BATCH_ID = BTCHDTL.BATCH_ID
AND BTCHHDR.PLANT_CODE = ORGNMST.ORGN_CODE
AND BTCHDTL.ITEM_ID = ITEMMST.ITEM_ID
AND OPRNDTL.RESOURCES = RSRCMST.RESOURCES(+)
AND BTCHSTEPS.BATCH_ID = BTCHACTS.BATCH_ID (+)
AND BTCHSTEPS.BATCHSTEP_ID = BTCHACTS.BATCHSTEP_ID(+)
AND BTCHACTS.BATCH_ID = OPRNDTL.BATCH_ID(+)
AND BTCHACTS.BATCHSTEP_ID = OPRNDTL.BATCHSTEP_ID(+)
AND BTCHACTS.BATCHSTEP_ACTIVITY_ID = OPRNDTL.BATCHSTEP_ACTIVITY_ID(+)
AND BTCHHDR.BATCH_STATUS IN (3
, 4)
AND BTCHDTL.LINE_TYPE=1
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'))
AND BTCHHDR.FORMULA_ID=FORMULA.FORMULA_ID WITH READ ONLY