View: PMIFV_INVENTORY_TRANSACTIONS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This view contains detail information about all completed and pending Inventory transaction .
Implementation/DBA Data:	APPS.PMIFV_INVENTORY_TRANSACTIONS_V

View Text

SELECT 'C'
, COMPLETEDTRANS.TRANS_ID
, COMPLETEDTRANS.ITEM_ID
, COMPLETEDTRANS.LINE_ID
, COMPLETEDTRANS.CO_CODE
, COMPLETEDTRANS.ORGN_CODE
, COMPLETEDTRANS.WHSE_CODE
, COMPLETEDTRANS.LOT_ID
, COMPLETEDTRANS.LOCATION
, COMPLETEDTRANS.DOC_ID
, COMPLETEDTRANS.DOC_TYPE
, COMPLETEDTRANS.DOC_LINE
, COMPLETEDTRANS.LINE_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('LINE_TYPE'
, COMPLETEDTRANS.LINE_TYPE)
, 1
, 80)
, COMPLETEDTRANS.REASON_CODE
, TRUNC(COMPLETEDTRANS.TRANS_DATE)
, DECODE(ITEM.ITEM_UM
, COMPLETEDTRANS.TRANS_UM
, COMPLETEDTRANS.TRANS_QTY
, GMICUOM.I2UOM_CV(COMPLETEDTRANS.ITEM_ID
, 0
, ITEM.ITEM_UM
, COMPLETEDTRANS.TRANS_QTY
, COMPLETEDTRANS.TRANS_UM))
, COMPLETEDTRANS.TRANS_QTY2
, COMPLETEDTRANS.QC_GRADE
, COMPLETEDTRANS.LOT_STATUS
, COMPLETEDTRANS.TRANS_STAT
, COMPLETEDTRANS.TRANS_UM
, COMPLETEDTRANS.TRANS_UM2
, COMPLETEDTRANS.OP_CODE
, COMPLETEDTRANS.GL_POSTED_IND
, COMPLETEDTRANS.EVENT_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, CURRCAL.FISCAL_YEAR
, CURRCAL.PERIOD
, CURRCAL.PERIOD_DESC
, CURRCAL.START_DATE
, CURRCAL.END_DATE
, COMPLETEDTRANS.CREATED_BY
, COMPLETEDTRANS.CREATION_DATE
, COMPLETEDTRANS.LAST_UPDATE_DATE
, COMPLETEDTRANS.LAST_UPDATED_BY
FROM IC_TRAN_CMP COMPLETEDTRANS
, IC_ITEM_MST ITEM
, PMI_INV_CALENDAR_V CURRCAL
WHERE COMPLETEDTRANS.ITEM_ID = ITEM.ITEM_ID
AND COMPLETEDTRANS.CO_CODE = CURRCAL.ORGN_CODE
AND TRUNC( COMPLETEDTRANS.TRANS_DATE) BETWEEN CURRCAL.START_DATE
AND CURRCAL.END_DATE
AND (COMPLETEDTRANS.ORGN_CODE IS NULL OR PMI_SECURITY_PKG.SHOW_RECORD(COMPLETEDTRANS.ORGN_CODE) = 'TRUE') UNION ALL SELECT 'P'
, PENDINGTRANS.TRANS_ID
, PENDINGTRANS.ITEM_ID
, PENDINGTRANS.LINE_ID
, PENDINGTRANS.CO_CODE
, PENDINGTRANS.ORGN_CODE
, PENDINGTRANS.WHSE_CODE
, PENDINGTRANS.LOT_ID
, PENDINGTRANS.LOCATION
, PENDINGTRANS.DOC_ID
, PENDINGTRANS.DOC_TYPE
, PENDINGTRANS.DOC_LINE
, PENDINGTRANS.LINE_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('LINE_TYPE'
, PENDINGTRANS.LINE_TYPE)
, 1
, 80)
, PENDINGTRANS.REASON_CODE
, TRUNC(PENDINGTRANS.TRANS_DATE)
, DECODE(ITEM.ITEM_UM
, PENDINGTRANS.TRANS_UM
, PENDINGTRANS.TRANS_QTY
, GMICUOM.I2UOM_CV(PENDINGTRANS.ITEM_ID
, 0
, ITEM.ITEM_UM
, PENDINGTRANS.TRANS_QTY
, PENDINGTRANS.TRANS_UM))
, PENDINGTRANS.TRANS_QTY2
, PENDINGTRANS.QC_GRADE
, PENDINGTRANS.LOT_STATUS
, PENDINGTRANS.TRANS_STAT
, PENDINGTRANS.TRANS_UM
, PENDINGTRANS.TRANS_UM2
, PENDINGTRANS.OP_CODE
, PENDINGTRANS.GL_POSTED_IND
, PENDINGTRANS.EVENT_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, CURRCAL.FISCAL_YEAR
, CURRCAL.PERIOD
, CURRCAL.PERIOD_DESC
, CURRCAL.START_DATE
, CURRCAL.END_DATE
, PENDINGTRANS.CREATED_BY
, PENDINGTRANS.CREATION_DATE
, PENDINGTRANS.LAST_UPDATE_DATE
, PENDINGTRANS.LAST_UPDATED_BY
FROM IC_TRAN_PND PENDINGTRANS
, IC_ITEM_MST ITEM
, PMI_INV_CALENDAR_V CURRCAL
WHERE PENDINGTRANS.ITEM_ID = ITEM.ITEM_ID
AND PENDINGTRANS.COMPLETED_IND = 1
AND PENDINGTRANS.DELETE_MARK = 0
AND PENDINGTRANS.CO_CODE = CURRCAL.ORGN_CODE
AND TRUNC( PENDINGTRANS.TRANS_DATE) BETWEEN CURRCAL.START_DATE
AND CURRCAL.END_DATE
AND (PENDINGTRANS.ORGN_CODE IS NULL OR PENDINGTRANS.ORGN_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