View: PMIFV_BATCH_QC_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Batch QC Details Consolidated
Implementation/DBA Data:	APPS.PMIFV_BATCH_QC_V

View Text

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

Columns