APPS.JMF_GTA_REPORTS_PKG dependencies on RA_BATCHES_ALL

Line 248: , ra_batches_all bat

244: INTO
245: L_Ret_Xmlelement
246: FROM
247: Ra_Customer_Trx_all ract
248: , ra_batches_all bat
249: , Ra_Cust_Trx_Types_all ctt
250: , Hz_Cust_Accounts RAC_BILL
251: , Hz_Parties RAC_BILL_PARTY
252:

Line 282: , ra_batches_all bat

278: INTO
279: L_Ret_Xmlelement
280: FROM
281: Ra_Customer_Trx_all ract
282: , ra_batches_all bat
283: , Ra_Cust_Trx_Types_all ctt
284: , Hz_Cust_Accounts RAC_BILL
285: , Hz_Parties RAC_BILL_PARTY
286:

Line 3671: l_ar_trx_batch_from ra_batches_all.name%TYPE

3667: l_cust_num_to hz_cust_accounts.account_number%TYPE
3668: :=p_cust_num_to;
3669: l_gl_period gl_periods.period_name%TYPE
3670: :=p_gl_period;
3671: l_ar_trx_batch_from ra_batches_all.name%TYPE
3672: :=p_ar_trx_batch_from;
3673: l_ar_trx_batch_to ra_batches_all.name%TYPE
3674: :=p_ar_trx_batch_to;
3675: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE

Line 3673: l_ar_trx_batch_to ra_batches_all.name%TYPE

3669: l_gl_period gl_periods.period_name%TYPE
3670: :=p_gl_period;
3671: l_ar_trx_batch_from ra_batches_all.name%TYPE
3672: :=p_ar_trx_batch_from;
3673: l_ar_trx_batch_to ra_batches_all.name%TYPE
3674: :=p_ar_trx_batch_to;
3675: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE
3676: :=p_ar_trx_num_from;
3677: l_ar_trx_num_to ra_customer_trx_all.trx_number%TYPE

Line 4518: ,ra_batches_all rb

4514: ,ra_customer_trx_all ct
4515: ,hz_cust_accounts rac_bill
4516: ,hz_parties rac_bill_party
4517: ,ra_cust_trx_line_gl_dist_all gd
4518: ,ra_batches_all rb
4519: WHERE gta.ra_trx_id=ct.customer_trx_id(+)
4520: AND rb.batch_id(+)=ct.batch_id
4521: AND gta.source='AR'
4522: AND gta.status='COMPLETED'