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 86: wms_waveplan_tasks_temp wwtt

82:
83: SELECT we.WIP_ENTITY_NAME , wwtt.transaction_temp_id, wwtt.task_type_id
84: bulk collect INTO l_source_header, l_temp_id, l_task_type_id
85: FROM wip_entities we ,
86: wms_waveplan_tasks_temp wwtt
87: WHERE we.WIP_ENTITY_ID = wwtt.reference_id
88: AND wwtt.reference = 'WIP JOB'
89: AND wwtt.source_header IS NULL
90: AND wwtt.reference_id IS NOT NULL;

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: WHERE wwtt.transaction_temp_id = l_temp_id(i)
97: AND wwtt.task_type_id = l_task_type_id(i);
98: END IF;

Line 108: wms_waveplan_tasks_temp wwtt

104: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
105: FROM po_line_locations_trx_v pll,--CLM Changes, using CLM views instead of base tables
106: po_headers_trx_v ph,
107: po_lines_trx_v pl,
108: wms_waveplan_tasks_temp wwtt
109: WHERE pll.line_location_id = wwtt.reference_id
110: AND pll.po_line_id = pl.po_line_id
111: AND ph.po_header_id = pl.po_header_id
112: AND wwtt.reference = 'PO_LINE_LOCATION_ID'

Line 118: UPDATE wms_waveplan_tasks_temp wwtt

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

Line 129: wms_waveplan_tasks_temp wwtt

125: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
126: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
127: FROM oe_order_lines_all ool,
128: oe_order_headers_all ooh,
129: wms_waveplan_tasks_temp wwtt
130: WHERE ool.line_id = wwtt.reference_id
131: AND ooh.header_id = ool.header_id
132: AND wwtt.reference = 'ORDER_LINE_ID'
133: AND wwtt.source_header IS NULL

Line 138: UPDATE wms_waveplan_tasks_temp wwtt

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

Line 154: wms_waveplan_tasks_temp wwtt

150: FROM po_requisition_headers_all prh,
151: po_requisition_lines_all prl,
152: rcv_shipment_lines rsl,
153: rcv_shipment_headers rsh,
154: wms_waveplan_tasks_temp wwtt
155: WHERE rsl.shipment_line_id = wwtt.reference_id
156: AND prh.requisition_header_id(+) = prl.requisition_header_id
157: AND rsl.requisition_line_id = prl.requisition_line_id(+)
158: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 165: UPDATE wms_waveplan_tasks_temp wwtt

161: AND wwtt.reference_id IS NOT NULL;
162:
163: IF l_temp_id.COUNT > 0 THEN
164: forall i IN l_temp_id.first..l_temp_id.last
165: UPDATE wms_waveplan_tasks_temp wwtt
166: SET source_header = l_source_header(i),
167: line_number = l_line_number(i)
168: WHERE wwtt.transaction_temp_id = l_temp_id(i)
169: AND wwtt.task_type_id = l_task_type_id(i);

Line 210: FROM wms_waveplan_tasks_temp

206: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
207: FROM
208: wms_op_operation_instances wooi,
209: (SELECT transaction_temp_id
210: FROM wms_waveplan_tasks_temp
211: WHERE status_id = 6
212: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
213: WHERE wooi.source_task_id = wwtt.transaction_temp_id
214: UNION ALL

Line 218: FROM wms_waveplan_tasks_temp

214: UNION ALL
215: SELECT wooih.operation_sequence,wwtt.transaction_temp_id
216: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,
217: (SELECT transaction_temp_id
218: FROM wms_waveplan_tasks_temp
219: WHERE status_id = 6
220: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
221: where wooih.source_task_id = wwtt.transaction_temp_id;
222:

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

311: in this insert stmt..for fetching plans, the corresponding select stmt
312: will select null values. */
313:
314: get_col_list(l_insert_str);
315: l_insert_str := 'INSERT INTO WMS_WAVEPLAN_TASKS_TEMP(' || l_insert_str || ')';
316: IF l_debug = 1 THEN
317: debug('l_insert_str from get_col_list' || l_insert_str, 'query_inbound');
318: END IF;
319:

Line 896: DELETE FROM wms_waveplan_tasks_temp wwtt

892: --IF wms_plan_tasks_pvt.g_query_independent_tasks AND
893: IF wms_plan_tasks_pvt.g_planned_tasks_rec.is_loaded
894: THEN
895: l_planned_task := wms_plan_tasks_pvt.g_plan_task_types(2);
896: DELETE FROM wms_waveplan_tasks_temp wwtt
897: WHERE EXISTS (
898: SELECT 1
899: FROM wms_op_operation_instances wooi
900: WHERE wwtt.transaction_temp_id = wooi.source_task_id

Line 955: ' from wms_waveplan_tasks_temp where ' ||

951: END IF;
952:
953: l_inline_query := ' (Select distinct parent_line_id, reference_id, ' ||
954: ' reference, source_header, line_number '||
955: ' from wms_waveplan_tasks_temp where ' ||
956: ' task_type_id in (2,8) ' ||
957: ' and operation_plan_id is not null ' ||
958: ' and parent_line_id is not null) wwtt ';
959: /**** Get the non-completed plans query first ****/

Line 2970: -- Code for Bug#8467334 .Added to popluate TXN_SOURCE_ID and transaction_source_type_id of loaded tasks in WMS_WAVEPLAN_TASKS_TEMP .

2966: IF l_debug = 1 THEN
2967: debug(' not a completed record ','get_inbound_specific_query');
2968: END IF;
2969:
2970: -- Code for Bug#8467334 .Added to popluate TXN_SOURCE_ID and transaction_source_type_id of loaded tasks in WMS_WAVEPLAN_TASKS_TEMP .
2971: -- We'll use this info -- Populate Job No In ctl Board
2972: l_inbound_select :=', Nvl2(mtrl.reference ,mtrl.reference_id , mtrl.TXN_SOURCE_ID) ' ||
2973: ' , Nvl( mtrl.reference , Decode (mtrl.transaction_source_type_id,5 , ' ||'''WIP JOB'' , NULL ) ) ';
2974: /* Original Code l_inbound_select := ', mtrl.reference_id ' || /*reference_id */

Line 2984: -- Code added to popluate TXN_SOURCE_ID and transaction_source_type_id of completed tasks in WMS_WAVEPLAN_TASKS_TEMP . We'll use this info

2980: IF l_debug = 1 THEN
2981: debug(' querying for completed_record ','get_inbound_specific_query');
2982: END IF;
2983: -- Code for Bug#8467334
2984: -- Code added to popluate TXN_SOURCE_ID and transaction_source_type_id of completed tasks in WMS_WAVEPLAN_TASKS_TEMP . We'll use this info
2985: -- Populate Job No In ctl Board
2986: L_MOVER_ORDER_LINE := '' ;
2987: if wms_plan_tasks_pvt.g_planned_tasks_rec.is_completed = TRUE OR
2988: wms_plan_tasks_pvt.g_is_completed_task = TRUE then