VIEW: APPS.PMIFV_BATCH_MATERIAL_V

Source

View Text - Preformatted

SELECT batchheader.BATCH_ID, batchheader.PLANT_CODE, batchheader.BATCH_NO, batchheader.BATCH_TYPE, batchheader.PROD_ID, batchheader.PROD_SEQUENCE, batchheader.FORMULA_ID, batchheader.ROUTING_ID, batchheader.PLAN_START_DATE, batchheader.ACTUAL_START_DATE, batchheader.DUE_DATE, batchheader.PLAN_CMPLT_DATE, batchheader.ACTUAL_CMPLT_DATE, batchheader.BATCH_STATUS, substr(pmi_cost_analz_pack.gmca_get_meaning('BATCH_STATUS', batchheader.BATCH_STATUS),1,80), batchheader.PRIORITY_VALUE, batchheader.PRIORITY_CODE, batchheader.PRINT_COUNT, batchheader.RECIPE_VALIDITY_RULE_ID, batchheader.FMCONTROL_CLASS, batchheader.WIP_WHSE_CODE, batchheader.BATCH_CLOSE_DATE, batchheader.PARENTLINE_ID, materialdetail.MATERIAL_DETAIL_ID, materialdetail.FORMULALINE_ID, materialdetail.LINE_NO, materialdetail.ITEM_ID, materialdetail.LINE_TYPE, substr(pmi_cost_analz_pack.gmca_get_meaning('LINE_TYPE', materialdetail.LINE_TYPE),1,80), materialdetail.PLAN_QTY, NULL, materialdetail.ITEM_UM, NULL, item.ITEM_NO, item.ITEM_DESC1, materialdetail.ACTUAL_QTY, NULL, materialdetail.RELEASE_TYPE, materialdetail.SCRAP_FACTOR, materialdetail.SCALE_TYPE, materialdetail.PHANTOM_TYPE, materialdetail.COST_ALLOC, materialdetail.ALLOC_IND, materialdetail.COST, materialdetail.PHANTOM_ID, batchheader.CREATED_BY, batchheader.CREATION_DATE, batchheader.LAST_UPDATE_DATE, batchheader.LAST_UPDATED_BY FROM GME_BATCH_HEADER batchheader, GME_MATERIAL_DETAILS materialdetail, ic_item_mst item, FM_FORM_MST_B Formula WHERE batchheader.batch_id = materialdetail.batch_id and materialdetail.item_id = item.item_id and Formula.formula_id = batchheader.formula_id and batchheader.delete_mark = 0 AND 'TRUE' = PMI_SECURITY_PKG.show_record(batchheader.plant_code) with read only

View Text - HTML Formatted

SELECT BATCHHEADER.BATCH_ID
, BATCHHEADER.PLANT_CODE
, BATCHHEADER.BATCH_NO
, BATCHHEADER.BATCH_TYPE
, BATCHHEADER.PROD_ID
, BATCHHEADER.PROD_SEQUENCE
, BATCHHEADER.FORMULA_ID
, BATCHHEADER.ROUTING_ID
, BATCHHEADER.PLAN_START_DATE
, BATCHHEADER.ACTUAL_START_DATE
, BATCHHEADER.DUE_DATE
, BATCHHEADER.PLAN_CMPLT_DATE
, BATCHHEADER.ACTUAL_CMPLT_DATE
, BATCHHEADER.BATCH_STATUS
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('BATCH_STATUS'
, BATCHHEADER.BATCH_STATUS)
, 1
, 80)
, BATCHHEADER.PRIORITY_VALUE
, BATCHHEADER.PRIORITY_CODE
, BATCHHEADER.PRINT_COUNT
, BATCHHEADER.RECIPE_VALIDITY_RULE_ID
, BATCHHEADER.FMCONTROL_CLASS
, BATCHHEADER.WIP_WHSE_CODE
, BATCHHEADER.BATCH_CLOSE_DATE
, BATCHHEADER.PARENTLINE_ID
, MATERIALDETAIL.MATERIAL_DETAIL_ID
, MATERIALDETAIL.FORMULALINE_ID
, MATERIALDETAIL.LINE_NO
, MATERIALDETAIL.ITEM_ID
, MATERIALDETAIL.LINE_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('LINE_TYPE'
, MATERIALDETAIL.LINE_TYPE)
, 1
, 80)
, MATERIALDETAIL.PLAN_QTY
, NULL
, MATERIALDETAIL.ITEM_UM
, NULL
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, MATERIALDETAIL.ACTUAL_QTY
, NULL
, MATERIALDETAIL.RELEASE_TYPE
, MATERIALDETAIL.SCRAP_FACTOR
, MATERIALDETAIL.SCALE_TYPE
, MATERIALDETAIL.PHANTOM_TYPE
, MATERIALDETAIL.COST_ALLOC
, MATERIALDETAIL.ALLOC_IND
, MATERIALDETAIL.COST
, MATERIALDETAIL.PHANTOM_ID
, BATCHHEADER.CREATED_BY
, BATCHHEADER.CREATION_DATE
, BATCHHEADER.LAST_UPDATE_DATE
, BATCHHEADER.LAST_UPDATED_BY
FROM GME_BATCH_HEADER BATCHHEADER
, GME_MATERIAL_DETAILS MATERIALDETAIL
, IC_ITEM_MST ITEM
, FM_FORM_MST_B FORMULA
WHERE BATCHHEADER.BATCH_ID = MATERIALDETAIL.BATCH_ID
AND MATERIALDETAIL.ITEM_ID = ITEM.ITEM_ID
AND FORMULA.FORMULA_ID = BATCHHEADER.FORMULA_ID
AND BATCHHEADER.DELETE_MARK = 0
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(BATCHHEADER.PLANT_CODE) WITH READ ONLY