[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 */
1105: not populated if the work order is in draft status */
1106: CURSOR c_network_assets (p_wip_entity_id NUMBER) IS
1107: select cii.instance_id,cii.inventory_item_id,cii.serial_number
1108: from csi_item_instances cii,
1109: eam_work_order_route ewor
1110: where ewor.wip_entity_id=p_wip_entity_id
1111: and cii.instance_id=ewor.instance_id
1112: union
1113: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
1419: fnd_file.put_line(fnd_file.log,'txn date: ' || p_txn_date);
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(*)
1425: Project - R12) */
1426:
1427: select count(*)
1428: into l_asset_count
1429: from EAM_WORK_ORDER_ROUTE
1430: where wip_entity_id=p_wip_entity_id;
1431:
1432: /* Bug 5315176 - Added the following statement as EWOR table might not
1433: be populated if the Work order is in Draft status */
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
2310:
2311: If l_route_asset = 'Y' then
2312: select count(*)
2313: into l_asset_count
2314: from EAM_WORK_ORDER_ROUTE ewor
2315: where ewor.wip_entity_id = p_entity_id_tab(l_index);
2316:
2317: /* Bug 5315176 - Added the following statement as EWOR table is not
2318: populated for Work Orders in Draft status */
2361: WHERE period_set_name = v_est_rec.period_set_name AND
2362: period_name = v_est_rec.period_name AND
2363: maintenance_object_id in
2364: (select ewor.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,
2397: period_set_name = v_est_rec.period_set_name AND
2398: period_name = v_est_rec.period_name AND
2399: maintenance_object_id in
2400: (select ewor.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,
2435: WHERE period_set_name = v_est_rec.period_set_name AND
2436: period_name = v_est_rec.period_name AND
2437: maintenance_object_id in
2438: (select ewor.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,
2471: period_set_name = v_est_rec.period_set_name AND
2472: period_name = v_est_rec.period_name AND
2473: maintenance_object_id in
2474: (select ewor.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,
8535:
8536: /* Changes required in following cursor as current org can view assets
8537: assigned to itself and to organizations that it maintains.
8538: Also changed to pick member assets information from
8539: EAM_WORK_ORDER_ROUTE table (eAM Requirements Project - R12). */
8540:
8541: CURSOR c_ewor (p_org_id NUMBER,
8542: p_wip_entity_id NUMBER) IS
8543: select cii.inventory_item_id,
8543: select cii.inventory_item_id,
8544: cii.serial_number,
8545: msn.gen_object_id
8546: from csi_item_instances cii,
8547: eam_work_order_route ewor,
8548: mtl_serial_numbers msn,
8549: wip_discrete_jobs wdj
8550: where wdj.organization_id = p_org_id
8551: and ewor.wip_entity_id = p_wip_entity_id
8637: -----------------------------------------------------------------------
8638: -- Get the number of memeber assets in this network/route
8639: -----------------------------------------------------------------------
8640:
8641: /* There will be as many number of rows in EAM_WORK_ORDER_ROUTE table as
8642: there are asset members in the asset route at the time of Work Order
8643: Release. Changing reference to EWOR from MENA. (eAM Requirements
8644: Project - R12) */
8645:
8646: l_stmt_num := 20;
8647:
8648: select count(*)
8649: into l_number_members
8650: from EAM_WORK_ORDER_ROUTE ewor
8651: where ewor.wip_entity_id = c_route_rec.wip_entity_id;
8652:
8653: if (l_number_members > 0) then
8654: