APPS.GMI_RESERVATION_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1328: FROM mtl_system_items

1324: , loct_ctl
1325: FROM ic_item_mst
1326: WHERE delete_mark = 0
1327: AND item_no in (SELECT segment1
1328: FROM mtl_system_items
1329: WHERE organization_id = discrete_org_id
1330: AND inventory_item_id = discrete_item_id);
1331:
1332: BEGIN

Line 3195: , mtl_system_items mtl

3191: Select ic.item_id
3192: , ic.item_um
3193: , ic.item_um2
3194: From ic_item_mst ic
3195: , mtl_system_items mtl
3196: Where mtl.organization_id = p_org_id
3197: and mtl.inventory_item_id = p_inv_Item_id
3198: and mtl.segment1 = ic.item_no;
3199: BEGIN

Line 4241: From mtl_system_items

4237: l_status varchar2(1);
4238:
4239: CURSOR get_asset_flag IS
4240: Select inventory_asset_flag
4241: From mtl_system_items
4242: Where organization_id = v_dest_org_id
4243: and inventory_item_id = v_apps_item_id;
4244:
4245: Cursor get_subinv IS

Line 4567: mtl_system_items msi

4563:
4564: Cursor Get_item_info IS
4565: SELECT iim.item_id, iim.lot_ctl, iim.loct_ctl
4566: FROM ic_item_mst iim,
4567: mtl_system_items msi
4568: WHERE msi.inventory_item_id = p_inventory_item_id
4569: AND msi.organization_id = p_mtl_organization_id
4570: AND msi.segment1 = iim.item_no;
4571:

Line 4663: , mtl_system_items mtl

4659: Select ic.item_id
4660: , ic.lot_ctl
4661: , ic.loct_ctl
4662: From ic_item_mst ic
4663: , mtl_system_items mtl
4664: Where ic.item_no = mtl.segment1
4665: and mtl.inventory_item_id = l_inventory_item_id
4666: and mtl.organization_id = l_organization_id;
4667: