APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MTL_ITEMS_EAM_V

Line 321: AHL_MTL_ITEMS_EAM_V mtl

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

Line 369: from AHL_MTL_ITEMS_EAM_V mtl

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

Line 527: FROM AHL_MTL_ITEMS_EAM_V MTL

523: MTL.inventory_item_flag,
524: MTL.mtl_transactions_enabled_flag,
525: MTL.stock_enabled_flag
526: --NVL(MTL.wip_supply_type,0) --pdoki commented for Bug 8589785
527: FROM AHL_MTL_ITEMS_EAM_V MTL
528: WHERE
529: MTL.concatenated_segments = c_item_number
530: AND MTL.organization_id = c_inventory_org_id
531: AND MTL.enabled_flag = 'Y';

Line 578: FROM AHL_MTL_ITEMS_EAM_V MTL

574: MTL.inventory_item_flag,
575: MTL.mtl_transactions_enabled_flag,
576: MTL.stock_enabled_flag
577: -- NVL(MTL.wip_supply_type,0) --pdoki commented for Bug 8589785
578: FROM AHL_MTL_ITEMS_EAM_V MTL
579: WHERE
580: MTL.inventory_item_id = c_inventory_item_id
581: AND MTL.organization_id = c_inventory_org_id
582: AND MTL.enabled_flag = 'Y';

Line 897: from AHL_MTL_ITEMS_EAM_V MTL

893: SELECT
894: MTL.INVENTORY_ITEM_ID ,
895: MTL.organization_id ,
896: MTL.comms_nl_trackable_flag
897: from AHL_MTL_ITEMS_EAM_V MTL
898: where
899: upper(nvl(MTL.comms_nl_trackable_flag,'N')) = 'Y'
900: and MTL.enabled_flag = 'Y'
901: and upper(MTL.concatenated_segments) like upper(c_item_number)

Line 947: from AHL_MTL_ITEMS_EAM_V MTL

943: SELECT
944: mtl.INVENTORY_ITEM_ID ,
945: mtl.organization_id ,
946: mtl.comms_nl_trackable_flag
947: from AHL_MTL_ITEMS_EAM_V MTL
948: where
949: upper(nvl(MTL.comms_nl_trackable_flag,'N')) = 'Y'
950: and MTL.enabled_flag = 'Y'
951: and mtl.inventory_item_id = c_inventory_item_id