DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on PO_LOCATION_ASSOCIATIONS

Line 6046: ,PO_LOCATION_ASSOCIATIONS b

6042: CURSOR dest_org_locn_cur (p_cust_id in number) is
6043: SELECT b.location_id,
6044: b.organization_id
6045: FROM hz_party_sites_V a
6046: ,PO_LOCATION_ASSOCIATIONS b
6047: WHERE a.party_site_use_id = b.SITE_USE_ID
6048: and b.customer_id = p_cust_id
6049: and primary_per_type = 'Y'
6050: and site_use_type = 'SHIP_TO';