[Home] [Help]
390: wdtv.transaction_action_id,
391: wdtv.transaction_source_id,
392: wdtv.transaction_source_type_id
393: FROM
394: -- inlined wms_dispatchable_tasks_v, bug 2648133
395: (SELECT
396: transaction_temp_id task_id,
397: standard_operation_id user_task_type_id,
398: wms_task_type wms_task_type_id,
776: wdtv.transaction_action_id,
777: wdtv.transaction_source_id,
778: wdtv.transaction_source_type_id
779: FROM
780: -- inlined wms_dispatchable_tasks_v, bug 2648133
781: (SELECT
782: transaction_temp_id task_id,
783: standard_operation_id user_task_type_id,
784: wms_task_type wms_task_type_id,
1033: wdtv.transaction_action_id,
1034: wdtv.transaction_source_id,
1035: wdtv.transaction_source_type_id
1036: FROM
1037: -- inlined wms_dispatchable_tasks_v, bug 2648133
1038: (SELECT
1039: MIN(mcce.cycle_count_entry_id) task_id,
1040: MIN(mcce.standard_operation_id) user_task_type_id,
1041: 3 wms_task_type_id,
1297: wdtv.transaction_action_id,
1298: wdtv.transaction_source_id,
1299: wdtv.transaction_source_type_id
1300: FROM
1301: -- inlined wms_dispatchable_tasks_v, bug 2648133
1302: (SELECT
1303: transaction_temp_id task_id,
1304: standard_operation_id user_task_type_id,
1305: wms_task_type wms_task_type_id,
1681: wdtv.transaction_action_id,
1682: wdtv.transaction_source_id,
1683: wdtv.transaction_source_type_id
1684: FROM
1685: -- inlined wms_dispatchable_tasks_v, bug 2648133
1686: (SELECT
1687: transaction_temp_id task_id,
1688: standard_operation_id user_task_type_id,
1689: wms_task_type wms_task_type_id,
1929: wdtv.transaction_action_id,
1930: wdtv.transaction_source_id,
1931: wdtv.transaction_source_type_id
1932: FROM
1933: -- inlined wms_dispatchable_tasks_v, bug 2648133
1934: (SELECT
1935: MIN(mcce.cycle_count_entry_id) task_id,
1936: MIN(mcce.standard_operation_id) user_task_type_id,
1937: 3 wms_task_type_id,
2251: wdtv.transaction_action_id,
2252: wdtv.transaction_source_id,
2253: wdtv.transaction_source_type_id
2254: FROM
2255: -- inlined wms_dispatchable_tasks_v, bug 2648133
2256: (SELECT
2257: transaction_temp_id task_id,
2258: standard_operation_id user_task_type_id,
2259: wms_task_type wms_task_type_id,
2709: wdtv.transaction_action_id,
2710: wdtv.transaction_source_id,
2711: wdtv.transaction_source_type_id
2712: FROM
2713: -- inlined wms_dispatchable_tasks_v, bug 2648133
2714: (SELECT
2715: transaction_temp_id task_id,
2716: standard_operation_id user_task_type_id,
2717: wms_task_type wms_task_type_id,
2991: wdtv.transaction_action_id,
2992: wdtv.transaction_source_id,
2993: wdtv.transaction_source_type_id
2994: FROM
2995: -- inlined wms_dispatchable_tasks_v, bug 2648133
2996: (SELECT
2997: MIN(mcce.cycle_count_entry_id) task_id,
2998: MIN(mcce.standard_operation_id) user_task_type_id,
2999: 3 wms_task_type_id,
3358: -- select locator coordinates of the the last task
3359: IF l_last_task_id <> -1 THEN -- make sure there is a last task
3360:
3361: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
3362: -- get the location from wms_dispatchable_tasks_v
3363: BEGIN
3364: l_progress := '35';
3365:
3366: -- use Nvl to make sure if coordinates not defined, use 0
3409: WHERE entry_status_code IN(1, 3)
3410: AND NVL(export_flag, 2) = 2
3411: -- bug 3972076
3412: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
3413: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision) wdtv -- inlined wms_dispatchable_tasks_v, bug 2648133
3414: WHERE wdtv.locator_id = loc.inventory_location_id
3415: AND wdtv.organization_id = loc.organization_id
3416: AND wdtv.task_id = l_last_task_id
3417: AND wdtv.wms_task_type_id = l_last_task_type;
4467: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4468: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4469: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4470: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4471: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4472: (SELECT utt_emp.standard_operation_id standard_operation_id
4473: , utt_emp.resource_id ROLE
4474: , utt_eqp.resource_id equipment
4475: , utt_emp.person_id emp_id
4621: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4622: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4623: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4624: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4625: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4626: (SELECT utt_emp.standard_operation_id standard_operation_id
4627: , utt_emp.resource_id ROLE
4628: , utt_eqp.resource_id equipment
4629: , utt_emp.person_id emp_id
4777: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4778: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4779: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4780: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4781: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4782: (SELECT utt_emp.standard_operation_id standard_operation_id
4783: , utt_emp.resource_id ROLE
4784: , utt_eqp.resource_id equipment
4785: , utt_emp.person_id emp_id
4930: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
4931: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
4932: AND NVL(mcch.disable_date,sysdate+1)> sysdate
4933: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
4934: , -- inlined wms_dispatchable_tasks_v, bug 2648133
4935: (SELECT utt_emp.standard_operation_id standard_operation_id
4936: , utt_emp.resource_id ROLE
4937: , utt_eqp.resource_id equipment
4938: , utt_emp.person_id emp_id
5083: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5084: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5085: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5086: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5087: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5088: (SELECT utt_emp.standard_operation_id standard_operation_id
5089: , utt_emp.resource_id ROLE
5090: , utt_eqp.resource_id equipment
5091: , utt_emp.person_id emp_id
5237: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5238: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5239: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5240: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5241: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5242: (SELECT utt_emp.standard_operation_id standard_operation_id
5243: , utt_emp.resource_id ROLE
5244: , utt_eqp.resource_id equipment
5245: , utt_emp.person_id emp_id
5390: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5391: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5392: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5393: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5394: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5395: (SELECT utt_emp.standard_operation_id standard_operation_id
5396: , utt_emp.resource_id ROLE
5397: , utt_eqp.resource_id equipment
5398: , utt_emp.person_id emp_id
5541: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5542: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5543: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5544: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5545: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5546: (SELECT utt_emp.standard_operation_id standard_operation_id
5547: , utt_emp.resource_id ROLE
5548: , utt_eqp.resource_id equipment
5549: , utt_emp.person_id emp_id
5689: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5690: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5691: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5692: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5693: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5694: (SELECT utt_emp.standard_operation_id standard_operation_id
5695: , utt_emp.resource_id ROLE
5696: , utt_eqp.resource_id equipment
5697: , utt_emp.person_id emp_id
5840: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5841: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
5842: AND NVL(mcch.disable_date,sysdate+1)> sysdate
5843: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5844: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5845: (SELECT utt_emp.standard_operation_id standard_operation_id
5846: , utt_emp.resource_id ROLE
5847: , utt_eqp.resource_id equipment
5848: , utt_emp.person_id emp_id
5991: AND NVL(mcce.export_flag, 2) = 2
5992: -- bug 3972076
5993: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
5994: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
5995: , -- inlined wms_dispatchable_tasks_v, bug 2648133
5996: (SELECT utt_emp.standard_operation_id standard_operation_id
5997: , utt_emp.resource_id ROLE
5998: , utt_eqp.resource_id equipment
5999: , utt_emp.person_id emp_id
6141: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6142: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
6143: AND NVL(mcch.disable_date,sysdate+1)> sysdate
6144: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) wdtv
6145: , -- inlined wms_dispatchable_tasks_v, bug 2648133
6146: (SELECT utt_emp.standard_operation_id standard_operation_id
6147: , utt_emp.resource_id ROLE
6148: , utt_eqp.resource_id equipment
6149: , utt_emp.person_id emp_id
6308: l_sql_stmt :=
6309: 'SELECT wdtv.task_id, wdtv.zone, wdtv.locator_id,
6310: wdtv.revision, wdtv.transaction_uom,
6311: wdtv.transaction_quantity, wdtv.lot_number, wdtv.wms_task_type_id,wdtv.task_priority
6312: FROM wms_dispatchable_tasks_v wdtv
6313: WHERE
6314: wdtv.organization_id = ' || p_sign_on_org_id ||'
6315: AND Nvl(wdtv.zone, ''@@@'') = Nvl('''|| p_sign_on_zone || ''', Nvl(wdtv.zone, ''@@@''))
6316: AND wdtv.user_task_type_id IN
6437: -- select locator coordinates of the the last task
6438: IF l_last_task_id <> -1 -- make sure there is a last task
6439: THEN
6440: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
6441: -- get the location from wms_dispatchable_tasks_v
6442: BEGIN
6443: l_progress := '35';
6444:
6445: -- use Nvl to make sure if coordinates not defined, use 0
6490: WHERE entry_status_code IN(1, 3)
6491: AND NVL(export_flag, 2) = 2
6492: -- bug 3972076
6493: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
6494: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision) wdtv -- inlined wms_dispatchable_tasks_v, bug 2648133
6495: WHERE wdtv.locator_id = loc.inventory_location_id
6496: AND wdtv.organization_id = loc.organization_id
6497: AND wdtv.task_id = l_last_task_id
6498: AND wdtv.wms_task_type_id = l_last_task_type;
7065: RAISE fnd_api.g_exc_error;
7066: END IF;
7067:
7068: l_progress := '90';
7069: -- bug 2648133, inlined wms_dispatchable_tasks_v
7070: -- removed l_sql_stmt
7071:
7072: l_progress := '100';
7073: END IF; -- end task type check if
7320: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7321: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7322: ) xyz_distance
7323: , loc.concatenated_segments loc_concat_segs
7324: FROM --wms_dispatchable_tasks_v wdtv,
7325: (SELECT transaction_temp_id task_id
7326: , standard_operation_id user_task_type_id
7327: , wms_task_type wms_task_type_id
7328: , organization_id organization_id
7370: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7371: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7372: */
7373: ) wdtv
7374: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7375: --wms_person_resource_utt_v v,
7376: (SELECT utt_emp.standard_operation_id standard_operation_id
7377: , utt_emp.resource_id ROLE
7378: , utt_eqp.resource_id equipment
7481: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7482: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7483: ) xyz_distance
7484: , loc.concatenated_segments loc_concat_segs
7485: FROM --wms_dispatchable_tasks_v wdtv,
7486: (SELECT transaction_temp_id task_id
7487: , standard_operation_id user_task_type_id
7488: , wms_task_type wms_task_type_id
7489: , organization_id organization_id
7531: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7532: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7533: */
7534: ) wdtv
7535: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7536: --wms_person_resource_utt_v v,
7537: (SELECT utt_emp.standard_operation_id standard_operation_id
7538: , utt_emp.resource_id ROLE
7539: , utt_eqp.resource_id equipment
7641: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7642: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7643: ) xyz_distance
7644: , loc.concatenated_segments loc_concat_segs
7645: FROM --wms_dispatchable_tasks_v wdtv,
7646: (SELECT transaction_temp_id task_id
7647: , standard_operation_id user_task_type_id
7648: , wms_task_type wms_task_type_id
7649: , organization_id organization_id
7691: -- AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7692: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7693: */
7694: ) wdtv
7695: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7696: --wms_person_resource_utt_v v,
7697: (SELECT utt_emp.standard_operation_id standard_operation_id
7698: , utt_emp.resource_id ROLE
7699: , utt_eqp.resource_id equipment
7801: + (nvl(loc.y_coordinate, 0) - l_cur_y) *(nvl(loc.y_coordinate, 0) - l_cur_y)
7802: + (nvl(loc.z_coordinate, 0) - l_cur_z) *(nvl(loc.z_coordinate, 0) - l_cur_z)
7803: ) xyz_distance
7804: , loc.concatenated_segments loc_concat_segs
7805: FROM --wms_dispatchable_tasks_v wdtv,
7806: (SELECT transaction_temp_id task_id
7807: , standard_operation_id user_task_type_id
7808: , wms_task_type wms_task_type_id
7809: , organization_id organization_id
7851: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')
7852: GROUP BY cycle_count_header_id, organization_id, subinventory, locator_id, inventory_item_id, revision
7853: */
7854: ) wdtv
7855: , -- inlined wms_dispatchable_tasks_v, bug 2648133
7856: --wms_person_resource_utt_v v,
7857: (SELECT utt_emp.standard_operation_id standard_operation_id
7858: , utt_emp.resource_id ROLE
7859: , utt_eqp.resource_id equipment
8056: ,v.effective_start_date
8057: ,v.effective_end_date
8058: ,v.role person_resource_id
8059: ,v.equipment machine_resource_id
8060: FROM --wms_dispatchable_tasks_v wdtv,
8061: (SELECT transaction_temp_id task_id
8062: , standard_operation_id user_task_type_id
8063: , wms_task_type wms_task_type_id
8064: , organization_id organization_id
8083: wms_task_status IS NULL
8084: OR wms_task_status = 1
8085: ) --Added for task planning WB. bug#2651318
8086: ) wdtv
8087: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8088: --wms_person_resource_utt_v v,
8089: (SELECT utt_emp.standard_operation_id standard_operation_id
8090: , utt_emp.resource_id ROLE
8091: , utt_eqp.resource_id equipment
8290: ,v.effective_start_date
8291: ,v.effective_end_date
8292: ,v.role person_resource_id
8293: ,v.equipment machine_resource_id
8294: FROM --wms_dispatchable_tasks_v wdtv,
8295: (SELECT transaction_temp_id task_id
8296: , standard_operation_id user_task_type_id
8297: , wms_task_type wms_task_type_id
8298: , organization_id organization_id
8315: wms_task_status IS NULL
8316: OR wms_task_status = 1
8317: ) --Added for task planning WB. bug#2651318
8318: ) wdtv
8319: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8320: --wms_person_resource_utt_v v,
8321: (SELECT utt_emp.standard_operation_id standard_operation_id
8322: , utt_emp.resource_id ROLE
8323: , utt_eqp.resource_id equipment
8528: ,v.effective_start_date
8529: ,v.effective_end_date
8530: ,v.role person_resource_id
8531: ,v.equipment machine_resource_id
8532: FROM --wms_dispatchable_tasks_v wdtv,
8533: (SELECT transaction_temp_id task_id
8534: , standard_operation_id user_task_type_id
8535: , wms_task_type wms_task_type_id
8536: , organization_id organization_id
8555: wms_task_status IS NULL
8556: OR wms_task_status = 1
8557: ) --Added for task planning WB. bug#2651318
8558: ) wdtv
8559: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8560: --wms_person_resource_utt_v v,
8561: (SELECT utt_emp.standard_operation_id standard_operation_id
8562: , utt_emp.resource_id ROLE
8563: , utt_eqp.resource_id equipment
8754: ,v.effective_start_date
8755: ,v.effective_end_date
8756: ,v.role person_resource_id
8757: ,v.equipment machine_resource_id
8758: FROM --wms_dispatchable_tasks_v wdtv,
8759: (SELECT transaction_temp_id task_id
8760: , standard_operation_id user_task_type_id
8761: , wms_task_type wms_task_type_id
8762: , organization_id organization_id
8779: wms_task_status IS NULL
8780: OR wms_task_status = 1
8781: ) --Added for task planning WB. bug#2651318
8782: ) wdtv
8783: , -- inlined wms_dispatchable_tasks_v, bug 2648133
8784: --wms_person_resource_utt_v v,
8785: (SELECT utt_emp.standard_operation_id standard_operation_id
8786: , utt_emp.resource_id ROLE
8787: , utt_eqp.resource_id equipment
8990: ,v.effective_start_date
8991: ,v.effective_end_date
8992: ,v.role person_resource_id
8993: ,v.equipment machine_resource_id
8994: FROM --wms_dispatchable_tasks_v wdtv,
8995: (SELECT transaction_temp_id task_id
8996: , standard_operation_id user_task_type_id
8997: , wms_task_type wms_task_type_id
8998: , organization_id organization_id
9017: wms_task_status IS NULL
9018: OR wms_task_status = 1
9019: ) --Added for task planning WB. bug#2651318
9020: ) wdtv
9021: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9022: --wms_person_resource_utt_v v,
9023: (SELECT utt_emp.standard_operation_id standard_operation_id
9024: , utt_emp.resource_id ROLE
9025: , utt_eqp.resource_id equipment
9222: ,v.effective_start_date
9223: ,v.effective_end_date
9224: ,v.role person_resource_id
9225: ,v.equipment machine_resource_id
9226: FROM --wms_dispatchable_tasks_v wdtv,
9227: (SELECT transaction_temp_id task_id
9228: , standard_operation_id user_task_type_id
9229: , wms_task_type wms_task_type_id
9230: , organization_id organization_id
9247: wms_task_status IS NULL
9248: OR wms_task_status = 1
9249: ) --Added for task planning WB. bug#2651318
9250: ) wdtv
9251: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9252: --wms_person_resource_utt_v v,
9253: (SELECT utt_emp.standard_operation_id standard_operation_id
9254: , utt_emp.resource_id ROLE
9255: , utt_eqp.resource_id equipment
9454: ,v.effective_start_date
9455: ,v.effective_end_date
9456: ,v.role person_resource_id
9457: ,v.equipment machine_resource_id
9458: FROM --wms_dispatchable_tasks_v wdtv,
9459: (SELECT transaction_temp_id task_id
9460: , standard_operation_id user_task_type_id
9461: , wms_task_type wms_task_type_id
9462: , organization_id organization_id
9481: wms_task_status IS NULL
9482: OR wms_task_status = 1
9483: ) --Added for task planning WB. bug#2651318
9484: ) wdtv
9485: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9486: --wms_person_resource_utt_v v,
9487: (SELECT utt_emp.standard_operation_id standard_operation_id
9488: , utt_emp.resource_id ROLE
9489: , utt_eqp.resource_id equipment
9678: ,v.effective_start_date
9679: ,v.effective_end_date
9680: ,v.role person_resource_id
9681: ,v.equipment machine_resource_id
9682: FROM --wms_dispatchable_tasks_v wdtv,
9683: (SELECT transaction_temp_id task_id
9684: , standard_operation_id user_task_type_id
9685: , wms_task_type wms_task_type_id
9686: , organization_id organization_id
9703: wms_task_status IS NULL
9704: OR wms_task_status = 1
9705: ) --Added for task planning WB. bug#2651318
9706: ) wdtv
9707: , -- inlined wms_dispatchable_tasks_v, bug 2648133
9708: --wms_person_resource_utt_v v,
9709: (SELECT utt_emp.standard_operation_id standard_operation_id
9710: , utt_emp.resource_id ROLE
9711: , utt_eqp.resource_id equipment
9867: l_sql_stmt :=
9868: 'SELECT wdtv.task_id, wdtv.zone, wdtv.locator_id,
9869: wdtv.revision, wdtv.transaction_uom,
9870: wdtv.transaction_quantity, wdtv.lot_number, wdtv.wms_task_type_id,nvl(wdtv.task_priority, 0)
9871: FROM wms_dispatchable_tasks_v wdtv
9872: WHERE wdtv.organization_id = ' || p_sign_on_org_id ||'
9873: AND Nvl(wdtv.zone, ''@@@'') = Nvl('''|| p_sign_on_zone || ''', Nvl(wdtv.zone, ''@@@''))
9874: AND wdtv.user_task_type_id IN
9875: (
9993:
9994: -- select locator coordinates of the the last task
9995: IF l_last_task_id <> -1 THEN -- make sure there is a last task
9996: IF l_last_task_is_drop <> TRUE THEN -- task that has not been completed
9997: -- get the location from wms_dispatchable_tasks_v
9998: BEGIN
9999: l_progress := '35';
10000:
10001: -- use Nvl to make sure if coordinates not defined, use 0
10004: , NVL(loc.z_coordinate, 0)
10005: INTO l_cur_x
10006: , l_cur_y
10007: , l_cur_z
10008: FROM mtl_item_locations loc, wms_dispatchable_tasks_v wdtv
10009: WHERE wdtv.locator_id = loc.inventory_location_id
10010: AND wdtv.organization_id = loc.organization_id
10011: AND wdtv.task_id = l_last_task_id
10012: AND wdtv.wms_task_type_id = l_last_task_type;