VIEW: APPS.IC_TRAN_CMP_VW1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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