VIEW: APPS.CST_XLA_AWO_HEADERS_V

Source

View Text - Preformatted

SELECT /*+ cardinality(xeg,1) */ 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

View Text - HTML Formatted

SELECT /*+ CARDINALITY(XEG
, 1) */ 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