eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_DISPATCHED_TASKS

Line 1949: l_from_generic := l_from_generic || ', wms_dispatched_tasks wdt ';

1945: END IF;
1946:
1947: IF p_is_queued OR p_is_dispatched OR p_is_loaded OR p_is_active
1948: THEN
1949: l_from_generic := l_from_generic || ', wms_dispatched_tasks wdt ';
1950: END IF;
1951: ELSE -- if p_is_completed then
1952: --Patchset J Bulk Picking Enhancement
1953: --Only include mmt if not querying for completed parent tasks

Line 1962: l_from_generic || 'wms_dispatched_tasks_history wdth';

1958: l_from_generic || 'mtl_material_transactions mmt, ';
1959: END IF;
1960:
1961: l_from_generic :=
1962: l_from_generic || 'wms_dispatched_tasks_history wdth';
1963: /*IF g_operation_sequence_visible = 'T' AND wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
1964: l_from_generic :=
1965: l_from_generic || 'wms_op_opertn_instances_hist wooih';
1966: END IF; */

Line 2187: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';

2183: IF p_is_pending
2184: THEN
2185: l_where_generic :=
2186: l_where_generic
2187: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';
2188: l_where_generic :=
2189: l_where_generic
2190: || ' WHERE transaction_temp_id = mmtt.transaction_temp_id) ';
2191: END IF;

Line 7553: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';

7549: IF l_join_wdt
7550: THEN
7551: IF i = 1
7552: THEN
7553: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';
7554: ELSIF i = 2
7555: THEN
7556: l_from_cc :=
7557: l_from_cc || ', wms_dispatched_tasks_history wdt ';

Line 7557: l_from_cc || ', wms_dispatched_tasks_history wdt ';

7553: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';
7554: ELSIF i = 2
7555: THEN
7556: l_from_cc :=
7557: l_from_cc || ', wms_dispatched_tasks_history wdt ';
7558: END IF;
7559: END IF;
7560:
7561: IF p_item_category_id IS NOT NULL OR p_category_set_id IS NOT NULL

Line 7618: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';

7614: IF p_is_pending
7615: THEN
7616: l_where_cc :=
7617: l_where_cc
7618: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';
7619: l_where_cc :=
7620: l_where_cc
7621: || ' WHERE transaction_temp_id = mcce.cycle_count_entry_id) ';
7622: END IF;

Line 10083: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt

10079:
10080: --BUG: 4707588
10081: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status
10082: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10083: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt
10084: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
10085: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
10086: wwtt.RESULT = 'X' AND
10087: wwtt.status_id = 3 AND

