View: PMI_REP_PROD_STATUS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This is view for PMI Production Status Report
Implementation/DBA Data:	APPS.PMI_REP_PROD_STATUS_V

View Text

SELECT ORG.CO_CODE COMPANY_ID
, ORG.ORGN_CODE ORGANIZATION_ID
, GLCLDR.YEAR_ID YEAR_ID
, GLCLDR.QUARTER_ID QUARTER_ID
, GLCLDR.PERIOD_ID PERIOD_ID
, COUNT(DISTINCT(DECODE(BTCH.BATCH_STATUS
, 1
, BTCH.BATCH_ID
, NULL))) PND_BATCHES
, SUM(DECODE(BTCH.BATCH_STATUS
, 1
, IPND.TRANS_QTY * -1 * PMI_COMMON_PKG.PMICO_GET_COST(BDTL.ITEM_ID
, IPND.WHSE_CODE
, FISCALPLCY.GL_COST_MTHD
, PLAN_CMPLT_DATE)
, 0)) PND_VALUE
, COUNT(DISTINCT(DECODE(BTCH.BATCH_STATUS
, 2
, BTCH.BATCH_ID
, NULL))) WIP_BATCHES
, SUM(DECODE(BTCH.BATCH_STATUS
, 2
, IPND.TRANS_QTY * -1 * PMI_COMMON_PKG.PMICO_GET_COST(BDTL.ITEM_ID
, IPND.WHSE_CODE
, FISCALPLCY.GL_COST_MTHD
, PLAN_CMPLT_DATE)
, 0)) WIP_VALUE
, COUNT(DISTINCT(DECODE(BTCH.BATCH_STATUS
, 3
, BTCH.BATCH_ID
, 4
, BTCH.BATCH_ID
, NULL))) CMP_BATCHES
, SUM(DECODE(BTCH.BATCH_STATUS
, 3
, IPND.TRANS_QTY * -1 * PMI_COMMON_PKG.PMICO_GET_COST(BDTL.ITEM_ID
, IPND.WHSE_CODE
, FISCALPLCY.GL_COST_MTHD
, PLAN_CMPLT_DATE)
, 4
, IPND.TRANS_QTY * -1 * PMI_COMMON_PKG.PMICO_GET_COST(BDTL.ITEM_ID
, IPND.WHSE_CODE
, FISCALPLCY.GL_COST_MTHD
, PLAN_CMPLT_DATE)
, 0)) CMP_VALUE
FROM GME_BATCH_HEADER BTCH
, GME_MATERIAL_DETAILS BDTL
, SY_ORGN_MST ORG
, GL_PLCY_MST FISCALPLCY
, IC_TRAN_PND IPND
, PMI_GL_TIME_V GLCLDR
WHERE BTCH.PLANT_CODE = ORG.ORGN_CODE
AND ORG.CO_CODE = FISCALPLCY.CO_CODE
AND BTCH.BATCH_ID = BDTL.BATCH_ID
AND GLCLDR.SET_OF_BOOKS_NAME = FISCALPLCY.SET_OF_BOOKS_NAME
AND BTCH.BATCH_STATUS IN (1
, 2
, 3
, 4)
AND BTCH.BATCH_TYPE = 0
AND BTCH.BATCH_STATUS > 0
AND BDTL.LINE_TYPE = -1
AND IPND.TRANS_QTY <> 0
AND IPND.DOC_TYPE = 'PROD'
AND IPND.DOC_ID = BTCH.BATCH_ID
AND IPND.LINE_ID = BDTL.MATERIAL_DETAIL_ID
AND TRUNC(DECODE(BATCH_STATUS
, 1
, PLAN_CMPLT_DATE
, 2
, ACTUAL_START_DATE
, ACTUAL_CMPLT_DATE)) BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(ORG.ORGN_CODE) GROUP BY ORG.CO_CODE
, ORG.ORGN_CODE
, GLCLDR.PERIOD_SET_NAME||'+' ||GLCLDR.YEAR_NAME
, GLCLDR.PERIOD_SET_NAME||'+' ||GLCLDR.QUARTER_NAME
, GLCLDR.PERIOD_SET_NAME||'+' ||GLCLDR.PERIOD_NAME

Columns