View: CST_XLA_RCV_LINES_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_RCV_LINES_V

View Text

SELECT /*+ CARDINALITY(XEG
, 1) */ XEG.EVENT_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY ABS(RRS.RCV_SUB_LEDGER_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.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
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY ABS(RRS.RCV_SUB_LEDGER_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.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
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY ABS(RRS.RCV_SUB_LEDGER_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.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

Columns