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
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
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';
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';
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)
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