APPS.AR_GTA_REPORTS_PKG dependencies on RA_BATCHES_ALL

Line 277: -- , ra_batches_all bat

273: L_Ret_Xmlelement
274: FROM
275: Ra_Customer_Trx_all ract
276: --yao zhang modified for bug8766075
277: -- , ra_batches_all bat
278: ,RA_BATCH_SOURCES_ALL bas
279: , Ra_Cust_Trx_Types_all ctt
280: , Hz_Cust_Accounts RAC_BILL
281: , Hz_Parties RAC_BILL_PARTY

Line 332: -- , ra_batches_all bat

328: L_Ret_Xmlelement
329: FROM
330: Ra_Customer_Trx_all ract
331: --yao zhang modified for bug8766075
332: -- , ra_batches_all bat
333: ,RA_BATCH_SOURCES_ALL bas
334: , Ra_Cust_Trx_Types_all ctt
335: , Hz_Cust_Accounts RAC_BILL
336: , Hz_Parties RAC_BILL_PARTY

Line 3850: l_ar_trx_batch_from ra_batches_all.name%TYPE

3846: l_cust_num_to hz_cust_accounts.account_number%TYPE
3847: :=p_cust_num_to;
3848: l_gl_period gl_periods.period_name%TYPE
3849: :=p_gl_period;
3850: l_ar_trx_batch_from ra_batches_all.name%TYPE
3851: :=p_ar_trx_batch_from;
3852: l_ar_trx_batch_to ra_batches_all.name%TYPE
3853: :=p_ar_trx_batch_to;
3854: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE

Line 3852: l_ar_trx_batch_to ra_batches_all.name%TYPE

3848: l_gl_period gl_periods.period_name%TYPE
3849: :=p_gl_period;
3850: l_ar_trx_batch_from ra_batches_all.name%TYPE
3851: :=p_ar_trx_batch_from;
3852: l_ar_trx_batch_to ra_batches_all.name%TYPE
3853: :=p_ar_trx_batch_to;
3854: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE
3855: :=p_ar_trx_num_from;
3856: l_ar_trx_num_to ra_customer_trx_all.trx_number%TYPE

Line 4723: ,ra_batches_all rb

4719: ,ra_customer_trx_all ct
4720: ,hz_cust_accounts rac_bill
4721: ,hz_parties rac_bill_party
4722: ,ra_cust_trx_line_gl_dist_all gd
4723: ,ra_batches_all rb
4724: WHERE gta.ra_trx_id=ct.customer_trx_id(+)
4725: AND rb.batch_id(+)=ct.batch_id
4726: AND gta.source='AR'
4727: AND(gta.status='COMPLETED' OR gta.status='CONSOLIDATED')--Yao Zhang Modified for bug#8765631