APPS.POR_VIEW_REQS_PKG dependencies on FND_LOOKUP_VALUES

Line 181: FND_LOOKUP_VALUES FCL1,

177: l_territory_short_name
178: FROM
179: HR_LOCATIONS HLC,
180: FND_TERRITORIES_TL FTE,
181: FND_LOOKUP_VALUES FCL1,
182: FND_LOOKUP_VALUES FCL2,
183: FND_LOOKUP_VALUES FCL3
184: Where
185: HLC.LOCATION_ID = l_location_id AND

Line 182: FND_LOOKUP_VALUES FCL2,

178: FROM
179: HR_LOCATIONS HLC,
180: FND_TERRITORIES_TL FTE,
181: FND_LOOKUP_VALUES FCL1,
182: FND_LOOKUP_VALUES FCL2,
183: FND_LOOKUP_VALUES FCL3
184: Where
185: HLC.LOCATION_ID = l_location_id AND
186: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND

Line 183: FND_LOOKUP_VALUES FCL3

179: HR_LOCATIONS HLC,
180: FND_TERRITORIES_TL FTE,
181: FND_LOOKUP_VALUES FCL1,
182: FND_LOOKUP_VALUES FCL2,
183: FND_LOOKUP_VALUES FCL3
184: Where
185: HLC.LOCATION_ID = l_location_id AND
186: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND
187: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) =

Line 529: FROM fnd_lookup_values lv

525: p_status_code <> 'PICKED_PARTIAL'
526: THEN
527: SELECT meaning
528: INTO l_flow_meaning
529: FROM fnd_lookup_values lv
530: WHERE lookup_type = 'LINE_FLOW_STATUS'
531: AND lookup_code = p_status_code
532: AND LANGUAGE = userenv('LANG')
533: AND VIEW_APPLICATION_ID = 660

Line 551: FROM fnd_lookup_values lv

547:
548: IF l_released_count = l_total_count THEN
549: SELECT meaning
550: INTO l_flow_meaning
551: FROM fnd_lookup_values lv
552: WHERE lookup_type = 'LINE_FLOW_STATUS'
553: AND lookup_code = 'PICKED'
554: AND LANGUAGE = userenv('LANG')
555: AND VIEW_APPLICATION_ID = 660

Line 563: FROM fnd_lookup_values lv

559:
560: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
561: SELECT meaning
562: INTO l_flow_meaning
563: FROM fnd_lookup_values lv
564: WHERE lookup_type = 'LINE_FLOW_STATUS'
565: AND lookup_code = 'PICKED_PARTIAL'
566: AND LANGUAGE = userenv('LANG')
567: AND VIEW_APPLICATION_ID = 660

Line 574: FROM fnd_lookup_values lv

570: lv.view_application_id);
571: ELSE
572: SELECT meaning
573: INTO l_flow_meaning
574: FROM fnd_lookup_values lv
575: WHERE lookup_type = 'LINE_FLOW_STATUS'
576: AND lookup_code = p_status_code
577: AND LANGUAGE = userenv('LANG')
578: AND VIEW_APPLICATION_ID = 660

Line 629: FROM fnd_lookup_values lv

625:
626: IF (l_status_code is not null) THEN
627: SELECT meaning
628: INTO l_flow_meaning
629: FROM fnd_lookup_values lv
630: WHERE lookup_type = 'LINE_FLOW_STATUS'
631: AND lookup_code = l_status_code
632: AND LANGUAGE = userenv('LANG')
633: AND VIEW_APPLICATION_ID = 660