VIEW: APPS.CST_XLA_RCV_HEADERS_V

Source

View Text - Preformatted

SELECT /*+ cardinality(xeg,1) */ XEG.EVENT_ID, 'RCV_RECEIVING_SUB_LEDGER' DISTRIBUTION_TYPE, RAE.ACCOUNTING_EVENT_ID RCV_ACCOUNTING_EVENT_ID, NVL(RAE.CURRENCY_CODE, GL.CURRENCY_CODE) CURRENCY_CODE, RAE.CURRENCY_CONVERSION_DATE, DECODE(RAE.CURRENCY_CODE, NULL, to_number(NULL), GL.CURRENCY_CODE, to_number(NULL), RAE.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE, DECODE(RAE.CURRENCY_CODE, NULL, NULL, GL.CURRENCY_CODE, NULL, RAE.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE, DECODE(MP.GENERAL_LEDGER_UPDATE_CODE, 3, 'N', 'Y' ) TRANSFER_TO_GL_INDICATOR FROM RCV_ACCOUNTING_EVENTS RAE, XLA_EVENTS_GT XEG, MTL_PARAMETERS MP, GL_LEDGERS GL WHERE XEG.SOURCE_ID_INT_2 = RAE.ACCOUNTING_EVENT_ID AND XEG.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS' AND RAE.RCV_TRANSACTION_ID = XEG.SOURCE_ID_INT_1 AND MP.ORGANIZATION_ID = RAE.ORGANIZATION_ID AND GL.LEDGER_ID = XEG.LEDGER_ID

View Text - HTML Formatted

SELECT /*+ CARDINALITY(XEG
, 1) */ XEG.EVENT_ID
, 'RCV_RECEIVING_SUB_LEDGER' DISTRIBUTION_TYPE
, RAE.ACCOUNTING_EVENT_ID RCV_ACCOUNTING_EVENT_ID
, NVL(RAE.CURRENCY_CODE
, GL.CURRENCY_CODE) CURRENCY_CODE
, RAE.CURRENCY_CONVERSION_DATE
, DECODE(RAE.CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, GL.CURRENCY_CODE
, TO_NUMBER(NULL)
, RAE.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE
, DECODE(RAE.CURRENCY_CODE
, NULL
, NULL
, GL.CURRENCY_CODE
, NULL
, RAE.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE
, DECODE(MP.GENERAL_LEDGER_UPDATE_CODE
, 3
, 'N'
, 'Y' ) TRANSFER_TO_GL_INDICATOR
FROM RCV_ACCOUNTING_EVENTS RAE
, XLA_EVENTS_GT XEG
, MTL_PARAMETERS MP
, GL_LEDGERS GL
WHERE XEG.SOURCE_ID_INT_2 = RAE.ACCOUNTING_EVENT_ID
AND XEG.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'
AND RAE.RCV_TRANSACTION_ID = XEG.SOURCE_ID_INT_1
AND MP.ORGANIZATION_ID = RAE.ORGANIZATION_ID
AND GL.LEDGER_ID = XEG.LEDGER_ID