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 JMF_GTA_TRX_HEADERS_ALL

Line 121: Jmf_Gta_Trx_Headers_All Gt

117: COUNT(*)
118: INTO
119: l_count
120: FROM
121: Jmf_Gta_Trx_Headers_All Gt
122: WHERE Gt.Ra_Trx_Id = p_ar_trx_header_id
123: AND Source='GT'
124: AND Status='COMPLETED'
125: AND (Gt_Invoice_Number NOT BETWEEN p_Gt_Inv_Num_From

Line 376: jmf_gta_trx_headers_all

372: COUNT(*)
373: INTO
374: l_count
375: FROM
376: jmf_gta_trx_headers_all
377: WHERE Ra_Trx_Id=P_Ar_Trx_Header_Id
378: AND Source='GT'
379: AND Status='COMPLETED'
380: AND Gt_Invoice_Number BETWEEN p_Gt_Inv_Num_From

Line 403: Jmf_Gta_Trx_Headers_all

399: ))))
400: INTO
401: l_Ret_Xmlelement
402: FROM
403: Jmf_Gta_Trx_Headers_all
404: WHERE Ra_Trx_Id=P_Ar_Trx_Header_Id
405: AND Source='GT'
406: AND Status='COMPLETED'
407: AND Gt_Invoice_Number BETWEEN p_Gt_Inv_Num_From

Line 519: Jmf_Gta_Trx_Headers_All Gt

515: CURSOR C_Trx_Ids IS
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

Line 802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;

798: l_ar_customer_address_phone VARCHAR2(4000);
799: l_ar_customer_phone hz_contact_points.phone_number%TYPE;
800: l_gta_amount NUMBER;
801: l_gta_taxamount NUMBER;
802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;

Line 803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;

799: l_ar_customer_phone hz_contact_points.phone_number%TYPE;
800: l_gta_amount NUMBER;
801: l_gta_taxamount NUMBER;
802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
807: l_gta_amount_sum NUMBER;

Line 804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;

800: l_gta_amount NUMBER;
801: l_gta_taxamount NUMBER;
802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
807: l_gta_amount_sum NUMBER;
808: l_gta_amount_sum_disp VARCHAR2(50);

Line 805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;

801: l_gta_taxamount NUMBER;
802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
807: l_gta_amount_sum NUMBER;
808: l_gta_amount_sum_disp VARCHAR2(50);
809: l_gta_taxamount_sum NUMBER;

Line 806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;

802: l_gta_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
803: l_gta_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
804: l_gta_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
805: l_gta_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
806: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
807: l_gta_amount_sum NUMBER;
808: l_gta_amount_sum_disp VARCHAR2(50);
809: l_gta_taxamount_sum NUMBER;
810: l_gta_taxamount_sum_disp VARCHAR2(50);

Line 814: l_gt_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;

810: l_gta_taxamount_sum_disp VARCHAR2(50);
811: l_gta_trx_number_con VARCHAR2(4000);
812: l_gt_amount NUMBER;
813: l_gt_taxamount NUMBER;
814: l_gt_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
815: l_gt_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
816: l_gt_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
817: l_gt_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
818: l_gt_amount_sum NUMBER;

Line 815: l_gt_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;

811: l_gta_trx_number_con VARCHAR2(4000);
812: l_gt_amount NUMBER;
813: l_gt_taxamount NUMBER;
814: l_gt_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
815: l_gt_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
816: l_gt_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
817: l_gt_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
818: l_gt_amount_sum NUMBER;
819: l_gt_amount_sum_disp VARCHAR2(50);

Line 816: l_gt_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;

812: l_gt_amount NUMBER;
813: l_gt_taxamount NUMBER;
814: l_gt_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
815: l_gt_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
816: l_gt_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
817: l_gt_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
818: l_gt_amount_sum NUMBER;
819: l_gt_amount_sum_disp VARCHAR2(50);
820: l_gt_taxamount_sum NUMBER;

Line 817: l_gt_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;

813: l_gt_taxamount NUMBER;
814: l_gt_customer_name jmf_gta_trx_headers_all.bill_to_customer_name%TYPE;
815: l_gt_taxpayer_id jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
816: l_gt_customer_bank_account jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
817: l_gt_customer_address_phone jmf_gta_trx_headers_all.customer_address_phone%TYPE;
818: l_gt_amount_sum NUMBER;
819: l_gt_amount_sum_disp VARCHAR2(50);
820: l_gt_taxamount_sum NUMBER;
821: l_gt_taxamount_sum_disp VARCHAR2(50);

