Service contract reconciliation Report
SELECT okha.sts_code,okha.scs_code,okha.date_approved,okha.estimated_amount, xscb.price_list_id, xscb.customer_bill_to_number, xscb.customer_ship_to_number, xscb.contract_number, xscb.contract_type, xscb.cognomen, xscb.start_date, xscb.end_date, qslh.NAME AS price_list_name, ood.organization_code AS inventory_org_code, hou.NAME AS operating_unit_name, customer, xscb.payment_term, NULL price_list, line_item, DECODE (TRIM (xscb.err_msg), ‘/’, ‘SUCCESS’, xscb.err_msg)…
Read More