[Home] [Help]
1395: print_debug('oprn_id : ' || x_labor_time_tbl(TASK)
1396: .operation_plan_id,
1397: l_debug);
1398: print_debug('std_oprn_id : ' || x_labor_time_tbl(TASK)
1399: .standard_operation_id,
1400: l_debug);
1401:
1402: suit_copy := 0; -- variable to copy into suited table.
1403: l_complete_task := 1;
1419: .operation_plan_id = -1) or
1420: (plan_type = 'R' and x_labor_setup_tbl(setup).operation_plan_id is null)) THEN
1421: print_debug('resource1',l_debug);
1422: IF ((x_labor_time_tbl(task)
1423: .standard_operation_id = -1 and plan_type = 'A') or
1424: (x_labor_setup_tbl(setup)
1425: .source = 'Not Applicable' and x_labor_time_tbl(TASK)
1426: .standard_operation_id = -1)) THEN
1427: l_std_oprn_id := 'Y';
1422: IF ((x_labor_time_tbl(task)
1423: .standard_operation_id = -1 and plan_type = 'A') or
1424: (x_labor_setup_tbl(setup)
1425: .source = 'Not Applicable' and x_labor_time_tbl(TASK)
1426: .standard_operation_id = -1)) THEN
1427: l_std_oprn_id := 'Y';
1428: print_debug('resource2',l_debug);
1429: ELSE
1430: begin
1431: SELECT 'Y'
1432: INTO l_std_oprn_id
1433: FROM dual
1434: WHERE x_labor_time_tbl(task)
1435: .standard_operation_id IN
1436: (SELECT standard_operation_id
1437: FROM bom_std_op_resources_v
1438: WHERE resource_code = x_labor_setup_tbl(setup)
1439: .resource_name);
1432: INTO l_std_oprn_id
1433: FROM dual
1434: WHERE x_labor_time_tbl(task)
1435: .standard_operation_id IN
1436: (SELECT standard_operation_id
1437: FROM bom_std_op_resources_v
1438: WHERE resource_code = x_labor_setup_tbl(setup)
1439: .resource_name);
1440: print_debug('resource3',l_debug);
1827: l_tbl_start number;
1828:
1829: cursor c_parent_mmtts_zone is
1830: SELECT DISTINCT mmtt1.transaction_temp_id,
1831: mmtt1.standard_operation_id,
1832: mmtt1.parent_line_id,
1833: mmtt1.transaction_quantity,
1834: wz1.zone_name from_zone,
1835: Decode(mmtt1.transfer_to_location,
1860: AND (mmtt2.parent_line_id IS NULL OR
1861: mmtt1.transaction_temp_id = mmtt1.parent_line_id);
1862:
1863: p_parent_line_id number;
1864: p_standard_operation_id number;
1865: p_transaction_qty number;
1866:
1867: cursor c_child_mmtts_zone IS
1868: select distinct transaction_temp_id,
1895: order by dropping_order;
1896:
1897: cursor c_parent_mmtts is
1898: SELECT DISTINCT mmtt1.transaction_temp_id,
1899: mmtt1.standard_operation_id,
1900: mmtt1.parent_line_id,
1901: mmtt1.transaction_quantity,
1902: mmtt1.subinventory_code,
1903: mmtt1.transfer_subinventory,
1966:
1967: for l_parent in c_parent_mmtts loop
1968:
1969: p_parent_line_id := l_parent.parent_line_id;
1970: p_standard_operation_id := l_parent.standard_operation_id;
1971: p_transaction_qty := l_parent.transaction_quantity;
1972:
1973: if p_parent_line_id is not null then
1974:
1997: x_labor_time_tbl(n1).picking_uom := l_child.transaction_uom;
1998: x_labor_time_tbl(n1).demand_qty_picking_uom := l_child.transaction_quantity;
1999: x_labor_time_tbl(n1).operation_plan_id := l_child.operation_plan_id;
2000: x_labor_time_tbl(n1).inventory_item_id := l_child.inventory_item_id;
2001: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2002:
2003: prev_index := n1;
2004:
2005: end if;
2013: x_labor_time_tbl(n1).picking_uom := l_child.transaction_uom;
2014: x_labor_time_tbl(n1).demand_qty_picking_uom := l_child.transaction_quantity;
2015: x_labor_time_tbl(n1).operation_plan_id := l_child.operation_plan_id;
2016: x_labor_time_tbl(n1).inventory_item_id := l_child.inventory_item_id;
2017: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2018:
2019: prev_index := n1;
2020: --p_transaction_qty := p_transaction_qty - l_child.transaction_quantity;
2021:
2036: x_labor_time_tbl(n1).picking_uom := l_parent.transaction_uom;
2037: x_labor_time_tbl(n1).demand_qty_picking_uom := l_parent.transaction_quantity;
2038: x_labor_time_tbl(n1).operation_plan_id := l_parent.operation_plan_id;
2039: x_labor_time_tbl(n1).inventory_item_id := l_parent.inventory_item_id;
2040: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2041:
2042: prev_index := n1;
2043:
2044: end if;
2049:
2050: for l_parent in c_parent_mmtts_zone loop
2051:
2052: p_parent_line_id := l_parent.parent_line_id;
2053: p_standard_operation_id := l_parent.standard_operation_id;
2054: p_transaction_qty := l_parent.transaction_quantity;
2055:
2056: if p_parent_line_id is not null then
2057:
2080: x_labor_time_tbl(n1).picking_uom := l_child.transaction_uom;
2081: x_labor_time_tbl(n1).demand_qty_picking_uom := l_child.transaction_quantity;
2082: x_labor_time_tbl(n1).operation_plan_id := l_child.operation_plan_id;
2083: x_labor_time_tbl(n1).inventory_item_id := l_child.inventory_item_id;
2084: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2085:
2086: prev_index := n1;
2087:
2088: end if;
2096: x_labor_time_tbl(n1).picking_uom := l_child.transaction_uom;
2097: x_labor_time_tbl(n1).demand_qty_picking_uom := l_child.transaction_quantity;
2098: x_labor_time_tbl(n1).operation_plan_id := l_child.operation_plan_id;
2099: x_labor_time_tbl(n1).inventory_item_id := l_child.inventory_item_id;
2100: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2101:
2102: prev_index := n1;
2103: --p_transaction_qty := p_transaction_qty - l_child.transaction_quantity;
2104:
2119: x_labor_time_tbl(n1).picking_uom := l_parent.transaction_uom;
2120: x_labor_time_tbl(n1).demand_qty_picking_uom := l_parent.transaction_quantity;
2121: x_labor_time_tbl(n1).operation_plan_id := l_parent.operation_plan_id;
2122: x_labor_time_tbl(n1).inventory_item_id := l_parent.inventory_item_id;
2123: x_labor_time_tbl(n1).standard_operation_id := p_standard_operation_id;
2124:
2125: prev_index := n1;
2126:
2127: end if;
2151: l_debug);
2152: print_debug('x_labor_time_tbl(i).inventory_item_id ' ||
2153: x_labor_time_tbl(i).inventory_item_id,
2154: l_debug);
2155: print_debug('x_labor_time_tbl(i).standard_operation_id ' ||
2156: x_labor_time_tbl(i).standard_operation_id,
2157: l_debug);
2158:
2159: end loop;
2152: print_debug('x_labor_time_tbl(i).inventory_item_id ' ||
2153: x_labor_time_tbl(i).inventory_item_id,
2154: l_debug);
2155: print_debug('x_labor_time_tbl(i).standard_operation_id ' ||
2156: x_labor_time_tbl(i).standard_operation_id,
2157: l_debug);
2158:
2159: end loop;
2160:
6519:
6520: begin
6521:
6522: WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries(
6523: -- Standard parameters
6524: p_api_version_number => 1.0,
6525: p_init_msg_list => FND_API.G_FALSE,
6526: p_commit => FND_API.G_FALSE,
6527: x_return_status => l_return_status,
7977:
7978: for m4 in l_current_position .. x_labor_time_tbl.LAST loop
7979:
7980: x_labor_time_tbl(m4).inventory_item_id := l_item_id;
7981: x_labor_time_tbl(m4).standard_operation_id := -1;
7982: x_labor_time_tbl(m4).operation_plan_id := -1;
7983:
7984: end loop;
7985:
9030: bom_resource_equipments res_equip,
9031: bom_resources res,
9032: bom_std_op_resources tt_x_res
9033: WHERE mmtt.transaction_temp_id = p_task_id
9034: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id
9035: AND tt_x_res.resource_id = res.resource_id
9036: AND res.resource_type = 1
9037: AND res_equip.resource_id = tt_x_res.resource_id;
9038:
14512: WHERE RESULT = 'X'
14513: AND NOT EXISTS
14514: (SELECT 1
14515: FROM bom_std_op_resources bsor, bom_resource_employees bre
14516: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
14517: AND bsor.resource_id = bre.resource_id
14518: AND bre.person_id = p_employee_id);
14519:
14520: SELECT transaction_temp_id BULK COLLECT
14553: SET person_resource_id = (SELECT bre.resource_id
14554: FROM bom_std_op_resources bsor,
14555: bom_resource_employees bre
14556: WHERE wwtt.user_task_type_id =
14557: bsor.standard_operation_id
14558: AND bsor.resource_id = bre.resource_id
14559: AND bre.person_id = wwtt.person_id
14560: AND ROWNUM < 2)
14561: WHERE RESULT = 'X';
14979: task_priority = l_task_priority_table(i),
14980: last_update_date = SYSDATE,
14981: last_updated_by = p_user_id,
14982: last_update_login = p_login_id,
14983: standard_operation_id = l_user_task_type_id(i)
14984: WHERE transaction_temp_id = l_transaction_temp_id_table(i) -- R12: Update User Task Type Id
14985: AND l_task_type_id(i) <> 3;
14986: if l_debug = 1 then
14987: print_DEBUG('No of records updated are-777 ' || SQL%ROWCOUNT,
18286: (SELECT mil.concatenated_segments --bug12642410
18287: FROM MTL_ITEM_LOCATIONS_kfv mil
18288: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18289: AND mmtt.organization_id = mil.organization_id) to_locator,
18290: mmtt.standard_operation_id user_task_type_id,
18291: bso.operation_code,
18292: wdt.person_id person_id,
18293: wdt.person_id person_id_original,
18294: pap.full_name person,
18385: per_all_people_f pap,
18386: wms_op_operation_instances wooi,
18387: WMS_WP_WAVE_LINES WWL,
18388: wms_dispatched_tasks wdt,
18389: bom_standard_operations bso,
18390: bom_resources br1
18391: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18392: AND wdt.person_id = pap.person_id(+)
18393: AND wdt.effective_start_date >= pap.effective_start_date(+)
18404: AND WWL.delivery_detail_id = WDD.delivery_detail_id
18405: and wwl.organization_id = wdd.organization_id
18406: and wwl.wave_header_id = p_wave_header_id
18407: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
18408: AND mmtt.standard_operation_id = bso.standard_operation_id(+)
18409: AND mmtt.organization_id = bso.organization_id(+)
18410: AND wdt.person_resource_id = br1.resource_id(+)
18411: AND mmtt.parent_line_id is null --12736677 no longer display bulk tasks (parent or child)
18412: union
18435: (SELECT mil.concatenated_segments --bug12642410
18436: FROM MTL_ITEM_LOCATIONS_kfv mil
18437: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18438: AND mmtt.organization_id = mil.organization_id) to_locator,
18439: mmtt.standard_operation_id user_task_type_id,
18440: bso.operation_code,
18441: wdt.person_id person_id,
18442: wdt.person_id person_id_original,
18443: pap.full_name person,
18517: per_all_people_f pap,
18518: wms_op_operation_instances wooi,
18519: WMS_WP_WAVE_LINES WWL,
18520: wms_dispatched_tasks wdt,
18521: bom_standard_operations bso,
18522: bom_resources br1
18523: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18524: AND wdt.person_id = pap.person_id(+)
18525: AND wdt.effective_start_date >= pap.effective_start_date(+)
18538: AND WWL.delivery_detail_id = WDD.delivery_detail_id
18539: and wwl.organization_id = wdd.organization_id
18540: and wwl.wave_header_id = p_wave_header_id
18541: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
18542: AND mmtt.standard_operation_id = bso.standard_operation_id(+)
18543: AND mmtt.organization_id = bso.organization_id(+)
18544: AND wdt.person_resource_id = br1.resource_id(+)
18545: union
18546: SELECT DISTINCT WDT.TASK_ID,
18567: (select mil.concatenated_segments --bug12642410
18568: FROM MTL_ITEM_LOCATIONS_kfv mil
18569: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18570: AND mmtt.organization_id = mil.organization_id) to_locator,
18571: mmtt.standard_operation_id user_task_type_id,
18572: bso.operation_code,
18573: wdt.person_id person_id,
18574: wdt.person_id person_id_original,
18575: pap.full_name person,
18665: per_all_people_f pap,
18666: wms_op_operation_instances wooi,
18667: WMS_WP_WAVE_LINES WWL,
18668: wms_dispatched_tasks wdt,
18669: bom_standard_operations bso,
18670: bom_resources br1,
18671: mtl_txn_request_headers mtrh,
18672: mtl_txn_request_lines mtrl,
18673: wms_replenishment_Details wrd
18691: and wwl.wave_header_id = p_wave_header_id
18692: AND wwl.demand_source_header_id=wrd.demand_header_id
18693: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
18694: AND wrd.source_header_id=mtrh.header_id
18695: AND mmtt.standard_operation_id = bso.standard_operation_id(+)
18696: AND mmtt.organization_id = bso.organization_id(+)
18697: AND wdt.person_resource_id = br1.resource_id(+)
18698: union
18699: SELECT DISTINCT wdth.TASK_ID,
18829: per_all_people_f pap,
18830: wms_op_operation_instances wooi,
18831: WMS_WP_WAVE_LINES WWL,
18832: wms_dispatched_tasks_history wdth,
18833: bom_standard_operations bso,
18834: bom_resources br1
18835: where mmt.transaction_set_id = wdth.transaction_id
18836: AND decode(mmt.transfer_transaction_id, null, 0, mmt.transaction_quantity) <= 0
18837: AND nvl(mmt.transaction_batch_id, -1) =
18873: AND WWL.delivery_detail_id = WDD.delivery_detail_id
18874: and wwl.organization_id = wdd.organization_id
18875: and wwl.wave_header_id = p_wave_header_id
18876: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
18877: AND wdth.user_task_type = bso.standard_operation_id(+)
18878: AND wdth.organization_id = bso.organization_id(+)
18879: and mmt.transaction_action_id = 28
18880: AND wdth.person_resource_id = br1.resource_id(+)
18881: union -- For Crossdocked Tasks
18904:
18905: FROM MTL_ITEM_LOCATIONS_kfv mil
18906: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18907: AND mmtt.organization_id = mil.organization_id) to_locator,
18908: mmtt.standard_operation_id user_task_type_id,
18909: bso.operation_code,
18910: wdt.person_id person_id,
18911: wdt.person_id person_id_original,
18912: pap.full_name person,
19003: per_all_people_f pap,
19004: wms_op_operation_instances wooi,
19005: WMS_WP_WAVE_LINES WWL,
19006: wms_dispatched_tasks wdt,
19007: bom_standard_operations bso,
19008: bom_resources br1,
19009: mtl_txn_request_lines mtrl
19010: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
19011: AND wdt.person_id = pap.person_id(+)
19024: and wwl.organization_id = wdd.organization_id
19025: and wwl.wave_header_id = p_wave_header_id
19026: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
19027: AND mtrl.BACKORDER_DELIVERY_DETAIL_ID = wdd.delivery_detail_id
19028: AND mmtt.standard_operation_id = bso.standard_operation_id(+)
19029: AND mmtt.organization_id = bso.organization_id(+)
19030: AND wdt.person_resource_id = br1.resource_id(+)
19031: union -- Crossdocked Tasks completed
19032: SELECT DISTINCT wdth.TASK_ID,
19162: per_all_people_f pap,
19163: wms_op_operation_instances wooi,
19164: WMS_WP_WAVE_LINES WWL,
19165: wms_dispatched_tasks_history wdth,
19166: bom_standard_operations bso,
19167: bom_resources br1,
19168: mtl_txn_request_lines mtrl,
19169: mtl_txn_request_headers mtrh
19170: where 1=1
19186: AND WWL.delivery_detail_id = WDD.delivery_detail_id
19187: and wwl.organization_id = wdd.organization_id
19188: and wwl.wave_header_id = p_wave_header_id
19189: and nvl(wwl.remove_from_wave_flag,'N') <> 'Y'
19190: AND wdth.user_task_type = bso.standard_operation_id(+)
19191: AND wdth.organization_id = bso.organization_id(+)
19192: AND wdth.person_resource_id = br1.resource_id(+)
19193: and wdth.task_type IN (2)
19194: and (