VIEW: APPS.PMIBV_INVENTORY_TRANSACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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