View: CST_XLA_AWO_HEADERS_V

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

View Text

SELECT XEG.EVENT_ID
, CWO.WRITE_OFF_ID
, CWO.TRANSACTION_DATE
, CWO.TRANSACTION_TYPE_CODE WO_TRANSACTION_TYPE_CODE
, CWO.PO_DISTRIBUTION_ID
, CWO.OFFSET_ACCOUNT_ID WO_OFFSET_ACCOUNT_ID
, CWO.ACCRUAL_ACCOUNT_ID WO_ACCRUAL_ACCOUNT_ID
, CWO.ERV_ACCOUNT_ID WO_ERV_ACCOUNT_ID
, CWO.COMMENTS WO_COMMENTS
, CWO.INVENTORY_ITEM_ID
, CWO.VENDOR_ID
, CWO.DESTINATION_TYPE_CODE
, CWO.OPERATING_UNIT_ID
, 'CST_WRITE_OFFS' DISTRIBUTION_TYPE
, CWO.CURRENCY_CODE H_CURRENCY_CODE
, CWO.CURRENCY_CONVERSION_DATE H_CURRENCY_CONVERSION_DATE
, CWO.CURRENCY_CONVERSION_RATE H_CURRENCY_CONVERSION_RATE
, CWO.CURRENCY_CONVERSION_TYPE H_CURRENCY_CONVERSION_TYPE
, 'Y' TRANSFER_TO_GL_INDICATOR
, CWO.WRITE_OFF_AMOUNT H_ACCOUNTED_AMOUNT
, CWO.ENTERED_AMOUNT H_ENTERED_AMOUNT
, DECODE(CWO.ENTERED_AMOUNT
, NULL
, 0
, ((ROUND ( (CWO.ENTERED_AMOUNT * NVL(CWO.CURRENCY_CONVERSION_RATE
, 1))/NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, NVL(-FC.PRECISION
, 0))) ) * NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, NVL(-FC.PRECISION
, 0))) ) - CWO.WRITE_OFF_AMOUNT ) ) WO_ERV_AMOUNT
, DECODE(CWO.ENTERED_AMOUNT
, NULL
, 0
, ( (ROUND ( (CWO.ENTERED_AMOUNT * NVL(CWO.CURRENCY_CONVERSION_RATE
, 1))/NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, NVL(-FC.PRECISION
, 0))) ) * NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, NVL(-FC.PRECISION
, 0))) ) - CWO.WRITE_OFF_AMOUNT) ) + CWO.WRITE_OFF_AMOUNT TOTAL_ACCRUAL_AMOUNT
, GL.CURRENCY_CODE FUNC_CURRENCY_CODE
, TO_NUMBER(NULL) FUNC_CURRENCY_CONVERSION_RATE
, NULL FUNC_CURRENCY_CONVERSION_TYPE
, SYSDATE FUNC_CURRENCY_CONVERSION_DATE
, XEG.LEDGER_ID H_LEDGER_ID
, CWO.INVOICE_DISTRIBUTION_ID
, CWO.INVENTORY_TRANSACTION_ID
FROM CST_WRITE_OFFS CWO
, XLA_EVENTS_GT XEG
, GL_LEDGERS GL
, FND_CURRENCIES FC
WHERE CWO.WRITE_OFF_ID = XEG.SOURCE_ID_INT_1
AND XEG.ENTITY_CODE = 'WO_ACCOUNTING_EVENTS'
AND GL.LEDGER_ID = XEG.LEDGER_ID
AND FC.CURRENCY_CODE = GL.CURRENCY_CODE

Columns