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 FND_LOOKUP_VALUES

Line 830: l_amount_attr fnd_lookup_values.meaning%TYPE;

826: l_amount_discrepancy VARCHAR2(40);
827: l_taxamount_discrepancy VARCHAR2(40);
828: l_has_difference BOOLEAN;
829:
830: l_amount_attr fnd_lookup_values.meaning%TYPE;
831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%TYPE;
834: l_address_phone_attr fnd_lookup_values.meaning%TYPE;

Line 831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;

827: l_taxamount_discrepancy VARCHAR2(40);
828: l_has_difference BOOLEAN;
829:
830: l_amount_attr fnd_lookup_values.meaning%TYPE;
831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%TYPE;
834: l_address_phone_attr fnd_lookup_values.meaning%TYPE;
835: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;

Line 832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;

828: l_has_difference BOOLEAN;
829:
830: l_amount_attr fnd_lookup_values.meaning%TYPE;
831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%TYPE;
834: l_address_phone_attr fnd_lookup_values.meaning%TYPE;
835: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;
836:

Line 833: l_bank_name_account_attr fnd_lookup_values.meaning%TYPE;

829:
830: l_amount_attr fnd_lookup_values.meaning%TYPE;
831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%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);

Line 834: l_address_phone_attr fnd_lookup_values.meaning%TYPE;

830: l_amount_attr fnd_lookup_values.meaning%TYPE;
831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%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;

Line 835: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;

831: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
832: l_cust_name_attr fnd_lookup_values.meaning%TYPE;
833: l_bank_name_account_attr fnd_lookup_values.meaning%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;

Line 861: l_invoicetype_attr fnd_lookup_values.meaning%TYPE;

857: l_gta_invoice_type_name VARCHAR2(80);
858: l_gt_invoice_type VARCHAR2(1);
859: l_gt_invoice_type_name VARCHAR2(80);
860:
861: l_invoicetype_attr fnd_lookup_values.meaning%TYPE;
862:
863:
864: CURSOR c_ar_header IS
865: SELECT

Line 937: jmf_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.

933: , gta.gta_trx_number
934: ,gta.invoice_type invoice_type --added by subba.
935: ,lk.meaning invoice_type_name --added by subba.
936: FROM
937: jmf_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.
938: WHERE gta.ra_trx_id=l_ar_header_id
939: AND gta.source='AR'
940: AND gta.status='COMPLETED'
941: AND gta.latest_version_flag='Y'

Line 965: fnd_lookup_values_vl lk --added by Subba for R12.1

961: , gt.invoice_type invoice_type
962: , lk.meaning invoice_type_name
963: FROM
964: jmf_gta_trx_headers gt,
965: fnd_lookup_values_vl lk --added by Subba for R12.1
966: WHERE gt.gta_trx_number=l_gta_trx_number
967: AND gt.source='GT'
968: AND gt.invoice_type = lk.lookup_code
969: AND lk.lookup_type='JMF_GTA_INVOICE_TYPE';

Line 1039: fnd_lookup_values_vl flv

1035: flv.meaning
1036: INTO
1037: l_amount_attr
1038: FROM
1039: fnd_lookup_values_vl flv
1040: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1041: AND flv.lookup_code='AMOUNT';
1042:
1043: SELECT

Line 1048: fnd_lookup_values_vl flv

1044: flv.meaning
1045: INTO
1046: l_taxamount_attr
1047: FROM
1048: fnd_lookup_values_vl flv
1049: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1050: AND flv.lookup_code='VAT_TAX_AMOUNT';
1051:
1052: SELECT

Line 1057: fnd_lookup_values_vl flv

1053: flv.meaning
1054: INTO
1055: l_cust_name_attr
1056: FROM
1057: fnd_lookup_values_vl flv
1058: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1059: AND flv.lookup_code='CUSTOMER_NAME';
1060:
1061: SELECT

Line 1066: fnd_lookup_values_vl flv

1062: flv.meaning
1063: INTO
1064: l_bank_name_account_attr
1065: FROM
1066: fnd_lookup_values_vl flv
1067: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1068: AND flv.lookup_code='BANK_NAME_ACCOUNT';
1069:
1070: SELECT

Line 1075: fnd_lookup_values_vl flv

1071: flv.meaning
1072: INTO
1073: l_address_phone_attr
1074: FROM
1075: fnd_lookup_values_vl flv
1076: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1077: AND flv.lookup_code='ADDRESS_PHONE_NUMBER';
1078:
1079: --added by Subba for R12.1

