View: IC_TRAN_CMP_VW1

Product:	GMI - Process Manufacturing Inventory
Description:	Completed inventory transaction
Implementation/DBA Data:	APPS.IC_TRAN_CMP_VW1

View Text

SELECT ITEM_ID
, LINE_ID
, TRANS_ID
, CO_CODE
, ORGN_CODE
, WHSE_CODE
, LOT_ID
, LOCATION
, DOC_ID
, DOC_TYPE
, DOC_LINE
, LINE_TYPE
, REASON_CODE
, CREATION_DATE
, TRANS_DATE
, TRANS_QTY
, TRANS_QTY2
, QC_GRADE
, LOT_STATUS
, TRANS_STAT
, TRANS_UM
, TRANS_UM2
, OP_CODE
, TEXT_CODE
, 'C' C
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM IC_TRAN_CMP UNION SELECT ITEM_ID
, LINE_ID
, TRANS_ID
, CO_CODE
, ORGN_CODE
, WHSE_CODE
, LOT_ID
, LOCATION
, DOC_ID
, DOC_TYPE
, DOC_LINE
, LINE_TYPE
, REASON_CODE
, CREATION_DATE
, TRANS_DATE
, TRANS_QTY
, TRANS_QTY2
, QC_GRADE
, LOT_STATUS
, TRANS_STAT
, TRANS_UM
, TRANS_UM2
, OP_CODE
, TEXT_CODE
, 'P' P
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM IC_TRAN_PND
WHERE COMPLETED_IND = 1
AND DELETE_MARK = 0

Columns