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 205: from mtl_system_items_b MSI

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

Line 233: from mtl_system_items_b MSI

229: IF (X_dest = 'INVENTORY') THEN
230:
231: select primary_unit_of_measure
232: into L_Unit
233: from mtl_system_items_b MSI
234: where MSI.ORGANIZATION_ID = X_org
235: AND MSI.INVENTORY_ITEM_ID = X_item;
236:
237: ELSIF (X_dest = 'SHOP FLOOR') THEN

Line 263: from mtl_system_items_b MSI

259: IF (X_dest = 'INVENTORY') THEN
260:
261: select primary_uom_code
262: into L_Unit
263: from mtl_system_items_b MSI
264: where MSI.ORGANIZATION_ID = X_org
265: AND MSI.INVENTORY_ITEM_ID = X_item;
266:
267: ELSIF (X_dest = 'SHOP FLOOR') THEN

Line 295: from mtl_system_items_b MSI,

291: IF (X_dest = 'INVENTORY') THEN
292:
293: select UOM.UNIT_OF_MEASURE_TL
294: into L_Unit
295: from mtl_system_items_b MSI,
296: mtl_units_of_measure_vl UOM
297: where MSI.ORGANIZATION_ID = X_org
298: AND MSI.INVENTORY_ITEM_ID = X_item
299: AND UOM.UOM_CODE = MSI.PRIMARY_UOM_CODE;