VIEW: APPS.CST_XLA_AWO_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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