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 FND_LOOKUP_VALUES_VL

Line 1010: ar_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.

1006: ,gta.invoice_type invoice_type --added by subba.
1007: ,lk.meaning invoice_type_name --added by subba.
1008: ,gta.status--Yao Zhang add for bug#8765631
1009: FROM
1010: ar_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.
1011: WHERE gta.ra_trx_id=l_ar_header_id
1012: AND gta.source='AR'
1013: AND (gta.status='COMPLETED' OR gta.status='CONSOLIDATED')--Yao Zhang modified for bug#8765631
1014: AND gta.latest_version_flag='Y'

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

1034: , gt.invoice_type invoice_type
1035: , lk.meaning invoice_type_name
1036: FROM
1037: ar_gta_trx_headers gt,
1038: fnd_lookup_values_vl lk --added by Subba for R12.1
1039: WHERE gt.gta_trx_number=l_gta_trx_number
1040: AND gt.source='GT'
1041: AND gt.invoice_type = lk.lookup_code
1042: AND lk.lookup_type='AR_GTA_INVOICE_TYPE';

Line 1112: fnd_lookup_values_vl flv

1108: flv.meaning
1109: INTO
1110: l_amount_attr
1111: FROM
1112: fnd_lookup_values_vl flv
1113: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1114: AND flv.lookup_code='AMOUNT';
1115:
1116: SELECT

Line 1121: fnd_lookup_values_vl flv

1117: flv.meaning
1118: INTO
1119: l_taxamount_attr
1120: FROM
1121: fnd_lookup_values_vl flv
1122: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1123: AND flv.lookup_code='VAT_TAX_AMOUNT';
1124:
1125: SELECT

Line 1130: fnd_lookup_values_vl flv

1126: flv.meaning
1127: INTO
1128: l_cust_name_attr
1129: FROM
1130: fnd_lookup_values_vl flv
1131: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1132: AND flv.lookup_code='CUSTOMER_NAME';
1133:
1134: SELECT

Line 1139: fnd_lookup_values_vl flv

1135: flv.meaning
1136: INTO
1137: l_bank_name_account_attr
1138: FROM
1139: fnd_lookup_values_vl flv
1140: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1141: AND flv.lookup_code='BANK_NAME_ACCOUNT';
1142:
1143: SELECT

Line 1148: fnd_lookup_values_vl flv

1144: flv.meaning
1145: INTO
1146: l_address_phone_attr
1147: FROM
1148: fnd_lookup_values_vl flv
1149: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1150: AND flv.lookup_code='ADDRESS_PHONE_NUMBER';
1151:
1152: --added by Subba for R12.1

Line 1159: fnd_lookup_values_vl flv

1155: flv.meaning
1156: INTO
1157: l_invoicetype_attr
1158: FROM
1159: fnd_lookup_values_vl flv
1160: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1161: AND flv.lookup_code='INVOICE_TYPE';
1162:
1163:

Line 1170: fnd_lookup_values_vl flv

1166: flv.meaning
1167: INTO
1168: l_taxpayer_id_attr
1169: FROM
1170: fnd_lookup_values_vl flv
1171: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
1172: AND flv.lookup_code='TAX_PAYER_ID';*/
1173:
1174:

Line 2386: fnd_lookup_values_vl flv

2382: flv.meaning
2383: INTO
2384: l_goods_description_attr
2385: FROM
2386: fnd_lookup_values_vl flv
2387: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2388: AND flv.lookup_code='GOODS_DESCRIPTION';
2389:
2390: SELECT

Line 2395: fnd_lookup_values_vl flv

2391: flv.meaning
2392: INTO
2393: l_line_amount_attr
2394: FROM
2395: fnd_lookup_values_vl flv
2396: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2397: AND flv.lookup_code='LINE_AMOUNT';
2398:
2399: SELECT

Line 2404: fnd_lookup_values_vl flv

2400: flv.meaning
2401: INTO
2402: l_vat_line_tax_attr
2403: FROM
2404: fnd_lookup_values_vl flv
2405: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2406: AND flv.lookup_code='VAT_TAX_AMOUNT';
2407:
2408: SELECT

Line 2413: fnd_lookup_values_vl flv

2409: flv.meaning
2410: INTO
2411: l_vat_tax_rate_attr
2412: FROM
2413: fnd_lookup_values_vl flv
2414: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2415: AND flv.lookup_code='VAT_TAX_RATE';
2416:
2417: SELECT

Line 2422: fnd_lookup_values_vl flv

2418: flv.meaning
2419: INTO
2420: l_quantity_attr
2421: FROM
2422: fnd_lookup_values_vl flv
2423: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2424: AND flv.lookup_code='QUANTITY';
2425:
2426: SELECT

Line 2431: fnd_lookup_values_vl flv

2427: flv.meaning
2428: INTO
2429: l_unit_price_attr
2430: FROM
2431: fnd_lookup_values_vl flv
2432: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2433: AND flv.lookup_code='UNIT_PRICE';
2434:
2435: SELECT

Line 2440: fnd_lookup_values_vl flv

