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 line_id from oe_order_lines_all where header_id=l_header_id)

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 line_id from oe_order_lines_all where header_id=l_header_id)
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 line_id from oe_order_lines_all

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 line_id from oe_order_lines_all
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 208: -- UPDATE OE_ORDER_LINES_ALL /* Bug #3427029 */

204:
205: RETURN;
206: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: -- start data fix project
208: -- UPDATE OE_ORDER_LINES_ALL /* Bug #3427029 */
209: -- SET INVOICE_INTERFACE_STATUS_CODE = 'INVOICE-UNEXPECTED-ERROR',
210: -- FLOW_STATUS_CODE = 'INVOICE_UNEXPECTED_ERROR',
211: -- CALCULATE_PRICE_FLAG = 'N',
212: -- LOCK_CONTROL = LOCK_CONTROL + 1