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 ( (lookup_type <> 'ITEM_TYPE') OR (lookup_type = 'ITEM_TYPE' AND view_application_id in (0,3)))
118: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND

Line 125: FROM FND_LOOKUP_VALUES_VL

121: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
122: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
123: IS
124: SELECT DISTINCT lookup_code
125: FROM FND_LOOKUP_VALUES_VL
126: WHERE lookup_type = c_lookup_type
127: AND lookup_code = c_lookup_code
128: AND ( (lookup_type <> 'ITEM_TYPE') OR (lookup_type = 'ITEM_TYPE' AND view_application_id in (0,3)))
129: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND

Line 347: , fnd_lookup_values_vl IT

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

Line 395: , fnd_lookup_values_vl IT

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

Line 925: , fnd_lookup_values_vl IT

921: mtl.comms_nl_trackable_flag
922: from MTL_SYSTEM_ITEMS_KFV MTL
923: , MTL_PARAMETERS MP
924: , MTL_PARAMETERS MP1
925: , fnd_lookup_values_vl IT
926: where
927: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
928: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
929: and MP.MASTER_ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 973: , fnd_lookup_values_vl IT

969: mtl.organization_id ,
970: mtl.comms_nl_trackable_flag
971: from MTL_SYSTEM_ITEMS_KFV MTL
972: , MTL_PARAMETERS MP
973: , fnd_lookup_values_vl IT
974: where
975: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
976: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
977: and sysdate between nvl( MTL.start_date_active, sysdate )

Line 3950: , fnd_lookup_values_vl fnd

3946: ahl_mc_relationships mcr
3947: , ahl_mc_headers_b mch
3948: , ahl_mc_path_position_nodes mcp
3949: , AHL_ROUTE_EFFECTIVITIES_V re
3950: , fnd_lookup_values_vl fnd
3951: , AHL_RT_OPER_MATERIALS AOB
3952: WHERE
3953: mch.mc_header_id = mcr.mc_header_id
3954: and mch.mc_id = mcp.mc_id

Line 4350: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,

4346: (
4347: x_return_status OUT NOCOPY VARCHAR2,
4348: x_msg_data OUT NOCOPY VARCHAR2,
4349: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,
4350: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,
4351: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE
4352: )
4353: IS
4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;

Line 4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)

4352: )
4353: IS
4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;
4355:
4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)
4357: IS
4358: SELECT DISTINCT amr.position_key
4359: FROM
4360: AHL_MC_RELATIONSHIPS amr,

Line 4361: FND_LOOKUP_VALUES_VL flv,

4357: IS
4358: SELECT DISTINCT amr.position_key
4359: FROM
4360: AHL_MC_RELATIONSHIPS amr,
4361: FND_LOOKUP_VALUES_VL flv,
4362: AHL_MC_HEADERS_VL amh
4363: WHERE
4364: amr.mc_header_id = amh.mc_header_id AND
4365: amh.mc_id = NVL(c_mc_id,-1) AND