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.PO_FED_FIELD_FUNCTIONS dependencies on FND_LOOKUP_VALUES

Line 1401: FND_LOOKUP_VALUES FCL1,

1397: hlc.postal_code,
1398: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1399: FROM HR_LOCATIONS HLC,
1400: FND_TERRITORIES_TL FTE,
1401: FND_LOOKUP_VALUES FCL1,
1402: FND_LOOKUP_VALUES FCL2,
1403: FND_LOOKUP_VALUES FCL3
1404: WHERE HLC.LOCATION_ID = :1
1405: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)

Line 1402: FND_LOOKUP_VALUES FCL2,

1398: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1399: FROM HR_LOCATIONS HLC,
1400: FND_TERRITORIES_TL FTE,
1401: FND_LOOKUP_VALUES FCL1,
1402: FND_LOOKUP_VALUES FCL2,
1403: FND_LOOKUP_VALUES FCL3
1404: WHERE HLC.LOCATION_ID = :1
1405: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
1406: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))

Line 1403: FND_LOOKUP_VALUES FCL3

1399: FROM HR_LOCATIONS HLC,
1400: FND_TERRITORIES_TL FTE,
1401: FND_LOOKUP_VALUES FCL1,
1402: FND_LOOKUP_VALUES FCL2,
1403: FND_LOOKUP_VALUES FCL3
1404: WHERE HLC.LOCATION_ID = :1
1405: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
1406: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))
1407: AND HLC.REGION_1 = FCL1.LOOKUP_CODE (+)

Line 1519: FND_LOOKUP_VALUES FCL1,

1515: hlc.postal_code,
1516: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1517: FROM HR_LOCATIONS HLC,
1518: FND_TERRITORIES_TL FTE,
1519: FND_LOOKUP_VALUES FCL1,
1520: FND_LOOKUP_VALUES FCL2,
1521: FND_LOOKUP_VALUES FCL3
1522: WHERE HLC.LOCATION_ID = :1
1523: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)

Line 1520: FND_LOOKUP_VALUES FCL2,

1516: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1517: FROM HR_LOCATIONS HLC,
1518: FND_TERRITORIES_TL FTE,
1519: FND_LOOKUP_VALUES FCL1,
1520: FND_LOOKUP_VALUES FCL2,
1521: FND_LOOKUP_VALUES FCL3
1522: WHERE HLC.LOCATION_ID = :1
1523: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
1524: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))

Line 1521: FND_LOOKUP_VALUES FCL3

1517: FROM HR_LOCATIONS HLC,
1518: FND_TERRITORIES_TL FTE,
1519: FND_LOOKUP_VALUES FCL1,
1520: FND_LOOKUP_VALUES FCL2,
1521: FND_LOOKUP_VALUES FCL3
1522: WHERE HLC.LOCATION_ID = :1
1523: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
1524: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))
1525: AND HLC.REGION_1 = FCL1.LOOKUP_CODE (+)

Line 1940: FND_LOOKUP_VALUES FCL1,

1936: l_vendor_city, l_vendor_province_code, l_vendor_province, l_vendor_state_code, l_vendor_state, l_vendor_country_code,
1937: l_vendor_country,l_vendor_zip
1938: from PO_VENDOR_SITES_ALL vsa, po_vendors pvn,
1939: fnd_territories_tl fte,
1940: FND_LOOKUP_VALUES FCL1,
1941: FND_LOOKUP_VALUES FCL2,
1942: FND_LOOKUP_VALUES FCL3
1943: where vsa.vendor_site_id = p_supplier_site_id
1944: and vsa.vendor_id = pvn.vendor_id

Line 1941: FND_LOOKUP_VALUES FCL2,

1937: l_vendor_country,l_vendor_zip
1938: from PO_VENDOR_SITES_ALL vsa, po_vendors pvn,
1939: fnd_territories_tl fte,
1940: FND_LOOKUP_VALUES FCL1,
1941: FND_LOOKUP_VALUES FCL2,
1942: FND_LOOKUP_VALUES FCL3
1943: where vsa.vendor_site_id = p_supplier_site_id
1944: and vsa.vendor_id = pvn.vendor_id
1945: and vsa.country = fte.territory_code (+)

Line 1942: FND_LOOKUP_VALUES FCL3

1938: from PO_VENDOR_SITES_ALL vsa, po_vendors pvn,
1939: fnd_territories_tl fte,
1940: FND_LOOKUP_VALUES FCL1,
1941: FND_LOOKUP_VALUES FCL2,
1942: FND_LOOKUP_VALUES FCL3
1943: where vsa.vendor_site_id = p_supplier_site_id
1944: and vsa.vendor_id = pvn.vendor_id
1945: and vsa.country = fte.territory_code (+)
1946: AND DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG'))

