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_PLAN_TASKS_PVT dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 69: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;

65: inv_log_util.trace(p_message,p_module,9);
66: END DEBUG;
67:
68: PROCEDURE set_inbound_source_header_line IS
69: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
70: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
71: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
72: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
73:

Line 70: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;

66: END DEBUG;
67:
68: PROCEDURE set_inbound_source_header_line IS
69: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
70: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
71: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
72: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
73:
74: l_source_header source_header_type;

Line 71: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;

67:
68: PROCEDURE set_inbound_source_header_line IS
69: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
70: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
71: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
72: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
73:
74: l_source_header source_header_type;
75: l_line_number line_number_type;

Line 72: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;

68: PROCEDURE set_inbound_source_header_line IS
69: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
70: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
71: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
72: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
73:
74: l_source_header source_header_type;
75: l_line_number line_number_type;
76: l_temp_id temp_id_type;

Line 84: wms_waveplan_tasks_temp wwtt

80: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
81: FROM po_line_locations_all pll,
82: po_headers_all ph,
83: po_lines_all pl,
84: wms_waveplan_tasks_temp wwtt
85: WHERE pll.line_location_id = wwtt.reference_id
86: AND pll.po_line_id = pl.po_line_id
87: AND ph.po_header_id = pl.po_header_id
88: AND wwtt.reference = 'PO_LINE_LOCATION_ID'

Line 94: UPDATE wms_waveplan_tasks_temp wwtt

90: AND wwtt.reference_id IS NOT NULL;
91:
92: IF l_temp_id.COUNT > 0 THEN
93: forall i IN l_temp_id.first..l_temp_id.last
94: UPDATE wms_waveplan_tasks_temp wwtt
95: SET source_header = l_source_header(i),
96: line_number = l_line_number(i)
97: WHERE wwtt.transaction_temp_id = l_temp_id(i)
98: AND wwtt.task_type_id = l_task_type_id(i);

Line 105: wms_waveplan_tasks_temp wwtt

101: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
102: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
103: FROM oe_order_lines_all ool,
104: oe_order_headers_all ooh,
105: wms_waveplan_tasks_temp wwtt
106: WHERE ool.line_id = wwtt.reference_id
107: AND ooh.header_id = ool.header_id
108: AND wwtt.reference = 'ORDER_LINE_ID'
109: AND wwtt.source_header IS NULL

Line 114: UPDATE wms_waveplan_tasks_temp wwtt

110: AND wwtt.reference_id IS NOT NULL;
111:
112: IF l_temp_id.COUNT > 0 THEN
113: forall i IN l_temp_id.first..l_temp_id.last
114: UPDATE wms_waveplan_tasks_temp wwtt
115: SET source_header = l_source_header(i),
116: line_number = l_line_number(i)
117: WHERE wwtt.transaction_temp_id = l_temp_id(i)
118: AND wwtt.task_type_id = l_task_type_id(i);

Line 130: wms_waveplan_tasks_temp wwtt

126: FROM po_requisition_headers_all prh,
127: po_requisition_lines_all prl,
128: rcv_shipment_lines rsl,
129: rcv_shipment_headers rsh,
130: wms_waveplan_tasks_temp wwtt
131: WHERE rsl.shipment_line_id = wwtt.reference_id
132: AND prh.requisition_header_id(+) = prl.requisition_header_id
133: AND rsl.requisition_line_id = prl.requisition_line_id(+)
134: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 141: UPDATE wms_waveplan_tasks_temp wwtt

137: AND wwtt.reference_id IS NOT NULL;
138:
139: IF l_temp_id.COUNT > 0 THEN
140: forall i IN l_temp_id.first..l_temp_id.last
141: UPDATE wms_waveplan_tasks_temp wwtt
142: SET source_header = l_source_header(i),
143: line_number = l_line_number(i)
144: WHERE wwtt.transaction_temp_id = l_temp_id(i)
145: AND wwtt.task_type_id = l_task_type_id(i);

Line 186: FROM wms_waveplan_tasks_temp

182: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
183: FROM
184: wms_op_operation_instances wooi,
185: (SELECT transaction_temp_id
186: FROM wms_waveplan_tasks_temp
187: WHERE status_id = 6
188: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
189: WHERE wooi.source_task_id = wwtt.transaction_temp_id
190: UNION ALL

Line 194: FROM wms_waveplan_tasks_temp

190: UNION ALL
191: SELECT wooih.operation_sequence,wwtt.transaction_temp_id
192: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,
193: (SELECT transaction_temp_id
194: FROM wms_waveplan_tasks_temp
195: WHERE status_id = 6
196: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
197: where wooih.source_task_id = wwtt.transaction_temp_id;
198:

Line 291: l_insert_str := 'INSERT INTO WMS_WAVEPLAN_TASKS_TEMP(' || l_insert_str || ')';

287: in this insert stmt..for fetching plans, the corresponding select stmt
288: will select null values. */
289:
290: get_col_list(l_insert_str);
291: l_insert_str := 'INSERT INTO WMS_WAVEPLAN_TASKS_TEMP(' || l_insert_str || ')';
292: IF l_debug = 1 THEN
293: debug('l_insert_str from get_col_list' || l_insert_str, 'query_inbound');
294: END IF;
295:

Line 872: DELETE FROM wms_waveplan_tasks_temp wwtt

868: --IF wms_plan_tasks_pvt.g_query_independent_tasks AND
869: IF wms_plan_tasks_pvt.g_planned_tasks_rec.is_loaded
870: THEN
871: l_planned_task := wms_plan_tasks_pvt.g_plan_task_types(2);
872: DELETE FROM wms_waveplan_tasks_temp wwtt
873: WHERE EXISTS (
874: SELECT 1
875: FROM wms_op_operation_instances wooi
876: WHERE wwtt.transaction_temp_id = wooi.source_task_id

Line 931: ' from wms_waveplan_tasks_temp where ' ||

927: END IF;
928:
929: l_inline_query := ' (Select distinct parent_line_id, reference_id, ' ||
930: ' reference, source_header, line_number '||
931: ' from wms_waveplan_tasks_temp where ' ||
932: ' task_type_id in (2,8) ' ||
933: ' and operation_plan_id is not null ' ||
934: ' and parent_line_id is not null) wwtt ';
935: /**** Get the non-completed plans query first ****/