2436: flv.meaning
2437: INTO
2438: l_uom_attr
2439: FROM
2440: fnd_lookup_values_vl flv
2441: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2442: AND flv.lookup_code='UOM';
2443:
2444: SELECT

Line 2449: fnd_lookup_values_vl flv

2445: flv.meaning
2446: INTO
2447: l_tax_reg_number_attr
2448: FROM
2449: fnd_lookup_values_vl flv
2450: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
2451: AND flv.lookup_code='TAX_REGISTRATION_NUMBER';
2452:
2453: FND_MESSAGE.Set_Name(APPLICATION => 'AR'

Line 5302: l_invoice_type_disp FND_LOOKUP_VALUES_VL.MEANING%TYPE;

5298: l_invoice_type AR_Gta_Trx_Headers_All.INVOICE_TYPE%TYPE
5299: := p_invoice_type;
5300:
5301: -- added by Allen Yang for bug 8848696 02-Sep-2009
5302: l_invoice_type_disp FND_LOOKUP_VALUES_VL.MEANING%TYPE;
5303: -- end added by Allen Yang
5304:
5305: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5306: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 5409: FROM FND_LOOKUP_VALUES_VL

5405: ---------------------------------------------------------------
5406: BEGIN
5407: SELECT meaning
5408: INTO l_invoice_type_disp
5409: FROM FND_LOOKUP_VALUES_VL
5410: WHERE lookup_type = 'AR_GTA_INVOICE_TYPE'
5411: AND lookup_code = p_invoice_type;
5412: EXCEPTION
5413: WHEN NO_DATA_FOUND THEN

Line 5587: , FND_LOOKUP_VALUES_VL FLTV

5583: -- end modified by Allen
5584: INTO
5585: l_ret_xmlelement
5586: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
5587: , FND_LOOKUP_VALUES_VL FLTV
5588: WHERE GTA_TRX_HEADER_ID = p_trx_header_id
5589: AND FLTV.LOOKUP_TYPE = 'AR_GTA_INVOICE_TYPE'
5590: AND JGTHA.INVOICE_TYPE = FLTV.LOOKUP_CODE;
5591: -----------------------------------------------------------------------------

Line 5789: ar_gta_trx_headers gta, fnd_lookup_values_vl lk

5785: , gta.gta_trx_number
5786: ,gta.invoice_type invoice_type
5787: ,lk.meaning invoice_type_name
5788: FROM
5789: ar_gta_trx_headers gta, fnd_lookup_values_vl lk
5790: WHERE gta.gta_trx_header_id=l_gta_header_id
5791: AND gta.invoice_type = lk.lookup_code
5792: AND lk.lookup_type='AR_GTA_INVOICE_TYPE';
5793:

Line 5804: FROM ar_gta_trx_headers gt, fnd_lookup_values_vl lk

5800: gt.customer_address_phone customer_address_phone,
5801: gt.gt_invoice_number,
5802: gt.invoice_type invoice_type,
5803: lk.meaning invoice_type_name
5804: FROM ar_gta_trx_headers gt, fnd_lookup_values_vl lk
5805: WHERE gt.gta_trx_number IN
5806: (SELECT gta_trx_number
5807: FROM ar_gta_trx_headers gta
5808: WHERE gta.gta_trx_header_id = l_gta_header_id)

Line 5833: fnd_lookup_values_vl flv

5829: flv.meaning
5830: INTO
5831: l_amount_attr
5832: FROM
5833: fnd_lookup_values_vl flv
5834: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5835: AND flv.lookup_code='AMOUNT';
5836:
5837: SELECT

Line 5842: fnd_lookup_values_vl flv

5838: flv.meaning
5839: INTO
5840: l_taxamount_attr
5841: FROM
5842: fnd_lookup_values_vl flv
5843: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5844: AND flv.lookup_code='VAT_TAX_AMOUNT';
5845:
5846: SELECT

Line 5851: fnd_lookup_values_vl flv

5847: flv.meaning
5848: INTO
5849: l_cust_name_attr
5850: FROM
5851: fnd_lookup_values_vl flv
5852: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5853: AND flv.lookup_code='CUSTOMER_NAME';
5854:
5855: SELECT

Line 5860: fnd_lookup_values_vl flv

5856: flv.meaning
5857: INTO
5858: l_bank_name_account_attr
5859: FROM
5860: fnd_lookup_values_vl flv
5861: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5862: AND flv.lookup_code='BANK_NAME_ACCOUNT';
5863:
5864: SELECT

Line 5869: fnd_lookup_values_vl flv

5865: flv.meaning
5866: INTO
5867: l_address_phone_attr
5868: FROM
5869: fnd_lookup_values_vl flv
5870: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5871: AND flv.lookup_code='ADDRESS_PHONE_NUMBER';
5872:
5873: SELECT

Line 5878: fnd_lookup_values_vl flv

5874: flv.meaning
5875: INTO
5876: l_invoicetype_attr
5877: FROM
5878: fnd_lookup_values_vl flv
5879: WHERE flv.lookup_type='AR_GTA_DISCREPANCY_ATTRIBUTE'
5880: AND flv.lookup_code='INVOICE_TYPE';
5881:
5882: