DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 542: (select ship_to_site_use_id from RA_Customer_Trx_All

538:
539: CURSOR Fetch_AR_Address_Cur IS
540: SELECT Address_id
541: FROM Ra_site_uses_all where site_use_id in
542: (select ship_to_site_use_id from RA_Customer_Trx_All
543: WHERE Customer_trx_Id in (select customer_trx_id from
544: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));
545:
546:

Line 1693: (select ship_to_site_use_id from RA_Customer_Trx_All

1689:
1690: CURSOR Fetch_AR_Address_Cur IS
1691: SELECT cust_acct_site_id address_id
1692: FROM hz_cust_site_uses_all where site_use_id in
1693: (select ship_to_site_use_id from RA_Customer_Trx_All
1694: WHERE Customer_trx_Id in (select customer_trx_id from
1695: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));
1696:
1697: