View: IC_TRAN_VW1

Product:	GMI - Process Manufacturing Inventory
Description:	Transaction view.
Implementation/DBA Data:	APPS.IC_TRAN_VW1

View Text

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

Columns