APPS.PJM_COMMITMENT_UTILS dependencies on MTL_SYSTEM_ITEMS_B

Line 60: from mtl_system_items_b

56:
57: BEGIN
58:
59: SELECT segment1 into L_Item_Number
60: from mtl_system_items_b
61: where inventory_item_id = X_Item_Id
62: and organization_id = X_Organization_Id;
63:
64: RETURN ( L_Item_Number );

Line 206: from mtl_system_items_b MSI

202: , NULL , NULL
203: , X_pollookup
204: , MSI.PRIMARY_UNIT_OF_MEASURE ) )
205: into L_Uom_Conversion_Rate
206: from mtl_system_items_b MSI
207: where MSI.ORGANIZATION_ID = X_org
208: AND MSI.INVENTORY_ITEM_ID = X_item;
209:
210: ELSIF (X_dest = 'SHOP FLOOR') THEN

Line 239: from mtl_system_items_b MSI

235: IF (X_dest = 'INVENTORY') THEN
236:
237: select primary_unit_of_measure
238: into L_Unit
239: from mtl_system_items_b MSI
240: where MSI.ORGANIZATION_ID = X_org
241: AND MSI.INVENTORY_ITEM_ID = X_item;
242:
243: ELSIF (X_dest = 'SHOP FLOOR') THEN

Line 269: from mtl_system_items_b MSI

265: IF (X_dest = 'INVENTORY') THEN
266:
267: select primary_uom_code
268: into L_Unit
269: from mtl_system_items_b MSI
270: where MSI.ORGANIZATION_ID = X_org
271: AND MSI.INVENTORY_ITEM_ID = X_item;
272:
273: ELSIF (X_dest = 'SHOP FLOOR') THEN

Line 301: from mtl_system_items_b MSI,

297: IF (X_dest = 'INVENTORY') THEN
298:
299: select UOM.UNIT_OF_MEASURE_TL
300: into L_Unit
301: from mtl_system_items_b MSI,
302: mtl_units_of_measure_vl UOM
303: where MSI.ORGANIZATION_ID = X_org
304: AND MSI.INVENTORY_ITEM_ID = X_item
305: AND UOM.UOM_CODE = MSI.PRIMARY_UOM_CODE;