APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 483: (select ship_to_site_use_id from RA_Customer_Trx_All

479:
480: CURSOR Fetch_AR_Address_Cur IS
481: SELECT Address_id
482: FROM Ra_site_uses_all where site_use_id in
483: (select ship_to_site_use_id from RA_Customer_Trx_All
484: WHERE Customer_trx_Id in (select customer_trx_id from
485: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));
486:
487:

Line 1602: (select ship_to_site_use_id from RA_Customer_Trx_All

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:
1606: