APPS.EGO_ITEM_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 3599: FROM MTL_SYSTEM_ITEMS_VL

3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL
3600: WHERE INVENTORY_ITEM_ID = v_inventory_item_id
3601: AND ORGANIZATION_ID <> v_master_organization_id;
3602: */
3603: /*Added for bug 7660662*/

Line 3609: FROM MTL_SYSTEM_ITEMS_VL msi

3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3610: WHERE msi.INVENTORY_ITEM_ID = v_inventory_item_id
3611: and exists (select 1 from mtl_parameters
3612: where organization_id=msi.organization_id
3613: and master_organization_id=v_master_organization_id);