View: CST_XLA_WIP_LINES_V

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

View Text

SELECT WTA.BASE_TRANSACTION_VALUE ACCOUNTED_AMOUNT
, NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE) ENTERED_AMOUNT
, WTA.ACCOUNTING_LINE_TYPE ACCOUNTING_LINE_TYPE_CODE
, WTA.REFERENCE_ACCOUNT CODE_COMBINATION_ID
, WTA.COST_ELEMENT_ID
, WTA.RATE_OR_AMOUNT
, XEG.EVENT_ID
, XEG.LEDGER_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER
, WTA.WIP_SUB_LEDGER_ID DISTRIBUTION_IDENTIFIER
, WTA.WIP_ENTITY_ID LINE_WIP_ENTITY_ID
FROM WIP_TRANSACTION_ACCOUNTS WTA
, XLA_EVENTS_GT XEG
WHERE WTA.TRANSACTION_ID = XEG.SOURCE_ID_INT_1
AND XEG.ENTITY_CODE = 'WIP_ACCOUNTING_EVENTS'
AND NVL(WTA.RESOURCE_ID
, -1) = NVL(XEG.SOURCE_ID_INT_2
, -1)
AND NVL(WTA.BASIS_TYPE
, -1) = NVL(XEG.SOURCE_ID_INT_3
, -1)

Columns