[Home] [Help]
875: l_maint_obj_id NUMBER;
876: l_maint_obj_type NUMBER;
877:
878: /* Changed the following cursor to pick the member asset information from
879: EAM_WORK_ORDER_ROUTE table instead of MTL_EAM_NETWORK_ASSETS
880: for eAM Requirements Project- R12 */
881:
882: /* Bug 5315176 - Added the union clause below as EWOR table is
883: not populated if the work order is in draft status */
889: and cii.instance_id=ewor.instance_id
890: union
891: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
892: from csi_item_instances cii,
893: mtl_eam_network_assets mena,
894: mtl_parameters mp,
895: csi_item_instances cii2
896: where cii.instance_number = p_asset_number
897: and mena.network_object_id = cii.instance_id
1198:
1199: l_stmt_num := 164;
1200:
1201: /* Pick up the member asset route information from EAM_WORK_ORDER_ROUTE
1202: instead of MTL_EAM_NETWORK_ASSETS (Changes for eaM Requirements
1203: Project - R12) */
1204:
1205: select count(*)
1206: into l_asset_count
1211: be populated if the Work order is in Draft status */
1212: If l_asset_count =0 then
1213: select count(*)
1214: into l_asset_count
1215: from mtl_eam_network_assets mena,
1216: csi_item_instances cii,
1217: mtl_parameters mp
1218: where cii.instance_number = p_asset_number
1219: and mena.network_object_id = cii.instance_id
2063:
2064: -- Check if the work order is for a route asset
2065: -- Delete asset cost from member assets if the above is true
2066:
2067: /* Refer EAM_WORK_ORDER_ROUTE table instead of MTL_EAM_NETWORK_ASSETS
2068: table. (Changes for eAM Requirements Project - R12) */
2069: l_stmt_num := 310;
2070:
2071: /* Bug 5315176 - Added the following check to determine if the asset
2096: populated for Work Orders in Draft status */
2097: If l_asset_count =0 then
2098: select count(*)
2099: into l_asset_count
2100: from mtl_eam_network_assets mena,
2101: csi_item_instances cii,
2102: mtl_parameters mp
2103: where cii.instance_number = l_asset_number
2104: and mena.network_object_id = cii.instance_id
2143: from eam_work_order_route ewor
2144: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2145: union /* Added the union clause for Bug 5315176 */
2146: select mena.maintenance_object_id
2147: from mtl_eam_network_assets mena,
2148: csi_item_instances cii,
2149: mtl_parameters mp
2150: where cii.instance_number = l_asset_number
2151: and mena.network_object_id = cii.instance_id
2179: from eam_work_order_route ewor
2180: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2181: union /* Added the union clause for Bug 5315176 */
2182: select mena.maintenance_object_id
2183: from mtl_eam_network_assets mena,
2184: csi_item_instances cii,
2185: mtl_parameters mp
2186: where cii.instance_number = l_asset_number
2187: and mena.network_object_id = cii.instance_id
2217: from eam_work_order_route ewor
2218: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2219: union /* Added the union clause for Bug 5315176 */
2220: select mena.maintenance_object_id
2221: from mtl_eam_network_assets mena,
2222: csi_item_instances cii,
2223: mtl_parameters mp
2224: where cii.instance_number = l_asset_number
2225: and mena.network_object_id = cii.instance_id
2253: from eam_work_order_route ewor
2254: where ewor.wip_entity_id = p_entity_id_tab(l_index)
2255: union /* Added the union clause for Bug 5315176 */
2256: select mena.maintenance_object_id
2257: from mtl_eam_network_assets mena,
2258: csi_item_instances cii,
2259: mtl_parameters mp
2260: where cii.instance_number = l_asset_number
2261: and mena.network_object_id = cii.instance_id
8383: -- --
8384: -- HISTORY: --
8385: -- 03/29/05 Anjali R Modified for eAM Requirements Project - R12. --
8386: -- changes include reference to CSI_ITEM_INSTANCES--
8387: -- table from MTL_EAM_NETWORK_ASSETS. --
8388: -- 11/26/02 Ray Thng Created --
8389: ----------------------------------------------------------------------------
8390: PROCEDURE get_charge_asset (
8391: p_api_version IN NUMBER,