DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1594: from hz_cust_site_uses_all where site_use_id=

1590: AND Address_Id = AddressId;
1591:
1592: CURSOR Fetch_OE_Address_Cur IS
1593: SELECT cust_acct_site_id address_id
1594: from hz_cust_site_uses_all where site_use_id=
1595: (select SHIP_TO_LOCATION_ID
1596: FROM wsh_delivery_details
1597: WHERE delivery_detail_id = p_ref_line_id);
1598:

Line 1601: FROM hz_cust_site_uses_all where site_use_id in

1597: WHERE delivery_detail_id = p_ref_line_id);
1598:
1599: CURSOR Fetch_AR_Address_Cur IS
1600: SELECT cust_acct_site_id address_id
1601: FROM hz_cust_site_uses_all where site_use_id in
1602: (select ship_to_site_use_id from RA_Customer_Trx_All
1603: WHERE Customer_trx_Id in (select customer_trx_id from
1604: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));
1605: