APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 485: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));

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:
488: CURSOR Chk_Rcd_Cur IS
489: SELECT NVL( COUNT( * ), 0 )

Line 1604: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));

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:
1607: CURSOR Chk_Rcd_Cur IS
1608: SELECT NVL( COUNT( * ), 0 )