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.

VIEW: APPS.CST_XLA_WIP_LINES_V

Source

View Text - Preformatted


SELECT WTA.base_transaction_value accounted_amount, NVL(WTA.transaction_value, WTA.base_transaction_value) entered_amount, WTA.accounting_line_type accounting_line_type_code, WTA.reference_account code_combination_id, WTA.cost_element_id, WTA.rate_or_amount, XEG.event_id, XEG.ledger_id, ROW_NUMBER() OVER(Partition by EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER, WTA.wip_sub_ledger_id distribution_identifier, WTA.wip_entity_id line_wip_entity_id FROM WIP_TRANSACTION_ACCOUNTS WTA, XLA_EVENTS_GT XEG WHERE WTA.transaction_id = XEG.source_id_int_1 AND XEG.entity_code = 'WIP_ACCOUNTING_EVENTS' AND NVL(WTA.resource_id, -1) = NVL(XEG.source_id_int_2, -1) AND NVL(WTA.basis_type, -1) = NVL(XEG.source_id_int_3, -1)

View Text - HTML Formatted

SELECT WTA.BASE_TRANSACTION_VALUE ACCOUNTED_AMOUNT
, NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE) ENTERED_AMOUNT
, WTA.ACCOUNTING_LINE_TYPE ACCOUNTING_LINE_TYPE_CODE
, WTA.REFERENCE_ACCOUNT CODE_COMBINATION_ID
, WTA.COST_ELEMENT_ID
, WTA.RATE_OR_AMOUNT
, XEG.EVENT_ID
, XEG.LEDGER_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER
, WTA.WIP_SUB_LEDGER_ID DISTRIBUTION_IDENTIFIER
, WTA.WIP_ENTITY_ID LINE_WIP_ENTITY_ID
FROM WIP_TRANSACTION_ACCOUNTS WTA
, XLA_EVENTS_GT XEG
WHERE WTA.TRANSACTION_ID = XEG.SOURCE_ID_INT_1
AND XEG.ENTITY_CODE = 'WIP_ACCOUNTING_EVENTS'
AND NVL(WTA.RESOURCE_ID
, -1) = NVL(XEG.SOURCE_ID_INT_2
, -1)
AND NVL(WTA.BASIS_TYPE
, -1) = NVL(XEG.SOURCE_ID_INT_3
, -1)