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.EAM_WORKORDERS_JSP dependencies on CSI_ITEM_INSTANCES

Line 956: ,p_asset_number IN VARCHAR2 --corresponds to serial number in csi_item_instances

952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER
954: ,x_msg_data OUT NOCOPY VARCHAR2
955: ,p_organization_id IN NUMBER
956: ,p_asset_number IN VARCHAR2 --corresponds to serial number in csi_item_instances
957: ,p_asset_group IN VARCHAR2
958: ,p_work_order_type IN NUMBER -- data
959: ,p_description IN VARCHAR2
960: ,p_activity_type IN NUMBER

Line 1012: , p_instance_number IN VARCHAR2 --corresponds to instance_number in csi_item_instances (for Bug 8667921)

1008: , p_cause_code IN VARCHAR2 DEFAULT NULL
1009: , p_resolution_code IN VARCHAR2 DEFAULT NULL
1010: , p_failure_comments IN VARCHAR2 DEFAULT NULL
1011: , p_failure_code_required IN VARCHAR2 DEFAULT NULL
1012: , p_instance_number IN VARCHAR2 --corresponds to instance_number in csi_item_instances (for Bug 8667921)
1013: ) IS
1014:
1015: l_api_name CONSTANT VARCHAR(30) := 'create_easy_work_order';
1016: l_api_version CONSTANT NUMBER := 1.0;

Line 1235: from csi_item_instances

1231: --if the serial number is not passed to the API (for Bug 8667921)
1232:
1233: IF(p_asset_number is null and p_instance_number is not null) THEN
1234: select serial_number into l_asset_number_wl
1235: from csi_item_instances
1236: where instance_number = p_instance_number;
1237: END IF;
1238:
1239: --Initialize the message count.This will make check_errors to look in the message stack and display all messages.

Line 1293: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp

1289: if(nvl(p_asset_number,l_asset_number_wl) is not null) then
1290: select nvl(cii.active_start_date, sysdate-1),
1291: nvl(cii.active_start_date, sysdate-1),msikfv.eam_item_type
1292: into l_start_date, l_end_date, l_eam_item_type
1293: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp
1294: where cii.inventory_item_id =msikfv.inventory_item_id
1295: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1296: and cii.last_vld_organization_id = mp.organization_id
1297: and mp.maint_organization_id = p_organization_id

Line 1329: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,

1325: if (nvl(p_asset_number,l_asset_number_wl) is not null) then
1326: select cii.inventory_item_id , eomd.ACCOUNTING_CLASS_CODE,
1327: cii.instance_id, msikfv.eam_item_type , eomd.area_id
1328: into l_asset_group_id, l_asset_class, l_maintenance_object_id, l_eam_item_type , l_eam_location_id
1329: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,
1330: mtl_parameters mp, eam_org_maint_defaults eomd
1331: where cii.inventory_item_id =msikfv.inventory_item_id
1332: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1333: and cii.last_vld_organization_id = mp.organization_id