APPS.WSMPLBJT dependencies on MTL_SYSTEM_ITEMS

Line 61: FROM MTL_SYSTEM_ITEMS

57: -- Select the Primary UOM for this item
58:
59: SELECT primary_uom_code
60: INTO X_UOM
61: FROM MTL_SYSTEM_ITEMS
62: WHERE INVENTORY_ITEM_ID = X_Inventory_Item_Id
63: AND ORGANIZATION_ID = X_Organization_Id;
64:
65: -- Select the first operation from the WIP routing.

Line 202: mtl_system_items msi

198:
199: select unique wcv.assembly_item_id
200: into x_assembly_id
201: from wsm_components_v wcv,
202: mtl_system_items msi
203: where wcv.component_item_id = X_component_item_id
204: and wcv.organization_id = X_organization_id
205: and msi.organization_id = X_organization_id
206: and msi.inventory_item_id = wcv.assembly_item_id

Line 231: ** from mtl_system_items

227:
228: -- abedajna 10/11/00
229: /* select inventory_item_id
230: ** into x_temp_id
231: ** from mtl_system_items
232: ** where segment1=X_item_name
233: ** and organization_id = X_organization_id;
234: */
235:

Line 240: from mtl_system_items_kfv

236: -- modification by abedajna 10/11/00
237:
238: select inventory_item_id
239: into x_temp_id
240: from mtl_system_items_kfv
241: where concatenated_segments = X_item_name
242: and organization_id = X_organization_id;
243:
244: return(x_temp_id);