eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INVOICE_WF dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 90: SELECT count(1) into l_count from RA_CUSTOMER_TRX_LINES_ALL RCTL

86: and sales_order = to_char(l_order_number) -- Added for bug 6704643, Bug 6862908
87: and sales_order_line IS NOT NULL; -- Added for bug 6704643
88:
89: IF( l_count = 0) THEN
90: SELECT count(1) into l_count from RA_CUSTOMER_TRX_LINES_ALL RCTL
91: where rctl.interface_line_context = 'ORDER ENTRY'
92: and rctl.line_type = 'LINE'
93: and RCTL.interface_line_attribute6 = to_char(l_line_id)
94: and rctl.sales_order = to_char(l_order_number) -- Added for bug 6704643, Bug 6862908

Line 136: SELECT count(1) into l_count from RA_CUSTOMER_TRX_LINES_ALL

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
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)