Line 822: l_gt_invoice_number jmf_gta_trx_headers_all.gt_invoice_number%TYPE;

818: l_gt_amount_sum NUMBER;
819: l_gt_amount_sum_disp VARCHAR2(50);
820: l_gt_taxamount_sum NUMBER;
821: l_gt_taxamount_sum_disp VARCHAR2(50);
822: l_gt_invoice_number jmf_gta_trx_headers_all.gt_invoice_number%TYPE;
823: l_gt_invoice_number_con VARCHAR2(4000);
824: l_gta_header_id NUMBER;
825: l_ar_mask_bank VARCHAR2(50);
826: l_amount_discrepancy VARCHAR2(40);

Line 838: l_gta_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;

834: l_address_phone_attr fnd_lookup_values.meaning%TYPE;
835: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;
836:
837: l_ar_customer_bank_account_m VARCHAR2(360);
838: l_gta_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
839: l_gt_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
840: l_ar_bank_name ce_bank_branches_v.bank_name%TYPE;
841: l_ar_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
842: l_ar_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 839: l_gt_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;

835: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;
836:
837: l_ar_customer_bank_account_m VARCHAR2(360);
838: l_gta_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
839: l_gt_customer_bank_account_m jmf_gta_trx_headers_all.bank_account_name_number%TYPE;
840: l_ar_bank_name ce_bank_branches_v.bank_name%TYPE;
841: l_ar_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
842: l_ar_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
843: l_ar_bank_account_name ce_bank_accounts.bank_account_name%TYPE;

Line 1797: jmf_gta_trx_headers_all gta_header

1793: WHERE gta_line.gta_trx_header_id=
1794: (SELECT
1795: gta_header.gta_trx_header_id
1796: FROM
1797: jmf_gta_trx_headers_all gta_header
1798: WHERE gta_header.source='AR'
1799: AND gta_header.gta_trx_number=l_gta_trx_number
1800: )
1801: AND gta_line.enabled_flag='Y';

Line 1810: jmf_gta_trx_headers_all gt_header

1806: WHERE gt_line.gta_trx_header_id=
1807: (SELECT
1808: gt_header.gta_trx_header_id
1809: FROM
1810: jmf_gta_trx_headers_all gt_header
1811: WHERE gt_header.source='GT'
1812: AND gt_header.gta_trx_number=l_gta_trx_number
1813: );
1814: END IF; --(l_gta_taxpayer_id<>l_gt_taxpayer_id)

Line 2029: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;

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;
2032: l_gta_line_amount NUMBER;
2033: l_gta_vat_line_tax NUMBER;

Line 2044: l_gta_tax_reg_number jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;

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);
2043: l_gta_line_quantity_sum NUMBER;
2044: l_gta_tax_reg_number jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
2045: l_matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE;
2046: l_matched_flag_total jmf_gta_trx_lines_all.matched_flag%TYPE;
2047: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;

Line 2059: --l_gt_invoice_number jmf_gta_trx_headers_all.gt_invoice_number%TYPE;

2055: l_uom_attr fnd_lookup_values.meaning%TYPE;
2056: l_gt_value VARCHAR2(500);
2057:
2058: --Change length of the variable l_gt_invoice_number to 4000 to fix bug 6132187
2059: --l_gt_invoice_number jmf_gta_trx_headers_all.gt_invoice_number%TYPE;
2060: l_gt_invoice_number VARCHAR2(4000);
2061: --------------------------------------------------
2062:
2063: l_gta_trx_number_con VARCHAR2(4000);

Line 2143: jmf_gta_trx_headers_all jgth

2139: CURSOR c_gt_invoice_number IS
2140: SELECT
2141: jgth.gt_invoice_number
2142: FROM
2143: jmf_gta_trx_headers_all jgth
2144: WHERE jgth.source='GT'
2145: AND jgth.gta_trx_number=l_gta_trx_number;
2146:
2147: CURSOR c_missing_ar_line IS

Line 3660: l_gta_batch_num_from jmf_gta_trx_headers_all.gta_batch_number%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;
3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;

Line 3662: l_gta_batch_num_to jmf_gta_trx_headers_all.gta_batch_number%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;
3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3665: l_cust_num_from hz_cust_accounts.account_number%TYPE
3666: :=p_cust_num_from;