CML_SERVICE_PO_SCHEDULES_V

Details

• Schema: FUSION

• Object owner: CML

• Object type: VIEW

Columns

Name
PO_HEADER_ID PO_LINE_ID CMR_PO_LINE_LOCATION_ID SHIPMENT_NUMBER AMOUNT AMOUNT_IN_FUNC_CURRENCY NONRECOVERABLE_TAX NR_TAX_IN_FUNC_CURRENCY EVENT_DATE

Query

SQL_Statement

SELECT cpod.po_header_id, cpod.po_line_id, cpod.cmr_po_line_location_id, cpod.shipment_number, SUM(NVL(cpod.amount_ordered,0)*(1-nonrecoverable_inclusive_tax- recoverable_inclusive_tax)) amount, SUM(NVL(cpod.amount_ordered,0)*(1-nonrecoverable_inclusive_tax- recoverable_inclusive_tax))* NVL(cpod.currency_conversion_rate,1) amount_in_func_currency, SUM(cpod.nonrecoverable_tax + cpod.nonrecoverable_inclusive_tax) * (NVL(cpod.tax_exclusive_price,0)) nonrecoverable_tax, SUM(cpod.nonrecoverable_tax + cpod.nonrecoverable_inclusive_tax)* NVL(cpod.currency_conversion_rate,1)*(NVL(cpod.tax_exclusive_price,0)) nr_tax_in_func_currency, (select max(event_date) from cmr_purchase_order_dtls cpod1 where cpod1.po_header_id = cpod.po_header_id and cpod1.po_line_id=cpod.po_line_id and cpod1.cmr_po_line_location_id = cpod.cmr_po_line_location_id) event_date FROM cmr_purchase_order_dtls cpod WHERE cpod.purchase_basis = 'SERVICES' AND cpod.active_flag = 'Y' GROUP BY cpod.po_header_id, cpod.po_line_id, cpod.cmr_po_line_location_id, cpod.shipment_number, cpod.tax_exclusive_price, cpod.currency_conversion_rate