[Home] [Help]
1246: Decode(plan_type, 'A', -1, 'R', wlp.operation_plan_id) operation_plan_id,
1247: br.resource_type resource_type
1248: FROM wms_wp_labor_planning wlp,
1249: bom_department_resources bdr,
1250: bom_Resources br,
1251: wms_wp_planning_Criteria_vl wpl
1252: WHERE wlp.planning_criteria_id = p_plan_id
1253: AND wpl.planning_criteria_id = p_plan_id
1254: AND br.resource_code = wlp.resource_type
7105: if l_labor_setup_mode = 'S' then
7106: begin
7107: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7108: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7109: from bom_resources br,
7110: mtl_material_transactions_temp mmtt,
7111: wms_dispatched_tasks wdt
7112: where mmtt.subinventory_code =
7113: l_resource_details.source_subinventory
7122: when no_data_found then
7123: l_transaction_quantity := 0;
7124: SELECT resource_type
7125: INTO l_resource_type
7126: FROM bom_resources
7127: WHERE resource_code = p_resource
7128: AND resource_id IN
7129: (SELECT DISTINCT resource_id
7130: FROM BOM_DEPARTMENT_RESOURCES
7136: elsif l_labor_setup_mode = 'Z' then
7137: begin
7138: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7139: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7140: from bom_resources br,
7141: mtl_material_transactions_temp mmtt,
7142: wms_dispatched_tasks wdt,
7143: wms_zone_locators wzl1,
7144: wms_zone_locators wzl2,
7165: when no_data_found then
7166: l_transaction_quantity := 0;
7167: SELECT resource_type
7168: INTO l_resource_type
7169: FROM bom_resources
7170: WHERE resource_code = p_resource
7171: AND resource_id IN
7172: (SELECT DISTINCT resource_id
7173: FROM BOM_DEPARTMENT_RESOURCES
9027: CURSOR c_eqp_capacity(p_task_id NUMBER) IS
9028: SELECT distinct res_equip.inventory_item_id
9029: FROM mtl_material_transactions_temp mmtt,
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
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(+)
18394: AND wdt.effective_end_date <= pap.effective_end_date(+)
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(+)
18526: AND wdt.effective_end_date <= pap.effective_end_date(+)
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
18674: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
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) =
18838: decode(wdth.task_type,
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(+)
19012: AND wdt.effective_start_date >= pap.effective_start_date(+)
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
19171: AND wdth.person_id = pap.person_id(+)