VIEW: APPS.IGC_CC_EVENT_JE_HEADER_V

Source

View Text - Preformatted

SELECT DISTINCT EVENT_ID , CC_HEADER_ID , DOCUMENT_TYPE , SET_OF_BOOKS_ID LEDGER_ID , BUDGET_DEST_FLAG , CC_TRANSACTION_DATE ACCOUNTING_DATE , ACTUAL_FLAG , PERIOD_NAME , REFERENCE_1 , REFERENCE_3 , REFERENCE_4 , Decode(DOCUMENT_TYPE,'CC','Contract Commitment', 'PA','Project Accounting', 'REQ','Requisitions', 'PO','Purchasing') HEADER_DESC FROM IGC_CC_INTERFACE

View Text - HTML Formatted

SELECT DISTINCT EVENT_ID
, CC_HEADER_ID
, DOCUMENT_TYPE
, SET_OF_BOOKS_ID LEDGER_ID
, BUDGET_DEST_FLAG
, CC_TRANSACTION_DATE ACCOUNTING_DATE
, ACTUAL_FLAG
, PERIOD_NAME
, REFERENCE_1
, REFERENCE_3
, REFERENCE_4
, DECODE(DOCUMENT_TYPE
, 'CC'
, 'CONTRACT COMMITMENT'
, 'PA'
, 'PROJECT ACCOUNTING'
, 'REQ'
, 'REQUISITIONS'
, 'PO'
, 'PURCHASING') HEADER_DESC
FROM IGC_CC_INTERFACE