APPS.OE_INVOICE_WF dependencies on OE_ORDER_LINES_ALL

Line 69: from oe_order_lines_all t2,

65:
66: -- Added below code for bug 6704643
67: select t1.order_number
68: into l_order_number
69: from oe_order_lines_all t2,
70: oe_order_headers_all t1
71: where t2.line_id = l_line_id
72: and t1.header_id = t2.header_id;
73:

Line 131: and interface_line_attribute6 IN (select to_char(line_id) from oe_order_lines_all where header_id=l_header_id)--to_char() added for bug 10377384

127: SELECT count(1) into l_count
128: from RA_INTERFACE_LINES_ALL
129: where line_type = 'LINE'
130: and interface_line_context = 'ORDER ENTRY'
131: and interface_line_attribute6 IN (select to_char(line_id) from oe_order_lines_all where header_id=l_header_id)--to_char() added for bug 10377384
132: and sales_order = to_char(l_order_number) -- Added for bug 6704643, Bug 6862908
133: and sales_order_line IS NOT NULL; -- Added for bug 6704643
134:
135: IF( l_count = 0) THEN

Line 139: and interface_line_attribute6 IN (select to_char(line_id) from oe_order_lines_all -- to_char() added for bug#10377384

135: IF( l_count = 0) THEN
136: SELECT count(1) into l_count from RA_CUSTOMER_TRX_LINES_ALL
137: where interface_line_context = 'ORDER ENTRY'
138: and line_type = 'LINE'
139: and interface_line_attribute6 IN (select to_char(line_id) from oe_order_lines_all -- to_char() added for bug#10377384
140: where header_id=l_header_id)
141: and sales_order = to_char(l_order_number) -- Added for bug 6704643, Bug 6862908
142: and sales_order_line IS NOT NULL; -- Added for bug 6704643 ;
143: END IF;

Line 214: -- UPDATE OE_ORDER_LINES_ALL /* Bug #3427029 */

210:
211: RETURN;
212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: -- start data fix project
214: -- UPDATE OE_ORDER_LINES_ALL /* Bug #3427029 */
215: -- SET INVOICE_INTERFACE_STATUS_CODE = 'INVOICE-UNEXPECTED-ERROR',
216: -- FLOW_STATUS_CODE = 'INVOICE_UNEXPECTED_ERROR',
217: -- CALCULATE_PRICE_FLAG = 'N',
218: -- LOCK_CONTROL = LOCK_CONTROL + 1