DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on PO_LOCATION_ASSOCIATIONS

Line 5689: ,PO_LOCATION_ASSOCIATIONS b

5685: CURSOR dest_org_locn_cur (p_cust_id in number) is
5686: SELECT b.location_id,
5687: b.organization_id
5688: FROM hz_party_sites_V a
5689: ,PO_LOCATION_ASSOCIATIONS b
5690: WHERE a.party_site_use_id = b.SITE_USE_ID
5691: and b.customer_id = p_cust_id
5692: and primary_per_type = 'Y'
5693: and site_use_type = 'SHIP_TO';