APPS.OE_SERVICES_PROCESS dependencies on MTL_SYSTEM_ITEMS

Line 21: FROM MTL_SYSTEM_ITEMS msi

17: X_Services_Inventory_Item_Id NUMBER) is
18: SELECT DECODE(msi.service_item_flag,'Y', 'SERVICE', 'UNKNOWN' )
19: , TO_CHAR( SERVICES_INVENTORY_ITEM_ID )
20: , DESCRIPTION
21: FROM MTL_SYSTEM_ITEMS msi
22: WHERE msi.ORGANIZATION_ID = X_ORG_ID
23: AND msi.INVENTORY_ITEM_ID = X_SERVICES_INVENTORY_ITEM_ID;
24:
25: begin

Line 39: FROM MTL_SYSTEM_ITEMS

35: /*SELECT TO_CHAR( SERVICES_INVENTORY_ITEM_ID )
36: , DESCRIPTION
37: INTO SERVICES_COMPONENT_CODE
38: , SERVICES_ITEM_DESCRIPTION
39: FROM MTL_SYSTEM_ITEMS
40: WHERE ORGANIZATION_ID = ORGANIZATION_ID
41: AND INVENTORY_ITEM_ID = SERVICES_INVENTORY_ITEM_ID;*/
42:
43: Parameter_Result:=OE_SUCCESS;