35: PHA.blanket_total_amount
36: FROM PO_HEADERS_ALL PHA,
37: PO_VENDORS VO,
38: PO_VENDOR_CONTACTS VC,
39: HR_LOCATIONS_ALL_TL HRL_S,
40: HR_LOCATIONS_ALL_TL HRL_B
41: WHERE PHA.po_header_id = p_po_header_id
42: AND PHA.vendor_id = VO.vendor_id
43: AND VC.vendor_contact_id (+) = PHA.vendor_contact_id
36: FROM PO_HEADERS_ALL PHA,
37: PO_VENDORS VO,
38: PO_VENDOR_CONTACTS VC,
39: HR_LOCATIONS_ALL_TL HRL_S,
40: HR_LOCATIONS_ALL_TL HRL_B
41: WHERE PHA.po_header_id = p_po_header_id
42: AND PHA.vendor_id = VO.vendor_id
43: AND VC.vendor_contact_id (+) = PHA.vendor_contact_id
44: AND HRL_S.location_id (+) = PHA.ship_to_location_id