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_type_id = pol.line_type_id AND povs.vendor_site_id = poh.vendor_site_id AND pov.vendor_id = poh.vendor_id AND pol.item_id = msib.inventory_item_id AND msib.organization_id
Comments
Post a Comment