APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_LINES_HISTORY

Line 6: -- 2. oe_order_lines_history

2: /* $Header: OEXHVERB.pls 120.7 2006/06/12 22:26:15 lkxu noship $ */
3:
4: -- This API will be used to create history records for entities.
5: -- 1. oe_order_header_history
6: -- 2. oe_order_lines_history
7: -- 3. oe_price_adjs_history
8: -- 4. oe_sales_credit_history
9: -- It will skip the records which already exists for the specified version.
10: --

Line 517: INSERT INTO oe_order_lines_history

513:
514: -- Create History Records for Lines
515: l_api_name := 'Create_Line_History';
516:
517: INSERT INTO oe_order_lines_history
518: (
519: LINE_ID,
520: ORG_ID,
521: HEADER_ID,

Line 1212: FROM oe_order_lines_history b

1208: actual_fulfillment_date
1209: FROM OE_ORDER_LINES_ALL a
1210: WHERE header_id = p_header_id
1211: AND NOT EXISTS (select b.line_id
1212: FROM oe_order_lines_history b
1213: WHERE a.line_id = b.line_id
1214: AND a.header_id = b.header_id
1215: AND b.version_number = l_version_number
1216: AND b.version_flag = l_version_flag);

Line 1618: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l

1614: WHERE h.header_id = l.header_id
1615: AND l.line_id = p_line_id;
1616: EXCEPTION WHEN NO_DATA_FOUND THEN
1617: SELECT h.version_number INTO l_current_version_number
1618: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
1619: WHERE h.header_id = l.header_id
1620: AND l.line_id = p_line_id
1621: AND rownum = 1;
1622: END;

Line 3277: FROM OE_ORDER_LINES_HISTORY

3273: , CHANGE_SEQUENCE
3274: --key Transaction Dates
3275: , order_firmed_date
3276: , actual_fulfillment_date
3277: FROM OE_ORDER_LINES_HISTORY
3278: WHERE LINE_ID = p_line_id
3279: AND VERSION_NUMBER = l_version_number
3280: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3281: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 3615: FROM OE_ORDER_LINES_HISTORY

3611: , CHANGE_SEQUENCE
3612: --key Transaction Dates
3613: , order_firmed_date
3614: , actual_fulfillment_date
3615: FROM OE_ORDER_LINES_HISTORY
3616: WHERE HEADER_ID = p_header_id
3617: AND VERSION_NUMBER = l_version_number
3618: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3619: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 3955: FROM OE_ORDER_LINES_HISTORY

3951: , CHANGE_SEQUENCE
3952: --key Transaction Dates
3953: , order_firmed_date
3954: , actual_fulfillment_date
3955: FROM OE_ORDER_LINES_HISTORY
3956: WHERE LINE_SET_ID = p_line_set_id
3957: AND VERSION_NUMBER = l_version_number
3958: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3959: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'