DBA Data[Home] [Help]

APPS.PJM_UNIT_EFF dependencies on MTL_SYSTEM_ITEMS

Line 57: FROM mtl_system_items

53: end if;
54:
55: SELECT serial_number_control_code
56: INTO L_ser_control
57: FROM mtl_system_items
58: WHERE inventory_item_id = X_item_id
59: AND organization_id = X_organization_id;
60:
61: return ( L_ser_control );

Line 209: from mtl_system_items_b

205: Items (eam_item_type = 2 in MSI table) */
206:
207: select nvl(eam_item_type, -2)
208: into l_item
209: from mtl_system_items_b
210: where inventory_item_id =X_ITEM_ID
211: and organization_id = X_organization_id;
212:
213: if l_item = 1 then

Line 219: FROM mtl_system_items

215: else
216: /* end of change for EAM, process all other type of items */
217: SELECT decode(effectivity_control , 2 , 'Y' , 'N')
218: INTO G_Unit_Eff_Item
219: FROM mtl_system_items
220: WHERE inventory_item_id = X_item_id
221: AND organization_id = X_organization_id;
222: end if;
223: end if;