VIEW: APPS.CST_XLA_RCV_LINES_V

Source

View Text - Preformatted

SELECT XEG.event_id, ROW_NUMBER() OVER(Partition by EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER, DECODE(RRS.accounted_dr, NULL, -1*RRS.accounted_cr, RRS.accounted_dr ) accounted_amount, DECODE(RRS.entered_dr, NULL, -1*RRS.entered_cr, RRS.entered_dr ) entered_amount, RRS.code_combination_id, RRS.accounting_line_type rcv_accounting_line_type, RRS.entered_nr_tax, RRS.entered_rec_tax, RRS.accounted_nr_tax, RRS.accounted_rec_tax, RRS.accrual_method_flag, XEG.ledger_id, RRS.rcv_sub_ledger_id distribution_identifier FROM rcv_receiving_sub_ledger RRS, xla_events_gt XEG WHERE XEG.source_id_int_1 = RRS.rcv_transaction_id AND XEG.source_id_int_2 = RRS.accounting_event_id AND XEG.entity_code = 'RCV_ACCOUNTING_EVENTS'

View Text - HTML Formatted

SELECT XEG.EVENT_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER
, DECODE(RRS.ACCOUNTED_DR
, NULL
, -1*RRS.ACCOUNTED_CR
, RRS.ACCOUNTED_DR ) ACCOUNTED_AMOUNT
, DECODE(RRS.ENTERED_DR
, NULL
, -1*RRS.ENTERED_CR
, RRS.ENTERED_DR ) ENTERED_AMOUNT
, RRS.CODE_COMBINATION_ID
, RRS.ACCOUNTING_LINE_TYPE RCV_ACCOUNTING_LINE_TYPE
, RRS.ENTERED_NR_TAX
, RRS.ENTERED_REC_TAX
, RRS.ACCOUNTED_NR_TAX
, RRS.ACCOUNTED_REC_TAX
, RRS.ACCRUAL_METHOD_FLAG
, XEG.LEDGER_ID
, RRS.RCV_SUB_LEDGER_ID DISTRIBUTION_IDENTIFIER
FROM RCV_RECEIVING_SUB_LEDGER RRS
, XLA_EVENTS_GT XEG
WHERE XEG.SOURCE_ID_INT_1 = RRS.RCV_TRANSACTION_ID
AND XEG.SOURCE_ID_INT_2 = RRS.ACCOUNTING_EVENT_ID
AND XEG.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'