View: CST_XLA_RCV_HEADERS_V

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

View Text

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

Columns