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

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 577: ,Ra_Customer_Trx Ar

573: INTO
574: l_Gt_Rows
575: FROM
576: Jmf_Gta_Trx_Headers Gt
577: ,Ra_Customer_Trx Ar
578: WHERE Gt.Ra_Trx_Id=Ar.Customer_Trx_Id
579: AND Gt.Org_Id=P_Org_Id
580: AND Gt.Fp_Tax_Registration_Number=NVL(p_fp_tax_reg_num
581: ,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 2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_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;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);

Line 2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;

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;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);
2021: l_ar_vat_line_tax NUMBER;

Line 2018: l_ar_goods_description ra_customer_trx_lines_all.description%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;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);
2021: l_ar_vat_line_tax NUMBER;
2022: l_ar_vat_line_tax_disp VARCHAR2(50);

Line 2027: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;

2023: l_ar_vat_tax_rate NUMBER;
2024: l_ar_quantity NUMBER;
2025: l_ar_unit_price NUMBER;
2026: l_ar_unit_price_disp VARCHAR2(50);
2027: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2028: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2029: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
2030: l_gta_line_number jmf_gta_trx_lines_all.line_number%TYPE;
2031: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;

Line 2031: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;

2027: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2028: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2029: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
2030: l_gta_line_number jmf_gta_trx_lines_all.line_number%TYPE;
2031: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;
2032: l_gta_line_amount NUMBER;
2033: l_gta_vat_line_tax NUMBER;
2034: l_gta_vat_tax_rate NUMBER;
2035: l_gta_quantity NUMBER;

Line 2038: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;

2034: l_gta_vat_tax_rate NUMBER;
2035: l_gta_quantity NUMBER;
2036: l_gta_unit_price NUMBER;
2037: l_gta_unit_price_disp VARCHAR2(50);
2038: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;
2039: l_gta_line_amount_sum NUMBER;
2040: l_gta_line_amount_sum_disp VARCHAR2(50);
2041: l_gta_line_taxamount_sum NUMBER;
2042: l_gta_line_taxamount_sum_disp VARCHAR2(50);

Line 2092: ra_customer_trx_lines rctl

2088: ,rctl.quantity_invoiced quantity
2089: ,rctl.unit_selling_price unit_price
2090: ,rctl.uom_code uom
2091: FROM
2092: ra_customer_trx_lines rctl
2093: WHERE rctl.customer_trx_id=l_ar_header_id
2094: AND rctl.line_type='LINE';
2095:
2096: CURSOR c_gta_lines IS

Line 2162: ra_customer_trx_lines rctl

2158: AND jgtl.gta_trx_header_id=jgth.gta_trx_header_id
2159: AND NOT EXISTS (SELECT
2160: rctl.customer_trx_line_id
2161: FROM
2162: ra_customer_trx_lines rctl
2163: WHERE rctl.customer_trx_id=l_ar_header_id
2164: AND rctl.customer_trx_line_id=jgtl.ar_trx_line_id
2165: );
2166:

Line 2184: ra_customer_trx_lines rctl

2180: SELECT
2181: rctl.customer_trx_line_id ar_line_id
2182: ,rctl.line_number ar_line_num
2183: FROM
2184: ra_customer_trx_lines rctl
2185: WHERE rctl.customer_trx_id=l_ar_header_id
2186: AND EXISTS (SELECT
2187: zl.trx_line_id
2188: FROM

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