DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_ORDER_LINES_HISTORY

Line 7859: FROM OE_ORDER_LINES_HISTORY

7855: ,x_line_rec.SERVICE_BILL_OPTION_CODE
7856: ,x_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
7857: ,x_line_rec.SUBSCRIPTION_ENABLE_FLAG
7858: ,x_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
7859: FROM OE_ORDER_LINES_HISTORY
7860: WHERE LINE_ID = p_line_id
7861: and version_number = p_version
7862: and header_id=p_header_id
7863: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

Line 18652: from oe_order_lines_history

18648:
18649: l_line_id NUMBER;
18650: 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
18651: SELECT distinct line_id
18652: from oe_order_lines_history
18653: where header_id = p_header_id
18654: --Bug 8478088
18655: and version_flag = 'Y'
18656: --and transaction_phase_code = p_transaction_phase_code

Line 18665: from oe_order_lines_history

18661: where header_id=p_header_id;
18662:
18663: 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
18664: SELECT distinct line_id
18665: from oe_order_lines_history
18666: where header_id = p_header_id
18667: --Bug 8478088
18668: and version_flag = 'Y'
18669: --and transaction_phase_code = p_transaction_phase_code