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 12892: SELECT wms_dispatched_tasks_s.NEXTVAL

12888:
12889: -- Insert into WMS_DISPATCHED_TASKS for this user
12890:
12891: --Get value from sequence for next task id
12892: SELECT wms_dispatched_tasks_s.NEXTVAL
12893: INTO l_next_task_id
12894: FROM DUAL;
12895:
12896: --mydebug('pick_by_label: Before Insert into WMSDT');

Line 13249: SELECT wms_dispatched_tasks_s.NEXTVAL

13245:
13246: -- Insert into WMS_DISPATCHED_TASKS for this user
13247:
13248: --Get value from sequence for next task id
13249: SELECT wms_dispatched_tasks_s.NEXTVAL
13250: INTO l_next_task_id
13251: FROM DUAL;
13252:
13253: --mydebug('manual_pick: Before Insert into WMSDT');

Line 15340: (SELECT wms_dispatched_tasks_s.NEXTVAL

15336: , loaded_time
15337: , operation_plan_id
15338: , move_order_line_id
15339: )
15340: (SELECT wms_dispatched_tasks_s.NEXTVAL
15341: , mmtt.transaction_temp_id
15342: , mmtt.organization_id
15343: , wdt.user_task_type
15344: , wdt.person_id