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_VERSION_COMP dependencies on OE_ORDER_LINES

Line 7718: FROM OE_ORDER_LINES_HISTORY

7714: ,x_line_rec.SERVICE_NUMBER
7715: ,x_line_rec.CHANGE_SEQUENCE
7716: ,x_line_rec.transaction_phase_code
7717: ,x_line_rec.source_document_version_number
7718: FROM OE_ORDER_LINES_HISTORY
7719: WHERE LINE_ID = p_line_id
7720: and version_number = p_version
7721: and header_id=p_header_id
7722: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

Line 8404: FROM OE_ORDER_LINES

8400: ,x_line_rec.SERVICE_NUMBER
8401: ,x_line_rec.CHANGE_SEQUENCE
8402: ,x_line_rec.transaction_phase_code
8403: ,x_line_rec.source_document_version_number
8404: FROM OE_ORDER_LINES
8405: WHERE LINE_ID = p_line_id
8406: -- and version_number = p_version
8407: and header_id=p_header_id;
8408: EXCEPTION

Line 18145: from oe_order_lines_history

18141:
18142: l_line_id NUMBER;
18143: CURSOR C_get_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18144: SELECT distinct line_id
18145: from oe_order_lines_history
18146: where header_id = p_header_id
18147: --and transaction_phase_code = p_transaction_phase_code
18148: and version_number in (p_prior_version,p_current_version,p_next_version)
18149: union

Line 18151: from oe_order_lines_all

18147: --and transaction_phase_code = p_transaction_phase_code
18148: and version_number in (p_prior_version,p_current_version,p_next_version)
18149: union
18150: SELECT line_id
18151: from oe_order_lines_all
18152: where header_id=p_header_id;
18153:
18154: CURSOR C_get_hist_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18155: SELECT distinct line_id

Line 18156: from oe_order_lines_history

18152: where header_id=p_header_id;
18153:
18154: CURSOR C_get_hist_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18155: SELECT distinct line_id
18156: from oe_order_lines_history
18157: where header_id = p_header_id
18158: --and transaction_phase_code = p_transaction_phase_code
18159: and version_number in (p_prior_version,p_current_version,p_next_version);
18160: ind1 NUMBER;