Line 2084: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;

2080: d_proc_name CONSTANT varchar2(50) := 'supplier_details_XD';
2081: d_module CONSTANT varchar2(100):= d_pkg_name ||'.'||d_proc_name;
2082: d_progress NUMBER(6);
2083:
2084: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;
2085: l_meanings_table varchar_table;
2086:
2087: l_doing_bsns_as varchar2(100);
2088: l_suplr_size varchar2(100);

Line 2290: FROM FND_LOOKUP_VALUES

2286: END IF ;
2287:
2288: SELECT MEANING
2289: INTO p_ccr_reg_status
2290: FROM FND_LOOKUP_VALUES
2291: WHERE LOOKUP_TYPE='FV_CCR_REG_STATUS'
2292: AND LOOKUP_CODE = l_ccr_reg_status
2293: AND LANGUAGE = UserEnv('Lang');
2294:

Line 2305: FROM fnd_lookup_values_vl flv,

2301: WHERE vendor_id = x_supplier_id;
2302:
2303: SELECT flv.meaning
2304: BULK COLLECT INTO l_meanings_table
2305: FROM fnd_lookup_values_vl flv,
2306: POS_BUS_CLASS_ATTR pca
2307: WHERE flv.enabled_flag='Y'
2308: AND flv.start_date_active < sysdate
2309: AND (flv.end_date_active > sysdate or flv.end_date_active is null)

Line 2653: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;

2649:
2650: d_proc_name CONSTANT varchar2(50) := 'supplier_details_XRD';
2651: d_module CONSTANT varchar2(100):= d_pkg_name ||'.'||d_proc_name;
2652:
2653: TYPE varchar_table IS TABLE OF fnd_lookup_values_vl.meaning%TYPE INDEX BY PLS_INTEGER ;
2654: l_meanings_table varchar_table;
2655:
2656: l_supplier_id NUMBER(10);
2657: l_supplier_site_id NUMBER(10);

Line 2856: FROM FND_LOOKUP_VALUES

2852: END IF ;
2853:
2854: SELECT MEANING
2855: INTO p_ccr_reg_status
2856: FROM FND_LOOKUP_VALUES
2857: WHERE LOOKUP_TYPE='FV_CCR_REG_STATUS'
2858: AND LOOKUP_CODE = l_ccr_reg_status
2859: AND LANGUAGE = UserEnv('Lang');
2860:

Line 2884: FROM fnd_lookup_values_vl flv,

2880: WHERE vendor_id = l_supplier_id;
2881:
2882: SELECT flv.meaning
2883: BULK COLLECT INTO l_meanings_table
2884: FROM fnd_lookup_values_vl flv,
2885: POS_BUS_CLASS_ATTR pca
2886: WHERE flv.enabled_flag='Y'
2887: AND flv.start_date_active < sysdate
2888: AND (flv.end_date_active > sysdate or flv.end_date_active is null)

Line 3140: FND_LOOKUP_VALUES FCL1,

3136: hlc.postal_code,
3137: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
3138: FROM HR_LOCATIONS HLC,
3139: FND_TERRITORIES_TL FTE,
3140: FND_LOOKUP_VALUES FCL1,
3141: FND_LOOKUP_VALUES FCL2,
3142: FND_LOOKUP_VALUES FCL3
3143: WHERE HLC.LOCATION_ID = :1
3144: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)

Line 3141: FND_LOOKUP_VALUES FCL2,

3137: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
3138: FROM HR_LOCATIONS HLC,
3139: FND_TERRITORIES_TL FTE,
3140: FND_LOOKUP_VALUES FCL1,
3141: FND_LOOKUP_VALUES FCL2,
3142: FND_LOOKUP_VALUES FCL3
3143: WHERE HLC.LOCATION_ID = :1
3144: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
3145: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))

Line 3142: FND_LOOKUP_VALUES FCL3

3138: FROM HR_LOCATIONS HLC,
3139: FND_TERRITORIES_TL FTE,
3140: FND_LOOKUP_VALUES FCL1,
3141: FND_LOOKUP_VALUES FCL2,
3142: FND_LOOKUP_VALUES FCL3
3143: WHERE HLC.LOCATION_ID = :1
3144: AND HLC.COUNTRY = FTE.TERRITORY_CODE (+)
3145: AND DECODE(FTE.TERRITORY_CODE, NULL, ''1'', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, ''1'', USERENV(''LANG''))
3146: AND HLC.REGION_1 = FCL1.LOOKUP_CODE (+)