[Home] [Help]
1097: l_maint_obj_id NUMBER;
1098: l_maint_obj_type NUMBER;
1099:
1100: /* Changed the following cursor to pick the member asset information from
1101: EAM_WORK_ORDER_ROUTE table instead of MTL_EAM_NETWORK_ASSETS
1102: for eAM Requirements Project- R12 */
1103:
1104: /* Bug 5315176 - Added the union clause below as EWOR table is
1105: not populated if the work order is in draft status */
1111: and cii.instance_id=ewor.instance_id
1112: union
1113: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
1114: from csi_item_instances cii,
1115: mtl_eam_network_assets mena,
1116: mtl_parameters mp,
1117: csi_item_instances cii2
1118: where cii.instance_number = p_asset_number
1119: and mena.network_object_id = cii.instance_id
1420:
1421: l_stmt_num := 164;
1422:
1423: /* Pick up the member asset route information from EAM_WORK_ORDER_ROUTE
1424: instead of MTL_EAM_NETWORK_ASSETS (Changes for eaM Requirements
1425: Project - R12) */
1426:
1427: select count(*)
1428: into l_asset_count
1433: be populated if the Work order is in Draft status */
1434: If l_asset_count =0 then
1435: select count(*)
1436: into l_asset_count
1437: from mtl_eam_network_assets mena,
1438: csi_item_instances cii,
1439: mtl_parameters mp
1440: where cii.instance_number = p_asset_number
1441: and mena.network_object_id = cii.instance_id
2285:
2286: -- Check if the work order is for a route asset
2287: -- Delete asset cost from member assets if the above is true
2288:
2289: /* Refer EAM_WORK_ORDER_ROUTE table instead of MTL_EAM_NETWORK_ASSETS
2290: table. (Changes for eAM Requirements Project - R12) */
2291: l_stmt_num := 310;
2292:
2293: /* Bug 5315176 - Added the following check to determine if the asset
2318: populated for Work Orders in Draft status */
2319: If l_asset_count =0 then
2320: select count(*)
2321: into l_asset_count
2322: from mtl_eam_network_assets mena,
2323: csi_item_instances cii,
2324: mtl_parameters mp
2325: where cii.instance_number = l_asset_number
2326: and mena.network_object_id = cii.instance_id
2365: from eam_work_order_route ewor
2366: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2367: union /* Added the union clause for Bug 5315176 */
2368: select mena.maintenance_object_id
2369: from mtl_eam_network_assets mena,
2370: csi_item_instances cii,
2371: mtl_parameters mp
2372: where cii.instance_number = l_asset_number
2373: and mena.network_object_id = cii.instance_id
2401: from eam_work_order_route ewor
2402: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2403: union /* Added the union clause for Bug 5315176 */
2404: select mena.maintenance_object_id
2405: from mtl_eam_network_assets mena,
2406: csi_item_instances cii,
2407: mtl_parameters mp
2408: where cii.instance_number = l_asset_number
2409: and mena.network_object_id = cii.instance_id
2439: from eam_work_order_route ewor
2440: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2441: union /* Added the union clause for Bug 5315176 */
2442: select mena.maintenance_object_id
2443: from mtl_eam_network_assets mena,
2444: csi_item_instances cii,
2445: mtl_parameters mp
2446: where cii.instance_number = l_asset_number
2447: and mena.network_object_id = cii.instance_id
2475: from eam_work_order_route ewor
2476: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2477: union /* Added the union clause for Bug 5315176 */
2478: select mena.maintenance_object_id
2479: from mtl_eam_network_assets mena,
2480: csi_item_instances cii,
2481: mtl_parameters mp
2482: where cii.instance_number = l_asset_number
2483: and mena.network_object_id = cii.instance_id
8956: -- --
8957: -- HISTORY: --
8958: -- 03/29/05 Anjali R Modified for eAM Requirements Project - R12. --
8959: -- changes include reference to CSI_ITEM_INSTANCES--
8960: -- table from MTL_EAM_NETWORK_ASSETS. --
8961: -- 11/26/02 Ray Thng Created --
8962: ----------------------------------------------------------------------------
8963: PROCEDURE get_charge_asset (
8964: p_api_version IN NUMBER,