View: PMIFV_BATCH_OPRN_DETAIL_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Batch Operation Details
Implementation/DBA Data:	APPS.PMIFV_BATCH_OPRN_DETAIL_V

View Text

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

Columns