http://www.javadecompilers.com
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