APPS.GMI_RESERVATION_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1332: FROM mtl_system_items

1328: , loct_ctl
1329: FROM ic_item_mst
1330: WHERE delete_mark = 0
1331: AND item_no in (SELECT segment1
1332: FROM mtl_system_items
1333: WHERE organization_id = discrete_org_id
1334: AND inventory_item_id = discrete_item_id);
1335:
1336: BEGIN

Line 3207: , mtl_system_items mtl

3203: Select ic.item_id
3204: , ic.item_um
3205: , ic.item_um2
3206: From ic_item_mst ic
3207: , mtl_system_items mtl
3208: Where mtl.organization_id = p_org_id
3209: and mtl.inventory_item_id = p_inv_Item_id
3210: and mtl.segment1 = ic.item_no;
3211: BEGIN

Line 4253: From mtl_system_items

4249: l_status varchar2(1);
4250:
4251: CURSOR get_asset_flag IS
4252: Select inventory_asset_flag
4253: From mtl_system_items
4254: Where organization_id = v_dest_org_id
4255: and inventory_item_id = v_apps_item_id;
4256:
4257: Cursor get_subinv IS

Line 4579: mtl_system_items msi

4575:
4576: Cursor Get_item_info IS
4577: SELECT iim.item_id, iim.lot_ctl, iim.loct_ctl
4578: FROM ic_item_mst iim,
4579: mtl_system_items msi
4580: WHERE msi.inventory_item_id = p_inventory_item_id
4581: AND msi.organization_id = p_mtl_organization_id
4582: AND msi.segment1 = iim.item_no;
4583:

Line 4675: , mtl_system_items mtl

4671: Select ic.item_id
4672: , ic.lot_ctl
4673: , ic.loct_ctl
4674: From ic_item_mst ic
4675: , mtl_system_items mtl
4676: Where ic.item_no = mtl.segment1
4677: and mtl.inventory_item_id = l_inventory_item_id
4678: and mtl.organization_id = l_organization_id;
4679: