View: PMIBV_INVENTORY_TRANSACTIONS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	All inventory transactions from the completed transactions table and the pending transactions table.
Implementation/DBA Data:	APPS.PMIBV_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
, COMPLETEDTRANS.REASON_CODE
, COMPLETEDTRANS.TRANS_DATE
, COMPLETEDTRANS.TRANS_QTY
, 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
, COMPLETEDTRANS.CREATED_BY
, COMPLETEDTRANS.CREATION_DATE
, COMPLETEDTRANS.LAST_UPDATE_DATE
, COMPLETEDTRANS.LAST_UPDATED_BY
FROM IC_TRAN_CMP COMPLETEDTRANS UNION 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
, PENDINGTRANS.REASON_CODE
, PENDINGTRANS.TRANS_DATE
, PENDINGTRANS.TRANS_QTY
, 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
, PENDINGTRANS.CREATED_BY
, PENDINGTRANS.CREATION_DATE
, PENDINGTRANS.LAST_UPDATE_DATE
, PENDINGTRANS.LAST_UPDATED_BY
FROM IC_TRAN_PND PENDINGTRANS
WHERE PENDINGTRANS.COMPLETED_IND = 1
AND PENDINGTRANS.DELETE_MARK = 0 WITH READ ONLY

Columns