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.JMF_GTA_REPORTS_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 247: Ra_Customer_Trx_all ract

243: )
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

Line 281: Ra_Customer_Trx_all ract

277: )
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

Line 520: ,Ra_Customer_Trx_All Ar

516: SELECT
517: DISTINCT Gt.Ra_Trx_Id
518: FROM
519: Jmf_Gta_Trx_Headers_All Gt
520: ,Ra_Customer_Trx_All Ar
521: WHERE Gt.Ra_Trx_Id=Ar.Customer_Trx_Id
522: AND Gt.Org_Id=P_Org_Id
523: AND Gt.Fp_Tax_Registration_Number=NVL(p_fp_tax_reg_num
524: ,Gt.Fp_Tax_Registration_Number

Line 793: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

789: l_ar_amount NUMBER;
790: l_ar_amount_disp VARCHAR2(50);
791: l_ar_taxamount NUMBER;
792: l_ar_taxamount_disp VARCHAR2(50);
793: l_ar_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
794: l_ar_customer_name hz_parties.party_name%TYPE;
795: l_ar_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
796: l_ar_customer_bank_account VARCHAR2(360);
797: l_ar_customer_address VARCHAR2(4000);

Line 896: ra_customer_trx_all rct

892: ,ft_bill.territory_short_name
893: )
894: ) customer_address
895: FROM
896: ra_customer_trx_all rct
897: ,hz_parties rac_bill_party
898: ,hz_cust_accounts rac_bill
899: --,ap_bank_accounts apba
900: --,ap_bank_branches apb

Line 2013: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE

2009: )
2010: IS
2011: l_org_id hr_all_organization_units.organization_id%TYPE
2012: :=p_org_id;
2013: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2014: :=p_ar_header_id;
2015: l_has_difference BOOLEAN;
2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;

Line 3362: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE

3358: IS
3359:
3360: l_org_id hr_all_organization_units.organization_id%TYPE
3361: :=p_org_id;
3362: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
3363: :=p_ar_header_id;
3364: l_has_difference BOOLEAN;
3365: l_api_name VARCHAR2(50)
3366: :='Get_Unmatched_Lines';

Line 3659: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;

3655: l_customer_name hz_parties.party_name%TYPE;
3656: l_primary_sales_name ra_salesreps_all.name%TYPE;
3657: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3658: :=p_cust_name_id;
3659: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3660: l_gta_batch_num_from jmf_gta_trx_headers_all.gta_batch_number%TYPE
3661: :=p_gta_batch_num_from;
3662: l_gta_batch_num_to jmf_gta_trx_headers_all.gta_batch_number%TYPE
3663: :=p_gta_batch_num_to;

Line 3675: l_ar_trx_num_from ra_customer_trx_all.trx_number%TYPE

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

Line 3677: l_ar_trx_num_to ra_customer_trx_all.trx_number%TYPE

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
3678: :=p_ar_trx_num_to;
3679: l_ar_doc_num_from VARCHAR2(15)
3680: :=p_ar_doc_num_from;
3681: l_ar_doc_num_to VARCHAR2(15)

Line 3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;

3701: l_ar_missingtrx_total NUMBER;
3702: l_parameter_xml XMLTYPE;
3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;

Line 4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;

4476: l_header_difference BOOLEAN;
4477: l_line_difference BOOLEAN;
4478: l_has_unmatched BOOLEAN;
4479: l_xml_output XMLTYPE;
4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4482: l_ar_customer_name hz_parties.party_name%TYPE;
4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4484: l_missing_artrx_seq NUMBER;

Line 4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;

4477: l_line_difference BOOLEAN;
4478: l_has_unmatched BOOLEAN;
4479: l_xml_output XMLTYPE;
4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4482: l_ar_customer_name hz_parties.party_name%TYPE;
4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4484: l_missing_artrx_seq NUMBER;
4485: l_gta_trx_number_missing VARCHAR2(2000);

Line 4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

4479: l_xml_output XMLTYPE;
4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4482: l_ar_customer_name hz_parties.party_name%TYPE;
4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
4484: l_missing_artrx_seq NUMBER;
4485: l_gta_trx_number_missing VARCHAR2(2000);
4486: l_gt_invoice_number_missing VARCHAR2(2000);
4487: l_gt_invoice_amount_missing NUMBER;

Line 4488: l_ar_trx_number_missing ra_customer_trx_all.trx_number%TYPE;

4484: l_missing_artrx_seq NUMBER;
4485: l_gta_trx_number_missing VARCHAR2(2000);
4486: l_gt_invoice_number_missing VARCHAR2(2000);
4487: l_gt_invoice_amount_missing NUMBER;
4488: l_ar_trx_number_missing ra_customer_trx_all.trx_number%TYPE;
4489:
4490: l_delimiter VARCHAR2(1)
4491: :=',';
4492: l_validated_lines NUMBER;

Line 4514: ,ra_customer_trx_all ct

4510: ,rac_bill_party.party_name customer_name
4511: ,ct.invoice_currency_code
4512: FROM
4513: jmf_gta_trx_headers gta
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