APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MTL_ITEMS_EAM_V

Line 319: AHL_MTL_ITEMS_EAM_V mtl

315: mtl.INVENTORY_ITEM_ID ,
316: mtl.organization_id ,
317: mtl.inventory_item_flag
318: from
319: AHL_MTL_ITEMS_EAM_V mtl
320: where
321: MTL.inventory_item_flag = 'Y'
322: AND mtl.enabled_flag = 'Y'
323: and mtl.concatenated_segments like c_item_number

Line 367: from AHL_MTL_ITEMS_EAM_V mtl

363: SELECT
364: mtl.INVENTORY_ITEM_ID ,
365: mtl.organization_id ,
366: mtl.inventory_item_flag
367: from AHL_MTL_ITEMS_EAM_V mtl
368: where
369: MTL.inventory_item_flag = 'Y'
370: AND mtl.enabled_flag = 'Y'
371: and mtl.inventory_item_id = c_inventory_item_id

Line 525: FROM AHL_MTL_ITEMS_EAM_V MTL

521: MTL.inventory_item_flag,
522: MTL.mtl_transactions_enabled_flag,
523: MTL.stock_enabled_flag,
524: NVL(MTL.wip_supply_type,0)
525: FROM AHL_MTL_ITEMS_EAM_V MTL
526: WHERE
527: MTL.concatenated_segments = c_item_number
528: AND MTL.organization_id = c_inventory_org_id
529: AND MTL.enabled_flag = 'Y';

Line 576: FROM AHL_MTL_ITEMS_EAM_V MTL

572: MTL.inventory_item_flag,
573: MTL.mtl_transactions_enabled_flag,
574: MTL.stock_enabled_flag,
575: NVL(MTL.wip_supply_type,0)
576: FROM AHL_MTL_ITEMS_EAM_V MTL
577: WHERE
578: MTL.inventory_item_id = c_inventory_item_id
579: AND MTL.organization_id = c_inventory_org_id
580: AND MTL.enabled_flag = 'Y';

Line 891: from AHL_MTL_ITEMS_EAM_V MTL

887: SELECT
888: MTL.INVENTORY_ITEM_ID ,
889: MTL.organization_id ,
890: MTL.comms_nl_trackable_flag
891: from AHL_MTL_ITEMS_EAM_V MTL
892: where
893: upper(nvl(MTL.comms_nl_trackable_flag,'N')) = 'Y'
894: and MTL.enabled_flag = 'Y'
895: and upper(MTL.concatenated_segments) like upper(c_item_number)

Line 941: from AHL_MTL_ITEMS_EAM_V MTL

937: SELECT
938: mtl.INVENTORY_ITEM_ID ,
939: mtl.organization_id ,
940: mtl.comms_nl_trackable_flag
941: from AHL_MTL_ITEMS_EAM_V MTL
942: where
943: upper(nvl(MTL.comms_nl_trackable_flag,'N')) = 'Y'
944: and MTL.enabled_flag = 'Y'
945: and mtl.inventory_item_id = c_inventory_item_id