DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 237: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Non-serialized Asset-Retrieving info from mtl_system_items_b: l_serial_number:'||l_serial_number);

233: --changed for the 14101354
234: --for non serialized items
235: ELSIF l_maintenance_object_type = 2 THEN
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
237: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Non-serialized Asset-Retrieving info from mtl_system_items_b: l_serial_number:'||l_serial_number);
238: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Asset Group Id:' || l_asset_group_id ||' , Organization Id:' || l_organization_id);
239: END IF;
240:
241: SELECT msib.description

Line 243: FROM mtl_system_items_b msib

239: END IF;
240:
241: SELECT msib.description
242: INTO l_descriptive_text
243: FROM mtl_system_items_b msib
244: WHERE msib.inventory_item_id= l_maintenance_object_id
245: AND msib.organization_id = l_organization_id;
246: END IF;
247: