[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 */
883: not populated if the work order is in draft status */
884: CURSOR c_network_assets (p_wip_entity_id NUMBER) IS
885: select cii.instance_id,cii.inventory_item_id,cii.serial_number
886: from csi_item_instances cii,
887: eam_work_order_route ewor
888: where ewor.wip_entity_id=p_wip_entity_id
889: and cii.instance_id=ewor.instance_id
890: union
891: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
1197: fnd_file.put_line(fnd_file.log,'txn date: ' || p_txn_date);
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(*)
1203: Project - R12) */
1204:
1205: select count(*)
1206: into l_asset_count
1207: from EAM_WORK_ORDER_ROUTE
1208: where wip_entity_id=p_wip_entity_id;
1209:
1210: /* Bug 5315176 - Added the following statement as EWOR table might not
1211: be populated if the Work order is in Draft status */
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
2088:
2089: If l_route_asset = 'Y' then
2090: select count(*)
2091: into l_asset_count
2092: from EAM_WORK_ORDER_ROUTE ewor
2093: where ewor.wip_entity_id = p_entity_id_tab(l_index);
2094:
2095: /* Bug 5315176 - Added the following statement as EWOR table is not
2096: populated for Work Orders in Draft status */
2139: WHERE period_set_name = v_est_rec.period_set_name AND
2140: period_name = v_est_rec.period_name AND
2141: maintenance_object_id in
2142: (select ewor.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,
2175: period_set_name = v_est_rec.period_set_name AND
2176: period_name = v_est_rec.period_name AND
2177: maintenance_object_id in
2178: (select ewor.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,
2213: WHERE period_set_name = v_est_rec.period_set_name AND
2214: period_name = v_est_rec.period_name AND
2215: maintenance_object_id in
2216: (select ewor.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,
2249: period_set_name = v_est_rec.period_set_name AND
2250: period_name = v_est_rec.period_name AND
2251: maintenance_object_id in
2252: (select ewor.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,
7962:
7963: /* Changes required in following cursor as current org can view assets
7964: assigned to itself and to organizations that it maintains.
7965: Also changed to pick member assets information from
7966: EAM_WORK_ORDER_ROUTE table (eAM Requirements Project - R12). */
7967:
7968: CURSOR c_ewor (p_org_id NUMBER,
7969: p_wip_entity_id NUMBER) IS
7970: select cii.inventory_item_id,
7970: select cii.inventory_item_id,
7971: cii.serial_number,
7972: msn.gen_object_id
7973: from csi_item_instances cii,
7974: eam_work_order_route ewor,
7975: mtl_serial_numbers msn,
7976: wip_discrete_jobs wdj
7977: where wdj.organization_id = p_org_id
7978: and ewor.wip_entity_id = p_wip_entity_id
8064: -----------------------------------------------------------------------
8065: -- Get the number of memeber assets in this network/route
8066: -----------------------------------------------------------------------
8067:
8068: /* There will be as many number of rows in EAM_WORK_ORDER_ROUTE table as
8069: there are asset members in the asset route at the time of Work Order
8070: Release. Changing reference to EWOR from MENA. (eAM Requirements
8071: Project - R12) */
8072:
8073: l_stmt_num := 20;
8074:
8075: select count(*)
8076: into l_number_members
8077: from EAM_WORK_ORDER_ROUTE ewor
8078: where ewor.wip_entity_id = c_route_rec.wip_entity_id;
8079:
8080: if (l_number_members > 0) then
8081: