APPS.WIP_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 732: FROM mtl_system_items msi

728: l_shelf_life_code NUMBER;
729: BEGIN
730: SELECT msi.shelf_life_code
731: INTO l_shelf_life_code
732: FROM mtl_system_items msi
733: WHERE msi.inventory_item_id = p_item_id
734: AND msi.organization_id = p_org_id
735: AND NOT EXISTS -- new lot
736: (SELECT 'X'

Line 1051: FROM mtl_system_items msi,

1047: )
1048: INTO l_lot_number,
1049: l_sch_st_date,
1050: l_item_rev
1051: FROM mtl_system_items msi,
1052: wip_discrete_jobs wdj
1053: WHERE wdj.wip_entity_id = l_wip_entity_id
1054: AND msi.organization_id = wdj.organization_id
1055: AND msi.inventory_item_id = wdj.primary_item_id;