APPS.OE_SCH_FIRM_CONC dependencies on OE_ORDER_LINES

Line 78: -- Moac Changed below cursor to join to oe_order_lines table

74: -- variable for debugging.
75: l_file_val VARCHAR2(80);
76:
77:
78: -- Moac Changed below cursor to join to oe_order_lines table
79: CURSOR wf_item IS
80: Select item_key, l.org_id
81: From wf_item_activity_statuses wias, wf_process_activities wpa,
82: oe_order_lines l

Line 82: oe_order_lines l

78: -- Moac Changed below cursor to join to oe_order_lines table
79: CURSOR wf_item IS
80: Select item_key, l.org_id
81: From wf_item_activity_statuses wias, wf_process_activities wpa,
82: oe_order_lines l
83: Where wias.item_type = 'OEOL'
84: And wias.process_activity = wpa.instance_id
85: And wpa.activity_item_type = 'OEOL'
86: And wpa.activity_name = 'FIRM_ELIGIBLE'

Line 221: l_sql_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ';

217: l_ordered_date_high
218: FROM DUAL;
219:
220:
221: l_sql_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ';
222:
223: l_sql_stmt := l_sql_stmt|| ' WHERE h.header_id = l.header_id'||
224: ' AND h.open_flag = '||'''Y'''||
225: ' AND NVL(l.cancelled_flag,'||'''N'''||') <> '||'''Y'''||