eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_REPORTS_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 275: Ra_Customer_Trx_all ract

271: )
272: INTO
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

Line 330: Ra_Customer_Trx_all ract

326: )
327: INTO
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

Line 584: ,Ra_Customer_Trx_All Ar

580: SELECT
581: DISTINCT Gt.Ra_Trx_Id
582: FROM
583: AR_Gta_Trx_Headers_All Gt
584: ,Ra_Customer_Trx_All Ar
585: WHERE Gt.Ra_Trx_Id=Ar.Customer_Trx_Id
586: AND Gt.Org_Id=P_Org_Id
587: AND Gt.Fp_Tax_Registration_Number=NVL(p_fp_tax_reg_num
588: ,Gt.Fp_Tax_Registration_Number

Line 859: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

855: l_ar_amount NUMBER;
856: l_ar_amount_disp VARCHAR2(50);
857: l_ar_taxamount NUMBER;
858: l_ar_taxamount_disp VARCHAR2(50);
859: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
860: l_ar_customer_name hz_parties.party_name%TYPE;
861: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
862: l_ar_customer_bank_account VARCHAR2(360);
863: l_ar_customer_address VARCHAR2(4000);

Line 968: ra_customer_trx_all rct

964: RAA_BILL_LOC.POSTAL_CODE,
965: FT_BILL.TERRITORY_SHORT_NAME),
966: RAA_BILL_LOC.Address_Lines_Phonetic)) customer_address
967: FROM
968: ra_customer_trx_all rct
969: ,hz_parties rac_bill_party
970: ,hz_cust_accounts rac_bill
971: --,ap_bank_accounts apba
972: --,ap_bank_branches apb

Line 2116: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE

2112: )
2113: IS
2114: l_org_id hr_all_organization_units.organization_id%TYPE
2115: :=p_org_id;
2116: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2117: :=p_ar_header_id;
2118: l_has_difference BOOLEAN;
2119: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2120: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;

Line 2346: l_conversion_rate ra_customer_trx_all.exchange_rate%type;--Yao Zhang add for bug#5604079

2342: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2343: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2344: l_ar_loop_count NUMBER;
2345: l_gta_loop_count NUMBER;
2346: l_conversion_rate ra_customer_trx_all.exchange_rate%type;--Yao Zhang add for bug#5604079
2347:
2348:
2349: BEGIN
2350:

Line 2377: from ra_customer_trx_all

2373:
2374: --uncomment for bug#8289585
2375: --Yao Zhang add for bug#5604079
2376: select exchange_rate into l_conversion_rate
2377: from ra_customer_trx_all
2378: where customer_trx_id=l_ar_header_id;
2379: --Yao Zhang add end
2380: -- To get meaning of line level attribute lookup code
2381: SELECT

Line 3538: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE

3534: IS
3535:
3536: l_org_id hr_all_organization_units.organization_id%TYPE
3537: :=p_org_id;
3538: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
3539: :=p_ar_header_id;
3540: l_has_difference BOOLEAN;
3541: l_api_name VARCHAR2(50)
3542: :='Get_Unmatched_Lines';

Line 3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;

3834: l_customer_name hz_parties.party_name%TYPE;
3835: l_primary_sales_name ra_salesreps_all.name%TYPE;
3836: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3837: :=p_cust_name_id;
3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE
3840: :=p_gta_batch_num_from;
3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE
3842: :=p_gta_batch_num_to;

Line 3854: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE

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
3857: :=p_ar_trx_num_to;
3858: l_ar_doc_num_from VARCHAR2(15)

Line 3856: l_ar_trx_num_to ra_customer_trx_all.trx_number%TYPE

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
3857: :=p_ar_trx_num_to;
3858: l_ar_doc_num_from VARCHAR2(15)
3859: :=p_ar_doc_num_from;
3860: l_ar_doc_num_to VARCHAR2(15)

Line 3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;

3880: l_ar_missingtrx_total NUMBER;
3881: l_parameter_xml XMLTYPE;
3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;

Line 4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;

4680: l_header_difference BOOLEAN;
4681: l_line_difference BOOLEAN;
4682: l_has_unmatched BOOLEAN;
4683: l_xml_output XMLTYPE;
4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4686: l_ar_customer_name hz_parties.party_name%TYPE;
4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4688: l_missing_artrx_seq NUMBER;

Line 4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;

4681: l_line_difference BOOLEAN;
4682: l_has_unmatched BOOLEAN;
4683: l_xml_output XMLTYPE;
4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4686: l_ar_customer_name hz_parties.party_name%TYPE;
4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4688: l_missing_artrx_seq NUMBER;
4689: l_gta_trx_number_missing VARCHAR2(2000);

Line 4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

4683: l_xml_output XMLTYPE;
4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4686: l_ar_customer_name hz_parties.party_name%TYPE;
4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4688: l_missing_artrx_seq NUMBER;
4689: l_gta_trx_number_missing VARCHAR2(2000);
4690: l_gt_invoice_number_missing VARCHAR2(2000);
4691: l_gt_invoice_amount_missing NUMBER;

Line 4692: l_ar_trx_number_missing ra_customer_trx_all.trx_number%TYPE;

4688: l_missing_artrx_seq NUMBER;
4689: l_gta_trx_number_missing VARCHAR2(2000);
4690: l_gt_invoice_number_missing VARCHAR2(2000);
4691: l_gt_invoice_amount_missing NUMBER;
4692: l_ar_trx_number_missing ra_customer_trx_all.trx_number%TYPE;
4693:
4694: l_delimiter VARCHAR2(1)
4695: :=',';
4696: l_validated_lines NUMBER;

Line 4719: ,ra_customer_trx_all ct

4715: ,rac_bill_party.party_name customer_name
4716: ,ct.invoice_currency_code
4717: FROM
4718: ar_gta_trx_headers gta
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

Line 5676: , ra_customer_trx_all rcta

5672: INTO
5673: l_ret_xmlelement
5674: FROM
5675: AR_Gta_Trx_Headers_all jgtha
5676: , ra_customer_trx_all rcta
5677: , ra_cust_trx_types rctt
5678: WHERE jgtha.CONSOLIDATION_FLAG = '1'
5679: AND jgtha.SOURCE = 'AR'
5680: AND jgtha.Status='CONSOLIDATED'