VIEW: APPS.CST_XLA_RCV_LINES_V

Source

View Text - Preformatted

SELECT /*+ cardinality(xeg,1) */ event_id, ROW_NUMBER() OVER(Partition by EVENT_ID ORDER BY rcv_sub_ledger_id) AS LINE_NUMBER, accounted_amount, entered_amount, code_combination_id, rcv_accounting_line_type, entered_nr_tax, entered_rec_tax, accounted_nr_tax, accounted_rec_tax, accrual_method_flag, ledger_id, distribution_identifier from ( select /*+ cardinality(xeg,1) */ XEG.event_id, ABS(RRS.rcv_sub_ledger_id) rcv_sub_ledger_id, 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.entity_code = 'RCV_ACCOUNTING_EVENTS' AND xeg.source_id_int_1 = rrs.rcv_transaction_id AND xeg.source_id_int_2 = rrs.accounting_event_id AND rrs.accounting_line_type <> 'Encumbrance Reversal' UNION ALL SELECT /*+ cardinality(xeg,1) */ XEG.event_id, ABS(RRS.rcv_sub_ledger_id) rcv_sub_ledger_id, 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.entity_code = 'RCV_ACCOUNTING_EVENTS' AND xeg.source_id_int_1 = rrs.rcv_transaction_id AND rrs.rcv_transaction_id = 0 AND rrs.accounting_line_type = 'Encumbrance Reversal' AND rrs.reference9 = TO_CHAR(xeg.source_id_int_2) UNION ALL SELECT /*+ cardinality(xeg,1) */ XEG.event_id, ABS(RRS.rcv_sub_ledger_id) rcv_sub_ledger_id, 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.entity_code = 'RCV_ACCOUNTING_EVENTS' AND xeg.source_id_int_1 = rrs.rcv_transaction_id AND rrs.accounting_line_type = 'Encumbrance Reversal' AND rrs.reference9 IS NULL )

View Text - HTML Formatted

SELECT /*+ CARDINALITY(XEG
, 1) */ EVENT_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY RCV_SUB_LEDGER_ID) AS LINE_NUMBER
, ACCOUNTED_AMOUNT
, ENTERED_AMOUNT
, CODE_COMBINATION_ID
, RCV_ACCOUNTING_LINE_TYPE
, ENTERED_NR_TAX
, ENTERED_REC_TAX
, ACCOUNTED_NR_TAX
, ACCOUNTED_REC_TAX
, ACCRUAL_METHOD_FLAG
, LEDGER_ID
, DISTRIBUTION_IDENTIFIER
FROM ( SELECT /*+ CARDINALITY(XEG
, 1) */ XEG.EVENT_ID
, ABS(RRS.RCV_SUB_LEDGER_ID) RCV_SUB_LEDGER_ID
, 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.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'
AND XEG.SOURCE_ID_INT_1 = RRS.RCV_TRANSACTION_ID
AND XEG.SOURCE_ID_INT_2 = RRS.ACCOUNTING_EVENT_ID
AND RRS.ACCOUNTING_LINE_TYPE <> 'ENCUMBRANCE REVERSAL' UNION ALL SELECT /*+ CARDINALITY(XEG
, 1) */ XEG.EVENT_ID
, ABS(RRS.RCV_SUB_LEDGER_ID) RCV_SUB_LEDGER_ID
, 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.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'
AND XEG.SOURCE_ID_INT_1 = RRS.RCV_TRANSACTION_ID
AND RRS.RCV_TRANSACTION_ID = 0
AND RRS.ACCOUNTING_LINE_TYPE = 'ENCUMBRANCE REVERSAL'
AND RRS.REFERENCE9 = TO_CHAR(XEG.SOURCE_ID_INT_2) UNION ALL SELECT /*+ CARDINALITY(XEG
, 1) */ XEG.EVENT_ID
, ABS(RRS.RCV_SUB_LEDGER_ID) RCV_SUB_LEDGER_ID
, 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.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'
AND XEG.SOURCE_ID_INT_1 = RRS.RCV_TRANSACTION_ID
AND RRS.ACCOUNTING_LINE_TYPE = 'ENCUMBRANCE REVERSAL'
AND RRS.REFERENCE9 IS NULL )