APPS.MTH_EVENT_PKG dependencies on MTH_ASSET_MST

Line 413: l_serial_number MTH_ASSET_MST.SERIAL_NUMBER%TYPE;

409: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
410: l_mode VARCHAR2(50) := 'CREATE';
411: l_request_log VARCHAR2(10) := '';
412: l_user_id NUMBER := -1;
413: l_serial_number MTH_ASSET_MST.SERIAL_NUMBER%TYPE;
414: l_organization_id WIP_EAM_WORK_REQUESTS.ORGANIZATION_ID%TYPE;
415: l_asset_number WIP_EAM_WORK_REQUESTS.ASSET_NUMBER%TYPE;
416: l_asset_group WIP_EAM_WORK_REQUESTS.ASSET_GROUP%TYPE;
417: l_action_statuses ActionStatusTableType := ActionStatusTableType();

Line 430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e

426: l_system_pk VARCHAR2(30);
427: CURSOR cur_wr
428: IS
429: SELECT b.serial_number, d.ebs_organization_id, c.ASSET_NUMBER, c.ASSET_GROUP_ID
430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e
431:
432: WHERE a.event_id = p_event_id
433: AND a.equipment_fk_key = b.equipment_pk_key
434: AND d.ORGANIZATION_CODE = c.maintenance_org_code