Line 10088: EXISTS ( SELECT 1 FROM WMS_DISPATCHED_TASKS wdt2

10084: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
10085: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
10086: wwtt.RESULT = 'X' AND
10087: wwtt.status_id = 3 AND
10088: EXISTS ( SELECT 1 FROM WMS_DISPATCHED_TASKS wdt2
10089: WHERE wdt2.person_id = wwtt.person_id AND
10090: wdt2.status = 9 AND
10091: wdt2.task_method IS NOT NULL AND
10092: wdt2.transaction_temp_id IN( SELECT transaction_temp_id FROM mtl_material_transactions_temp mmtt1

Line 10129: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT

10125: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10126: FROM wms_waveplan_tasks_temp wwtt
10127: WHERE RESULT = 'X' AND
10128: status_id = 9 AND
10129: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
10130: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID AND
10131: MMLH.USER_ID = WDT.LAST_UPDATED_BY AND
10132: MMLH.LOGOFF_DATE IS NULL AND
10133: MMLH.EVENT_MESSAGE IS NULL

Line 10307: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),

10303: -- If changing status to Queued
10304: IF p_to_status_id = 2
10305: THEN
10306: UPDATE wms_waveplan_tasks_temp
10307: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),
10308: status = p_to_status,
10309: status_id = p_to_status_id,
10310: priority =
10311: DECODE (p_clear_priority,

Line 10566: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE

10562:
10563: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE
10564: INDEX BY BINARY_INTEGER;
10565:
10566: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE
10567: INDEX BY BINARY_INTEGER;
10568:
10569: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
10570: INDEX BY BINARY_INTEGER;

Line 10569: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */

10565:
10566: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE
10567: INDEX BY BINARY_INTEGER;
10568:
10569: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
10570: INDEX BY BINARY_INTEGER;
10571:
10572: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
10573: INDEX BY BINARY_INTEGER;

Line 10572: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE

10568:
10569: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
10570: INDEX BY BINARY_INTEGER;
10571:
10572: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
10573: INDEX BY BINARY_INTEGER;
10574:
10575: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
10576: INDEX BY BINARY_INTEGER;

Line 10575: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE

10571:
10572: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
10573: INDEX BY BINARY_INTEGER;
10574:
10575: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
10576: INDEX BY BINARY_INTEGER;
10577:
10578: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
10579: INDEX BY BINARY_INTEGER;

Line 10669: wms_dispatched_tasks wdt

10665: THEN
10666: SELECT mmtt.transaction_temp_id
10667: INTO l_transaction_temp_id_table (i)
10668: FROM mtl_material_transactions_temp mmtt,
10669: wms_dispatched_tasks wdt
10670: WHERE mmtt.transaction_temp_id =
10671: rec_wwtt.transaction_temp_id
10672: AND mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
10673: AND mmtt.wms_task_type = wdt.task_type(+)

Line 10703: wms_dispatched_tasks wdt

10699: ELSE
10700: SELECT mcce.cycle_count_entry_id
10701: INTO l_transaction_temp_id_table (i)
10702: FROM mtl_cycle_count_entries mcce,
10703: wms_dispatched_tasks wdt
10704: WHERE mcce.cycle_count_entry_id =
10705: rec_wwtt.transaction_temp_id
10706: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id(+)
10707: AND 3 = wdt.task_type(+)

Line 10830: DELETE wms_dispatched_tasks wdt

10826: end if;
10827: END IF;
10828:
10829: -- Delete WDT line for tasks that were queued but now are pending or unreleased
10830: DELETE wms_dispatched_tasks wdt
10831: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
10832: AND wdt.transaction_temp_id IN (
10833: SELECT transaction_temp_id
10834: FROM wms_waveplan_tasks_temp wwtt

Line 10847: INSERT INTO wms_dispatched_tasks

10843: DEBUG ('inserting into WDT ' || x_save_count);
10844: end if;
10845:
10846: -- Insert into WDT tasks that have become queued from pending or unreleased
10847: INSERT INTO wms_dispatched_tasks
10848: (task_id, transaction_temp_id, organization_id,
10849: user_task_type, person_id, effective_start_date,
10850: effective_end_date, person_resource_id,
10851: machine_resource_id, status, dispatched_time,

Line 10869: FROM wms_dispatched_tasks wdt

10865: AND wwtt.status_id_original IN (1, 8)
10866: AND wwtt.is_modified = 'Y'
10867: AND NOT EXISTS (
10868: SELECT 1
10869: FROM wms_dispatched_tasks wdt
10870: WHERE wdt.transaction_temp_id =
10871: wwtt.transaction_temp_id));
10872: if l_debug = 1 then
10873: DEBUG ('No of records inserted are-444 ' || SQL%ROWCOUNT);

Line 10877: UPDATE wms_dispatched_tasks

10873: DEBUG ('No of records inserted are-444 ' || SQL%ROWCOUNT);
10874: end if;
10875: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
10876: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
10877: UPDATE wms_dispatched_tasks
10878: SET person_id = l_person_id_table (i),
10879: person_resource_id = l_person_resource_id_table (i),
10880: effective_start_date = l_effective_start_date_table (i),
10881: effective_end_date = l_effective_end_date_table (i),