Line 1086: fnd_lookup_values_vl flv

1082: flv.meaning
1083: INTO
1084: l_invoicetype_attr
1085: FROM
1086: fnd_lookup_values_vl flv
1087: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1088: AND flv.lookup_code='INVOICE_TYPE';
1089:
1090:

Line 1097: fnd_lookup_values_vl flv

1093: flv.meaning
1094: INTO
1095: l_taxpayer_id_attr
1096: FROM
1097: fnd_lookup_values_vl flv
1098: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
1099: AND flv.lookup_code='TAX_PAYER_ID';*/
1100:
1101:

Line 2047: l_goods_description_attr fnd_lookup_values.meaning%TYPE;

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;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;

Line 2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;

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;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;

Line 2049: l_vat_line_tax_attr fnd_lookup_values.meaning%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;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;

Line 2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%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;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;
2054: l_unmatched_attr VARCHAR2(100);

Line 2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;

2047: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;
2054: l_unmatched_attr VARCHAR2(100);
2055: l_uom_attr fnd_lookup_values.meaning%TYPE;

Line 2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;

2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;
2054: l_unmatched_attr VARCHAR2(100);
2055: l_uom_attr fnd_lookup_values.meaning%TYPE;
2056: l_gt_value VARCHAR2(500);

Line 2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;

2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;
2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;
2054: l_unmatched_attr VARCHAR2(100);
2055: l_uom_attr fnd_lookup_values.meaning%TYPE;
2056: l_gt_value VARCHAR2(500);
2057:

Line 2055: l_uom_attr fnd_lookup_values.meaning%TYPE;

2051: l_quantity_attr fnd_lookup_values.meaning%TYPE;
2052: l_unit_price_attr fnd_lookup_values.meaning%TYPE;
2053: l_tax_reg_number_attr fnd_lookup_values.meaning%TYPE;
2054: l_unmatched_attr VARCHAR2(100);
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;

Line 2252: fnd_lookup_values_vl flv

2248: flv.meaning
2249: INTO
2250: l_goods_description_attr
2251: FROM
2252: fnd_lookup_values_vl flv
2253: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2254: AND flv.lookup_code='GOODS_DESCRIPTION';
2255:
2256: SELECT

Line 2261: fnd_lookup_values_vl flv

2257: flv.meaning
2258: INTO
2259: l_line_amount_attr
2260: FROM
2261: fnd_lookup_values_vl flv
2262: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2263: AND flv.lookup_code='LINE_AMOUNT';
2264:
2265: SELECT

Line 2270: fnd_lookup_values_vl flv

2266: flv.meaning
2267: INTO
2268: l_vat_line_tax_attr
2269: FROM
2270: fnd_lookup_values_vl flv
2271: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2272: AND flv.lookup_code='VAT_TAX_AMOUNT';
2273:
2274: SELECT

Line 2279: fnd_lookup_values_vl flv

2275: flv.meaning
2276: INTO
2277: l_vat_tax_rate_attr
2278: FROM
2279: fnd_lookup_values_vl flv
2280: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2281: AND flv.lookup_code='VAT_TAX_RATE';
2282:
2283: SELECT

Line 2288: fnd_lookup_values_vl flv

2284: flv.meaning
2285: INTO
2286: l_quantity_attr
2287: FROM
2288: fnd_lookup_values_vl flv
2289: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2290: AND flv.lookup_code='QUANTITY';
2291:
2292: SELECT

Line 2297: fnd_lookup_values_vl flv

2293: flv.meaning
2294: INTO
2295: l_unit_price_attr
2296: FROM
2297: fnd_lookup_values_vl flv
2298: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2299: AND flv.lookup_code='UNIT_PRICE';
2300:
2301: SELECT

Line 2306: fnd_lookup_values_vl flv

2302: flv.meaning
2303: INTO
2304: l_uom_attr
2305: FROM
2306: fnd_lookup_values_vl flv
2307: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2308: AND flv.lookup_code='UOM';
2309:
2310: SELECT

Line 2315: fnd_lookup_values_vl flv

2311: flv.meaning
2312: INTO
2313: l_tax_reg_number_attr
2314: FROM
2315: fnd_lookup_values_vl flv
2316: WHERE flv.lookup_type='JMF_GTA_DISCREPANCY_ATTRIBUTE'
2317: AND flv.lookup_code='TAX_REGISTRATION_NUMBER';
2318:
2319: FND_MESSAGE.Set_Name(APPLICATION => 'JMF'