APPS.AHL_RM_ROUTE_UTIL dependencies on FND_LOOKUP_VALUES_VL

Line 114: FROM FND_LOOKUP_VALUES_VL

110: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
111: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
112: IS
113: SELECT DISTINCT lookup_code
114: FROM FND_LOOKUP_VALUES_VL
115: WHERE lookup_type = c_lookup_type
116: AND meaning = c_lookup_meaning
117: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
118: NVL( end_date_active, SYSDATE );

Line 124: FROM FND_LOOKUP_VALUES_VL

120: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
121: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
122: IS
123: SELECT DISTINCT lookup_code
124: FROM FND_LOOKUP_VALUES_VL
125: WHERE lookup_type = c_lookup_type
126: AND lookup_code = c_lookup_code
127: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
128: NVL( end_date_active, SYSDATE );

Line 345: , fnd_lookup_values_vl IT

341: mtl.organization_id ,
342: NVL(mtl.inventory_item_flag,'X')
343: from
344: MTL_SYSTEM_ITEMS_KFV MTL
345: , fnd_lookup_values_vl IT
346: , MTL_PARAMETERS MP
347: where
348: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
349: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 393: , fnd_lookup_values_vl IT

389: mtl.organization_id ,
390: NVL(mtl.inventory_item_flag,'X')
391: from MTL_SYSTEM_ITEMS_KFV MTL
392: , MTL_PARAMETERS MP
393: , fnd_lookup_values_vl IT
394: where
395: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
396: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
397: and MTL.inventory_item_flag = 'Y'

Line 919: , fnd_lookup_values_vl IT

915: mtl.comms_nl_trackable_flag
916: from MTL_SYSTEM_ITEMS_KFV MTL
917: , MTL_PARAMETERS MP
918: , MTL_PARAMETERS MP1
919: , fnd_lookup_values_vl IT
920: where
921: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
922: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
923: and MP.MASTER_ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 967: , fnd_lookup_values_vl IT

963: mtl.organization_id ,
964: mtl.comms_nl_trackable_flag
965: from MTL_SYSTEM_ITEMS_KFV MTL
966: , MTL_PARAMETERS MP
967: , fnd_lookup_values_vl IT
968: where
969: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
970: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
971: and sysdate between nvl( MTL.start_date_active, sysdate )

Line 3651: , fnd_lookup_values_vl fnd

3647: ahl_mc_relationships mcr
3648: , ahl_mc_headers_b mch
3649: , ahl_mc_path_position_nodes mcp
3650: , AHL_ROUTE_EFFECTIVITIES_V re
3651: , fnd_lookup_values_vl fnd
3652: , AHL_RT_OPER_MATERIALS AOB
3653: WHERE
3654: mch.mc_header_id = mcr.mc_header_id
3655: and mch.mc_id = mcp.mc_id