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_GLOBAL

Line 213: AND FND_USER_ID = fnd_global.user_id;

209: INTO addresscode,location
210: FROM po_user_preferences
211: WHERE functional_area = p_functional_area
212: AND address_type= l_addressType
213: AND FND_USER_ID = fnd_global.user_id;
214: EXCEPTION
215: WHEN No_Data_Found THEN
216: NULL;
217: WHEN OTHERS THEN

Line 234: AND FND_USER_ID = fnd_global.user_id;

230: INTO contact
231: FROM po_user_preferences
232: WHERE functional_area = p_functional_area
233: AND address_type= l_addressType
234: AND FND_USER_ID = fnd_global.user_id;
235: EXCEPTION
236: WHEN No_Data_Found THEN
237: NULL;
238: WHEN OTHERS THEN

Line 1410: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))

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 (+)
1408: AND HLC.COUNTRY
1409: || ''_PROVINCE'' = FCL1.LOOKUP_TYPE (+)
1410: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))
1411: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', 3)
1412: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1413: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
1414: AND HLC.COUNTRY

Line 1416: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))

1412: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1413: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
1414: AND HLC.COUNTRY
1415: || ''_STATE'' = FCL2.LOOKUP_TYPE (+)
1416: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))
1417: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', 3)
1418: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1419: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
1420: AND HLC.COUNTRY

Line 1422: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))

1418: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1419: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
1420: AND HLC.COUNTRY
1421: || ''_COUNTY'' = FCL3.LOOKUP_TYPE (+)
1422: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))
1423: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', 3)
1424: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))';
1425:
1426: EXECUTE IMMEDIATE l_ship_addr_xml_sql INTO p_hidd_ship_addr USING p_ship_to_loc_id;

Line 1528: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))

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 (+)
1526: AND HLC.COUNTRY
1527: || ''_PROVINCE'' = FCL1.LOOKUP_TYPE (+)
1528: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))
1529: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', 3)
1530: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1531: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
1532: AND HLC.COUNTRY

Line 1534: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))

1530: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1531: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
1532: AND HLC.COUNTRY
1533: || ''_STATE'' = FCL2.LOOKUP_TYPE (+)
1534: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))
1535: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', 3)
1536: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1537: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
1538: AND HLC.COUNTRY

Line 1540: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))

1536: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
1537: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
1538: AND HLC.COUNTRY
1539: || ''_COUNTY'' = FCL3.LOOKUP_TYPE (+)
1540: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))
1541: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', 3)
1542: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))';
1543:
1544: EXECUTE IMMEDIATE l_ship_addr_xml_sql INTO p_hidd_ship_addr USING p_ship_to_loc_id;

Line 1950: DECODE(FCL1.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))

1946: AND DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG'))
1947: AND vsa.province = FCL1.LOOKUP_CODE (+)
1948: AND vsa.country || '_PROVINCE' = FCL1.LOOKUP_TYPE (+)
1949: AND DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID)=
1950: DECODE(FCL1.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))
1951: AND DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3)
1952: AND DECODE (FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG'))
1953: AND vsa.state = FCL2.LOOKUP_CODE (+)
1954: AND vsa.country || '_STATE' = FCL2.LOOKUP_TYPE (+)

Line 1956: DECODE(FCL2.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))

1952: AND DECODE (FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG'))
1953: AND vsa.state = FCL2.LOOKUP_CODE (+)
1954: AND vsa.country || '_STATE' = FCL2.LOOKUP_TYPE (+)
1955: AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID)=
1956: DECODE(FCL2.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))
1957: AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3)
1958: AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE)= DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG'))
1959: AND vsa.county = FCL3.LOOKUP_CODE (+)
1960: AND vsa.country ||'_COUNTY' = FCL3.LOOKUP_TYPE (+)

Line 1962: DECODE(FCL3.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))

1958: AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE)= DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG'))
1959: AND vsa.county = FCL3.LOOKUP_CODE (+)
1960: AND vsa.country ||'_COUNTY' = FCL3.LOOKUP_TYPE (+)
1961: AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
1962: DECODE(FCL3.LOOKUP_CODE, NULL, '1',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))
1963: AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3)
1964: AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG'));
1965:
1966:

Line 3149: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))

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 (+)
3147: AND HLC.COUNTRY
3148: || ''_PROVINCE'' = FCL1.LOOKUP_TYPE (+)
3149: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID))
3150: AND DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', 3)
3151: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
3152: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
3153: AND HLC.COUNTRY

Line 3155: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))

3151: AND DECODE (FCL1.LOOKUP_CODE, NULL, ''1'', FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
3152: AND HLC.REGION_2 = FCL2.LOOKUP_CODE (+)
3153: AND HLC.COUNTRY
3154: || ''_STATE'' = FCL2.LOOKUP_TYPE (+)
3155: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID))
3156: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', 3)
3157: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
3158: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
3159: AND HLC.COUNTRY

Line 3161: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))

3157: AND DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))
3158: AND HLC.REGION_1 = FCL3.LOOKUP_CODE (+)
3159: AND HLC.COUNTRY
3160: || ''_COUNTY'' = FCL3.LOOKUP_TYPE (+)
3161: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'',FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID))
3162: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', 3)
3163: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))';
3164:
3165: EXECUTE IMMEDIATE l_ship_addr_xml_sql INTO p_hidd_ship_addr USING l_ship_to_loc_id;