APPS.FV_GTAS_TRX_REGISTER dependencies on RA_CUSTOMER_TRX_ALL

Line 2714: ra_customer_trx_all rcth

2710: to_char(rcth.bill_to_customer_id)
2711: INTO l_reference_4,
2712: l_reference_7
2713: FROM ar_transaction_history_all ara,
2714: ra_customer_trx_all rcth
2715: WHERE ara.transaction_history_id = l_ar_source_id
2716: AND ara.customer_trx_id = rcth.customer_trx_id;
2717:
2718: l_reference_5 := l_reference_4;

Line 2751: ra_customer_trx_all rcth

2747: l_reference_7,
2748: l_reference_2
2749: FROM ra_cust_trx_line_gl_dist_all rctgl,
2750: ra_customer_trx_lines_all rctl,
2751: ra_customer_trx_all rcth
2752: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2753: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id
2754: AND rcth.customer_trx_id = rctl.customer_trx_id;
2755: ELSE

Line 2763: ra_customer_trx_all rcth

2759: INTO l_reference_4,
2760: l_reference_7,
2761: l_reference_2
2762: FROM ra_cust_trx_line_gl_dist_all rctgl,
2763: ra_customer_trx_all rcth
2764: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2765: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2766: END IF;
2767:

Line 3494: FROM ra_customer_trx_all

3490: FROM ar_receivable_applications_all
3491: WHERE receivable_application_id = l_refer2;
3492: CURSOR Receivables_Memos_Inv IS
3493: SELECT trx_date, creation_date, created_by
3494: FROM ra_customer_trx_all
3495: WHERE customer_trx_id = l_refer2;
3496: BEGIN
3497:
3498: log(l_module,'BEGIN GET_DOC_INFO');

Line 5113: FROM ra_customer_trx_all rct,

5109: log(l_module,'p_reimb_agree_seg_val:'||p_reimb_agree_seg_val);
5110:
5111: SELECT hzca.customer_class_code
5112: INTO l_cust_class_code
5113: FROM ra_customer_trx_all rct,
5114: hz_cust_accounts_all hzca
5115: WHERE rct.trx_number = p_reimb_agree_seg_val
5116: AND rct.set_of_books_id = g_set_of_books_id
5117: AND hzca.cust_account_id = rct.bill_to_customer_id;

Line 5155: FROM ra_customer_trx_all rct,

5151: 'p_reimb_agree_seg_val:'||p_reimb_agree_seg_val);
5152:
5153: SELECT hzca.customer_class_code
5154: INTO l_cust_class_code
5155: FROM ra_customer_trx_all rct,
5156: hz_cust_accounts_all hzca
5157: WHERE rct.trx_number = p_reimb_agree_seg_val
5158: AND rct.set_of_books_id = g_set_of_books_id
5159: AND hzca.cust_account_id = rct.bill_to_customer_id;