View: CST_XLA_AWO_LINES_V

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

View Text

SELECT CXAHV.EVENT_ID
, 1 LINE_NUMBER
, CXAHV.H_ENTERED_AMOUNT ENTERED_AMOUNT
, DECODE(CXAHV.PO_DISTRIBUTION_ID
, NULL
, CXAHV.H_ACCOUNTED_AMOUNT
, DECODE(CXAHV.INVENTORY_TRANSACTION_ID
, NULL
, DECODE(CXAHV.INVOICE_DISTRIBUTION_ID
, NULL
, CXAHV.TOTAL_ACCRUAL_AMOUNT
, CXAHV.H_ACCOUNTED_AMOUNT)
, CXAHV.H_ACCOUNTED_AMOUNT ) ) ACCOUNTED_AMOUNT
, CXAHV.H_CURRENCY_CODE CURRENCY_CODE
, CXAHV.H_CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, DECODE(CXAHV.H_CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, CXAHV.FUNC_CURRENCY_CODE
, TO_NUMBER(NULL)
, CXAHV.H_CURRENCY_CONVERSION_RATE) CURRENCY_CONVERSION_RATE
, DECODE(CXAHV.H_CURRENCY_CODE
, NULL
, NULL
, CXAHV.FUNC_CURRENCY_CODE
, NULL
, CXAHV.H_CURRENCY_CONVERSION_TYPE) CURRENCY_CONVERSION_TYPE
, CXAHV.H_LEDGER_ID LEDGER_ID
FROM CST_XLA_AWO_HEADERS_V CXAHV UNION ALL SELECT CXAHV.EVENT_ID
, 2 LINE_NUMBER
, 0 ENTERED_AMOUNT
, CXAHV.WO_ERV_AMOUNT ACCOUNTED_AMOUNT
, CXAHV.H_CURRENCY_CODE CURRENCY_CODE
, CXAHV.H_CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, DECODE(CXAHV.H_CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, CXAHV.FUNC_CURRENCY_CODE
, TO_NUMBER(NULL)
, CXAHV.H_CURRENCY_CONVERSION_RATE) CURRENCY_CONVERSION_RATE
, DECODE(CXAHV.H_CURRENCY_CODE
, NULL
, NULL
, CXAHV.FUNC_CURRENCY_CODE
, NULL
, CXAHV.H_CURRENCY_CONVERSION_TYPE) CURRENCY_CONVERSION_TYPE
, CXAHV.H_LEDGER_ID LEDGER_ID
FROM CST_XLA_AWO_HEADERS_V CXAHV
WHERE WO_ERV_AMOUNT <> 0
AND INVOICE_DISTRIBUTION_ID IS NULL
AND PO_DISTRIBUTION_ID IS NOT NULL
AND INVENTORY_TRANSACTION_ID IS NULL

Columns