DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on HR_LOCATIONS_ALL_TL

Line 39: HR_LOCATIONS_ALL_TL HRL_S,

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

Line 40: HR_LOCATIONS_ALL_TL HRL_B

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