eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_EVENT_PKG dependencies on WIP_EAM_WORK_REQUESTS

Line 414: l_organization_id WIP_EAM_WORK_REQUESTS.ORGANIZATION_ID%TYPE;

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();
418: l_action_status_rec ActionStatusRec;

Line 415: l_asset_number WIP_EAM_WORK_REQUESTS.ASSET_NUMBER%TYPE;

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();
418: l_action_status_rec ActionStatusRec;
419: serial_number_not_found EXCEPTION;

Line 416: l_asset_group WIP_EAM_WORK_REQUESTS.ASSET_GROUP%TYPE;

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();
418: l_action_status_rec ActionStatusRec;
419: serial_number_not_found EXCEPTION;
420: asset_info_not_found EXCEPTION;

Line 471: ' FROM WIP_EAM_WORK_REQUESTS@'||l_dblink||

467: 'BEGIN MTH_SRC_PKG.MTH_INVOKE_EAM_WORK_REQUEST@'||l_dblink||'(:1, :2, :3, :4); END; '
468: USING p_event_id, l_asset_number, l_asset_group, l_organization_id;
469:
470: l_sql := 'SELECT WORK_REQUEST_ID ' ||
471: ' FROM WIP_EAM_WORK_REQUESTS@'||l_dblink||
472: ' WHERE ASSET_NUMBER = :1 ' ||
473: ' AND ASSET_GROUP = :2 ' ||
474: ' AND ORGANIZATION_ID = :3 ' ||
475: ' AND DESCRIPTION = :4 ';