[Home] [Help]
428: wdtv.transaction_action_id,
429: wdtv.transaction_source_id,
430: wdtv.transaction_source_type_id
431: FROM
432: -- inlined wms_dispatchable_tasks_v, bug 2648133
433: (SELECT
434: transaction_temp_id task_id,
435: standard_operation_id user_task_type_id,
436: wms_task_type wms_task_type_id,
814: wdtv.transaction_action_id,
815: wdtv.transaction_source_id,
816: wdtv.transaction_source_type_id
817: FROM
818: -- inlined wms_dispatchable_tasks_v, bug 2648133
819: (SELECT
820: transaction_temp_id task_id,
821: standard_operation_id user_task_type_id,
822: wms_task_type wms_task_type_id,
1071: wdtv.transaction_action_id,
1072: wdtv.transaction_source_id,
1073: wdtv.transaction_source_type_id
1074: FROM
1075: -- inlined wms_dispatchable_tasks_v, bug 2648133
1076: (SELECT
1077: MIN(mcce.cycle_count_entry_id) task_id,
1078: MIN(mcce.standard_operation_id) user_task_type_id,
1079: 3 wms_task_type_id,
1335: wdtv.transaction_action_id,
1336: wdtv.transaction_source_id,
1337: wdtv.transaction_source_type_id
1338: FROM
1339: -- inlined wms_dispatchable_tasks_v, bug 2648133
1340: (SELECT
1341: transaction_temp_id task_id,
1342: standard_operation_id user_task_type_id,
1343: wms_task_type wms_task_type_id,
1719: wdtv.transaction_action_id,
1720: wdtv.transaction_source_id,
1721: wdtv.transaction_source_type_id
1722: FROM
1723: -- inlined wms_dispatchable_tasks_v, bug 2648133
1724: (SELECT
1725: transaction_temp_id task_id,
1726: standard_operation_id user_task_type_id,
1727: wms_task_type wms_task_type_id,
1969: wdtv.transaction_action_id,
1970: wdtv.transaction_source_id,
1971: wdtv.transaction_source_type_id
1972: FROM
1973: -- inlined wms_dispatchable_tasks_v, bug 2648133
1974: (SELECT
1975: MIN(mcce.cycle_count_entry_id) task_id,
1976: MIN(mcce.standard_operation_id) user_task_type_id,
1977: 3 wms_task_type_id,
2310: wdtv.transaction_action_id,
2311: wdtv.transaction_source_id,
2312: wdtv.transaction_source_type_id
2313: FROM
2314: -- inlined wms_dispatchable_tasks_v, bug 2648133
2315: (SELECT
2316: transaction_temp_id task_id,
2317: standard_operation_id user_task_type_id,
2318: wms_task_type wms_task_type_id,
2837: wdtv.transaction_action_id,
2838: wdtv.transaction_source_id,
2839: wdtv.transaction_source_type_id
2840: FROM
2841: -- inlined wms_dispatchable_tasks_v, bug 2648133
2842: (SELECT
2843: transaction_temp_id task_id,
2844: standard_operation_id user_task_type_id,
2845: wms_task_type wms_task_type_id,
3151: wdtv.transaction_action_id,
3152: wdtv.transaction_source_id,
3153: wdtv.transaction_source_type_id
3154: FROM
3155: -- inlined wms_dispatchable_tasks_v, bug 2648133
3156: (SELECT
3157: MIN(mcce.cycle_count_entry_id) task_id,
3158: MIN(mcce.standard_operation_id) user_task_type_id,
3159: 3 wms_task_type_id,
3551: -- select locator coordinates of the the last task
3552: IF l_last_task_id <> -1 THEN -- make sure there is a last task
3553:
3554: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
3555: -- get the location from wms_dispatchable_tasks_v
3556: BEGIN
3557: l_progress := '35';
3558:
3559: -- use Nvl to make sure if coordinates not defined, use 0
3602: WHERE entry_status_code IN(1, 3)
3603: AND NVL(export_flag, 2) = 2
3604: -- bug 3972076
3605: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
3606: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision) wdtv -- inlined wms_dispatchable_tasks_v, bug 2648133
3607: WHERE wdtv.locator_id = loc.inventory_location_id
3608: AND wdtv.organization_id = loc.organization_id
3609: AND wdtv.task_id = l_last_task_id
3610: AND wdtv.wms_task_type_id = l_last_task_type;
4806: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4807: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4808: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4809: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4810: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4811: (SELECT utt_emp.standard_operation_id standard_operation_id
4812: , utt_emp.resource_id ROLE
4813: , utt_eqp.resource_id equipment
4814: , utt_emp.person_id emp_id
4960: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4961: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4962: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4963: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4964: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4965: (SELECT utt_emp.standard_operation_id standard_operation_id
4966: , utt_emp.resource_id ROLE
4967: , utt_eqp.resource_id equipment
4968: , utt_emp.person_id emp_id
5116: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5117: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5118: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5119: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5120: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5121: (SELECT utt_emp.standard_operation_id standard_operation_id
5122: , utt_emp.resource_id ROLE
5123: , utt_eqp.resource_id equipment
5124: , utt_emp.person_id emp_id
5269: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5270: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5271: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5272: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5273: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5274: (SELECT utt_emp.standard_operation_id standard_operation_id
5275: , utt_emp.resource_id ROLE
5276: , utt_eqp.resource_id equipment
5277: , utt_emp.person_id emp_id
5422: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5423: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5424: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5425: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5426: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5427: (SELECT utt_emp.standard_operation_id standard_operation_id
5428: , utt_emp.resource_id ROLE
5429: , utt_eqp.resource_id equipment
5430: , utt_emp.person_id emp_id
5576: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5577: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5578: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5579: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5580: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5581: (SELECT utt_emp.standard_operation_id standard_operation_id
5582: , utt_emp.resource_id ROLE
5583: , utt_eqp.resource_id equipment
5584: , utt_emp.person_id emp_id
5729: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5730: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5731: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5732: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5733: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5734: (SELECT utt_emp.standard_operation_id standard_operation_id
5735: , utt_emp.resource_id ROLE
5736: , utt_eqp.resource_id equipment
5737: , utt_emp.person_id emp_id
5880: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5881: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5882: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5883: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5884: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5885: (SELECT utt_emp.standard_operation_id standard_operation_id
5886: , utt_emp.resource_id ROLE
5887: , utt_eqp.resource_id equipment
5888: , utt_emp.person_id emp_id
6028: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6029: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
6030: AND NVL(mcch.disable_date,sysdate+1)> sysdate
6031: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
6032: , -- inlined wms_dispatchable_tasks_v, bug 2648133
6033: (SELECT utt_emp.standard_operation_id standard_operation_id
6034: , utt_emp.resource_id ROLE
6035: , utt_eqp.resource_id equipment
6036: , utt_emp.person_id emp_id
6179: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6180: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
6181: AND NVL(mcch.disable_date,sysdate+1)> sysdate
6182: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
6183: , -- inlined wms_dispatchable_tasks_v, bug 2648133
6184: (SELECT utt_emp.standard_operation_id standard_operation_id
6185: , utt_emp.resource_id ROLE
6186: , utt_eqp.resource_id equipment
6187: , utt_emp.person_id emp_id
6330: AND NVL(mcce.export_flag, 2) = 2
6331: -- bug 3972076
6332: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6333: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
6334: , -- inlined wms_dispatchable_tasks_v, bug 2648133
6335: (SELECT utt_emp.standard_operation_id standard_operation_id
6336: , utt_emp.resource_id ROLE
6337: , utt_eqp.resource_id equipment
6338: , utt_emp.person_id emp_id
6480: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6481: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
6482: AND NVL(mcch.disable_date,sysdate+1)> sysdate
6483: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
6484: , -- inlined wms_dispatchable_tasks_v, bug 2648133
6485: (SELECT utt_emp.standard_operation_id standard_operation_id
6486: , utt_emp.resource_id ROLE
6487: , utt_eqp.resource_id equipment
6488: , utt_emp.person_id emp_id
6647: l_sql_stmt :=
6648: 'SELECT wdtv.task_id, wdtv.zone, wdtv.locator_id,
6649: wdtv.revision, wdtv.transaction_uom,
6650: wdtv.transaction_quantity, wdtv.lot_number, wdtv.wms_task_type_id,wdtv.task_priority
6651: FROM wms_dispatchable_tasks_v wdtv
6652: WHERE
6653: wdtv.organization_id = ' || p_sign_on_org_id ||'
6654: AND Nvl(wdtv.zone, ''@@@'') = Nvl('''|| p_sign_on_zone || ''', Nvl(wdtv.zone, ''@@@''))
6655: AND wdtv.user_task_type_id IN
6776: -- select locator coordinates of the the last task
6777: IF l_last_task_id <> -1 -- make sure there is a last task
6778: THEN
6779: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
6780: -- get the location from wms_dispatchable_tasks_v
6781: BEGIN
6782: l_progress := '35';
6783:
6784: -- use Nvl to make sure if coordinates not defined, use 0
6829: WHERE entry_status_code IN(1, 3)
6830: AND NVL(export_flag, 2) = 2
6831: -- bug 3972076
6832: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6833: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision) wdtv -- inlined wms_dispatchable_tasks_v, bug 2648133
6834: WHERE wdtv.locator_id = loc.inventory_location_id
6835: AND wdtv.organization_id = loc.organization_id
6836: AND wdtv.task_id = l_last_task_id
6837: AND wdtv.wms_task_type_id = l_last_task_type;
7404: RAISE fnd_api.g_exc_error;
7405: END IF;
7406:
7407: l_progress := '90';
7408: -- bug 2648133, inlined wms_dispatchable_tasks_v
7409: -- removed l_sql_stmt
7410:
7411: l_progress := '100';
7412: END IF; -- end task type check if
7659: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7660: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7661: ) xyz_distance
7662: , loc.concatenated_segments loc_concat_segs
7663: FROM --wms_dispatchable_tasks_v wdtv,
7664: (SELECT transaction_temp_id task_id
7665: , standard_operation_id user_task_type_id
7666: , wms_task_type wms_task_type_id
7667: , organization_id organization_id
7709: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7710: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7711: */
7712: ) wdtv
7713: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7714: --wms_person_resource_utt_v v,
7715: (SELECT utt_emp.standard_operation_id standard_operation_id
7716: , utt_emp.resource_id ROLE
7717: , utt_eqp.resource_id equipment
7820: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7821: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7822: ) xyz_distance
7823: , loc.concatenated_segments loc_concat_segs
7824: FROM --wms_dispatchable_tasks_v wdtv,
7825: (SELECT transaction_temp_id task_id
7826: , standard_operation_id user_task_type_id
7827: , wms_task_type wms_task_type_id
7828: , organization_id organization_id
7870: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7871: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7872: */
7873: ) wdtv
7874: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7875: --wms_person_resource_utt_v v,
7876: (SELECT utt_emp.standard_operation_id standard_operation_id
7877: , utt_emp.resource_id ROLE
7878: , utt_eqp.resource_id equipment
7980: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7981: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7982: ) xyz_distance
7983: , loc.concatenated_segments loc_concat_segs
7984: FROM --wms_dispatchable_tasks_v wdtv,
7985: (SELECT transaction_temp_id task_id
7986: , standard_operation_id user_task_type_id
7987: , wms_task_type wms_task_type_id
7988: , organization_id organization_id
8030: -- AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
8031: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
8032: */
8033: ) wdtv
8034: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8035: --wms_person_resource_utt_v v,
8036: (SELECT utt_emp.standard_operation_id standard_operation_id
8037: , utt_emp.resource_id ROLE
8038: , utt_eqp.resource_id equipment
8140: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
8141: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
8142: ) xyz_distance
8143: , loc.concatenated_segments loc_concat_segs
8144: FROM --wms_dispatchable_tasks_v wdtv,
8145: (SELECT transaction_temp_id task_id
8146: , standard_operation_id user_task_type_id
8147: , wms_task_type wms_task_type_id
8148: , organization_id organization_id
8190: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
8191: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
8192: */
8193: ) wdtv
8194: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8195: --wms_person_resource_utt_v v,
8196: (SELECT utt_emp.standard_operation_id standard_operation_id
8197: , utt_emp.resource_id ROLE
8198: , utt_eqp.resource_id equipment
8395: ,v.effective_start_date
8396: ,v.effective_end_date
8397: ,v.role person_resource_id
8398: ,v.equipment machine_resource_id
8399: FROM --wms_dispatchable_tasks_v wdtv,
8400: (SELECT transaction_temp_id task_id
8401: , standard_operation_id user_task_type_id
8402: , wms_task_type wms_task_type_id
8403: , organization_id organization_id
8422: wms_task_status IS NULL
8423: OR wms_task_status = 1
8424: ) --Added for task planning WB. bug#2651318
8425: ) wdtv
8426: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8427: --wms_person_resource_utt_v v,
8428: (SELECT utt_emp.standard_operation_id standard_operation_id
8429: , utt_emp.resource_id ROLE
8430: , utt_eqp.resource_id equipment
8629: ,v.effective_start_date
8630: ,v.effective_end_date
8631: ,v.role person_resource_id
8632: ,v.equipment machine_resource_id
8633: FROM --wms_dispatchable_tasks_v wdtv,
8634: (SELECT transaction_temp_id task_id
8635: , standard_operation_id user_task_type_id
8636: , wms_task_type wms_task_type_id
8637: , organization_id organization_id
8654: wms_task_status IS NULL
8655: OR wms_task_status = 1
8656: ) --Added for task planning WB. bug#2651318
8657: ) wdtv
8658: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8659: --wms_person_resource_utt_v v,
8660: (SELECT utt_emp.standard_operation_id standard_operation_id
8661: , utt_emp.resource_id ROLE
8662: , utt_eqp.resource_id equipment
8867: ,v.effective_start_date
8868: ,v.effective_end_date
8869: ,v.role person_resource_id
8870: ,v.equipment machine_resource_id
8871: FROM --wms_dispatchable_tasks_v wdtv,
8872: (SELECT transaction_temp_id task_id
8873: , standard_operation_id user_task_type_id
8874: , wms_task_type wms_task_type_id
8875: , organization_id organization_id
8894: wms_task_status IS NULL
8895: OR wms_task_status = 1
8896: ) --Added for task planning WB. bug#2651318
8897: ) wdtv
8898: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8899: --wms_person_resource_utt_v v,
8900: (SELECT utt_emp.standard_operation_id standard_operation_id
8901: , utt_emp.resource_id ROLE
8902: , utt_eqp.resource_id equipment
9093: ,v.effective_start_date
9094: ,v.effective_end_date
9095: ,v.role person_resource_id
9096: ,v.equipment machine_resource_id
9097: FROM --wms_dispatchable_tasks_v wdtv,
9098: (SELECT transaction_temp_id task_id
9099: , standard_operation_id user_task_type_id
9100: , wms_task_type wms_task_type_id
9101: , organization_id organization_id
9118: wms_task_status IS NULL
9119: OR wms_task_status = 1
9120: ) --Added for task planning WB. bug#2651318
9121: ) wdtv
9122: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9123: --wms_person_resource_utt_v v,
9124: (SELECT utt_emp.standard_operation_id standard_operation_id
9125: , utt_emp.resource_id ROLE
9126: , utt_eqp.resource_id equipment
9329: ,v.effective_start_date
9330: ,v.effective_end_date
9331: ,v.role person_resource_id
9332: ,v.equipment machine_resource_id
9333: FROM --wms_dispatchable_tasks_v wdtv,
9334: (SELECT transaction_temp_id task_id
9335: , standard_operation_id user_task_type_id
9336: , wms_task_type wms_task_type_id
9337: , organization_id organization_id
9356: wms_task_status IS NULL
9357: OR wms_task_status = 1
9358: ) --Added for task planning WB. bug#2651318
9359: ) wdtv
9360: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9361: --wms_person_resource_utt_v v,
9362: (SELECT utt_emp.standard_operation_id standard_operation_id
9363: , utt_emp.resource_id ROLE
9364: , utt_eqp.resource_id equipment
9561: ,v.effective_start_date
9562: ,v.effective_end_date
9563: ,v.role person_resource_id
9564: ,v.equipment machine_resource_id
9565: FROM --wms_dispatchable_tasks_v wdtv,
9566: (SELECT transaction_temp_id task_id
9567: , standard_operation_id user_task_type_id
9568: , wms_task_type wms_task_type_id
9569: , organization_id organization_id
9586: wms_task_status IS NULL
9587: OR wms_task_status = 1
9588: ) --Added for task planning WB. bug#2651318
9589: ) wdtv
9590: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9591: --wms_person_resource_utt_v v,
9592: (SELECT utt_emp.standard_operation_id standard_operation_id
9593: , utt_emp.resource_id ROLE
9594: , utt_eqp.resource_id equipment
9793: ,v.effective_start_date
9794: ,v.effective_end_date
9795: ,v.role person_resource_id
9796: ,v.equipment machine_resource_id
9797: FROM --wms_dispatchable_tasks_v wdtv,
9798: (SELECT transaction_temp_id task_id
9799: , standard_operation_id user_task_type_id
9800: , wms_task_type wms_task_type_id
9801: , organization_id organization_id
9820: wms_task_status IS NULL
9821: OR wms_task_status = 1
9822: ) --Added for task planning WB. bug#2651318
9823: ) wdtv
9824: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9825: --wms_person_resource_utt_v v,
9826: (SELECT utt_emp.standard_operation_id standard_operation_id
9827: , utt_emp.resource_id ROLE
9828: , utt_eqp.resource_id equipment
10017: ,v.effective_start_date
10018: ,v.effective_end_date
10019: ,v.role person_resource_id
10020: ,v.equipment machine_resource_id
10021: FROM --wms_dispatchable_tasks_v wdtv,
10022: (SELECT transaction_temp_id task_id
10023: , standard_operation_id user_task_type_id
10024: , wms_task_type wms_task_type_id
10025: , organization_id organization_id
10042: wms_task_status IS NULL
10043: OR wms_task_status = 1
10044: ) --Added for task planning WB. bug#2651318
10045: ) wdtv
10046: , -- inlined wms_dispatchable_tasks_v, bug 2648133
10047: --wms_person_resource_utt_v v,
10048: (SELECT utt_emp.standard_operation_id standard_operation_id
10049: , utt_emp.resource_id ROLE
10050: , utt_eqp.resource_id equipment
10206: l_sql_stmt :=
10207: 'SELECT wdtv.task_id, wdtv.zone, wdtv.locator_id,
10208: wdtv.revision, wdtv.transaction_uom,
10209: wdtv.transaction_quantity, wdtv.lot_number, wdtv.wms_task_type_id,nvl(wdtv.task_priority, 0)
10210: FROM wms_dispatchable_tasks_v wdtv
10211: WHERE wdtv.organization_id = ' || p_sign_on_org_id ||'
10212: AND Nvl(wdtv.zone, ''@@@'') = Nvl('''|| p_sign_on_zone || ''', Nvl(wdtv.zone, ''@@@''))
10213: AND wdtv.user_task_type_id IN
10214: (
10332:
10333: -- select locator coordinates of the the last task
10334: IF l_last_task_id <> -1 THEN -- make sure there is a last task
10335: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
10336: -- get the location from wms_dispatchable_tasks_v
10337: BEGIN
10338: l_progress := '35';
10339:
10340: -- use Nvl to make sure if coordinates not defined, use 0
10343: , NVL(loc.z_coordinate, 0)
10344: INTO l_cur_x
10345: , l_cur_y
10346: , l_cur_z
10347: FROM mtl_item_locations loc, wms_dispatchable_tasks_v wdtv
10348: WHERE wdtv.locator_id = loc.inventory_location_id
10349: AND wdtv.organization_id = loc.organization_id
10350: AND wdtv.task_id = l_last_task_id
10351: AND wdtv.wms_task_type_id = l_last_task_type;