eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGC_CC_EVENT_JE_LINES_V

Source

View Text - Preformatted


SELECT EVENT_ID , ROWNUM LINE_NUMBER , CC_ACCT_LINE_ID , CC_DET_PF_LINE_ID , CODE_COMBINATION_ID , BATCH_LINE_NUM , CC_FUNC_DR_AMT , CC_FUNC_CR_AMT , nvl(CC_FUNC_DR_AMT, CC_FUNC_CR_AMT) CC_FUNC_AMT , ENCUMBRANCE_TYPE_ID , CBC_RESULT_CODE , STATUS_CODE , BUDGET_VERSION_ID , CURRENCY_CODE , TRANSACTION_DESCRIPTION , PA_FLAG , BATCH_ID PACKET_ID , PROJECT_LINE , 8407 APPLIED_TO_APPL_ID , 'CC_CONTRACTS' APPLIED_TO_ENTITY_CODE , CC_HEADER_ID APPLIED_TO_HEADER_ID_1 , 'CC' APPLIED_TO_DIST_LINK_TYPE , CC_ACCT_LINE_ID APPLIED_TO_DIST_ID_1 FROM IGC_CC_INTERFACE

View Text - HTML Formatted

SELECT EVENT_ID
, ROWNUM LINE_NUMBER
, CC_ACCT_LINE_ID
, CC_DET_PF_LINE_ID
, CODE_COMBINATION_ID
, BATCH_LINE_NUM
, CC_FUNC_DR_AMT
, CC_FUNC_CR_AMT
, NVL(CC_FUNC_DR_AMT
, CC_FUNC_CR_AMT) CC_FUNC_AMT
, ENCUMBRANCE_TYPE_ID
, CBC_RESULT_CODE
, STATUS_CODE
, BUDGET_VERSION_ID
, CURRENCY_CODE
, TRANSACTION_DESCRIPTION
, PA_FLAG
, BATCH_ID PACKET_ID
, PROJECT_LINE
, 8407 APPLIED_TO_APPL_ID
, 'CC_CONTRACTS' APPLIED_TO_ENTITY_CODE
, CC_HEADER_ID APPLIED_TO_HEADER_ID_1
, 'CC' APPLIED_TO_DIST_LINK_TYPE
, CC_ACCT_LINE_ID APPLIED_TO_DIST_ID_1
FROM IGC_CC_INTERFACE