SELECT    poh.po_header_id,     poh.type_lookup_code PO_TYPE,    poh.authorization_status PO_STATUS,    poh.segment1 PO_NUMBER,    pov.vendor_name SUPPLIER_NAME,    povs.vendor_site_code Location,    hrls.location_code Ship_To,    hrlb.location_code Bill_to,    pol.line_num ,    msib.segment1 Item,    pol.unit_price,    pol.quantity,    pod.amount_billed Amount,    pod.destination_subinventory,    ppf.full_name Buyer_Name,    poh.closed_Code   FROM    PO_HEADERS_ALL poh,    PO_LINES_ALL pol,    mtl_system_items_b msib,    PO_LINE_LOCATIONS_ALL poll,    PO_DISTRIBUTIONS_ALL pod,    po_vendors pov,    po_vendor_sites_All povs,    hr_locations_all hrls,    hr_locations_all hrlb,    per_all_people_f ppf,    po_line_types polt  WHERE    1                         =1  AND polt.line...
 
 
Comments
Post a Comment