DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_DISPATCHED_TASKS_S

Line 145: SELECT wms_dispatched_tasks_s.NEXTVAL

141: FROM bom_resource_employees
142: WHERE organization_id=l_org_id
143: AND person_id=l_emp_id;
144: */
145: SELECT wms_dispatched_tasks_s.NEXTVAL
146: INTO l_task_id
147: FROM DUAL;
148:
149: INSERT INTO wms_dispatched_tasks

Line 774: SELECT wms_dispatched_tasks_s.NEXTVAL

770: WHERE transaction_temp_id = task_rec.task_id;
771:
772: -- Insert into WMS_DISPATCHED_TASKS for this user
773:
774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;
777:
778: INSERT INTO wms_dispatched_tasks

Line 1329: SELECT wms_dispatched_tasks_s.NEXTVAL

1325: SET transaction_header_id = l_txn_hdr_id
1326: WHERE transaction_temp_id = task_rec.task_id;
1327:
1328: -- Insert into WMS_DISPATCHED_TASKS for this user
1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:
1333: INSERT INTO wms_dispatched_tasks

Line 7800: SELECT wms_dispatched_tasks_s.NEXTVAL

7796:
7797: -- Insert into tasks table
7798:
7799: --Get value from sequence for next task id
7800: SELECT wms_dispatched_tasks_s.NEXTVAL
7801: INTO l_next_task_id
7802: FROM DUAL;
7803:
7804: IF (l_debug = 1) THEN

Line 9948: SELECT wms_dispatched_tasks_s.NEXTVAL

9944:
9945: l_progress := '400';
9946:
9947: --Get value from sequence for next task id
9948: SELECT wms_dispatched_tasks_s.NEXTVAL
9949: INTO l_next_task_id
9950: FROM DUAL;
9951:
9952: l_progress := '410';

Line 12640: SELECT wms_dispatched_tasks_s.NEXTVAL

12636:
12637: -- Insert into WMS_DISPATCHED_TASKS for this user
12638:
12639: --Get value from sequence for next task id
12640: SELECT wms_dispatched_tasks_s.NEXTVAL
12641: INTO l_next_task_id
12642: FROM DUAL;
12643:
12644: --mydebug('pick_by_label: Before Insert into WMSDT');

Line 12997: SELECT wms_dispatched_tasks_s.NEXTVAL

12993:
12994: -- Insert into WMS_DISPATCHED_TASKS for this user
12995:
12996: --Get value from sequence for next task id
12997: SELECT wms_dispatched_tasks_s.NEXTVAL
12998: INTO l_next_task_id
12999: FROM DUAL;
13000:
13001: --mydebug('manual_pick: Before Insert into WMSDT');

Line 14940: (SELECT wms_dispatched_tasks_s.NEXTVAL

14936: , loaded_time
14937: , operation_plan_id
14938: , move_order_line_id
14939: )
14940: (SELECT wms_dispatched_tasks_s.NEXTVAL
14941: , mmtt.transaction_temp_id
14942: , mmtt.organization_id
14943: , wdt.user_task_type
14944: , wdt.person_id