APPS.OTA_INITIALIZATION_WF dependencies on OE_ORDER_LINES_ALL

Line 73: FROM OE_ORDER_LINES_ALL

69: HEADER_ID
70: FROM OE_ORDER_HEADERS_ALL
71: WHERE HEADER_ID IN(
72: SELECT HEADER_ID
73: FROM OE_ORDER_LINES_ALL
74: WHERE LINE_ID = p_line_id);
75:
76:
77: CURSOR c_event

Line 190: OE_ORDER_LINES_ALL

186: HEADER_ID IN(
187: SELECT
188: HEADER_ID
189: FROM
190: OE_ORDER_LINES_ALL
191: WHERE
192: LINE_ID = p_line_id);
193:
194: CURSOR

Line 210: oe_order_lines_all

206: CURSOR C_ORDER_LINE IS
207: Select
208: line_number
209: from
210: oe_order_lines_all
211: where
212: line_id = p_line_id;
213:
214:

Line 222: l_line_number oe_order_lines_all.line_number%type;

218: l_header_id oe_order_headers.header_id%type;
219: l_proc varchar2(72) := g_package||'initialize_cancel_event';
220: l_wf_date VARCHAR2(30);
221: l_item_key wf_items.item_key%TYPE;
222: l_line_number oe_order_lines_all.line_number%type;
223:
224: BEGIN
225: hr_utility.set_location('Entering:'||l_proc, 5);
226:

Line 370: OE_ORDER_LINES_ALL

366: HEADER_ID IN(
367: SELECT
368: HEADER_ID
369: FROM
370: OE_ORDER_LINES_ALL
371: WHERE
372: LINE_ID = p_line_id);
373:
374: CURSOR C_ORDER_LINE IS

Line 378: oe_order_lines_all

374: CURSOR C_ORDER_LINE IS
375: Select
376: line_number
377: from
378: oe_order_lines_all
379: where
380: line_id = p_line_id;
381:
382: l_order_number oe_order_headers.order_number%type;

Line 386: l_line_number oe_order_lines_all.line_number%type;

382: l_order_number oe_order_headers.order_number%type;
383: l_header_id oe_order_headers.header_id%type;
384: l_process wf_activities.name%type := upper(p_process);
385: l_itemkey wf_items.item_key%type;
386: l_line_number oe_order_lines_all.line_number%type;
387:
388: l_proc varchar2(72) := g_package||'initialize_cancel_order';
389:
390: BEGIN