DBA Data[Home] [Help]

APPS.OE_INVOICE_WF dependencies on RA_INTERFACE_LINES_ALL

Line 82: from RA_INTERFACE_LINES_ALL

78:
79:
80: --bug 6065302
81: SELECT count(1) into l_count
82: from RA_INTERFACE_LINES_ALL
83: where line_type = 'LINE'
84: and interface_line_context = 'ORDER ENTRY'
85: and interface_line_attribute6 = to_char(l_line_id)
86: and sales_order = to_char(l_order_number) -- Added for bug 6704643, Bug 6862908

Line 128: from RA_INTERFACE_LINES_ALL

124:
125:
126: -- bug 6065302
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