[Home] [Help]
View: CST_XLA_RCV_HEADERS_V
View Text
SELECT 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
Columns
Name |
EVENT_ID |
DISTRIBUTION_TYPE |
RCV_ACCOUNTING_EVENT_ID |
CURRENCY_CODE |
CURRENCY_CONVERSION_DATE |
CURRENCY_CONVERSION_RATE |
CURRENCY_CONVERSION_TYPE |
TRANSFER_TO_GL_INDICATOR |