APPS.WIP_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 674: FROM mtl_system_items msi

670: l_shelf_life_code NUMBER;
671: BEGIN
672: SELECT msi.shelf_life_code
673: INTO l_shelf_life_code
674: FROM mtl_system_items msi
675: WHERE msi.inventory_item_id = p_item_id
676: AND msi.organization_id = p_org_id
677: AND NOT EXISTS -- new lot
678: (SELECT 'X'

Line 993: FROM mtl_system_items msi,

989: )
990: INTO l_lot_number,
991: l_sch_st_date,
992: l_item_rev
993: FROM mtl_system_items msi,
994: wip_discrete_jobs wdj
995: WHERE wdj.wip_entity_id = l_wip_entity_id
996: AND msi.organization_id = wdj.organization_id
997: AND msi.inventory_item_id = wdj.primary_item_id;