APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PRICE_ADJS_HISTORY

Line 7: -- 3. oe_price_adjs_history

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: --
11: -- If the API is called just for Phase_Change then p_version_number should

Line 1224: INSERT INTO OE_PRICE_ADJS_HISTORY(

1220:
1221: -- Create History Records for Adjustments
1222: l_api_name := 'Create_Price_Adjs_History';
1223:
1224: INSERT INTO OE_PRICE_ADJS_HISTORY(
1225: PRICE_ADJUSTMENT_ID,
1226: HEADER_ID,
1227: HIST_CREATION_DATE,
1228: CREATION_DATE,

Line 1444: FROM OE_PRICE_ADJS_HISTORY b

1440: p_phase_change_flag --PHASE_CHANGE_FLAG
1441: FROM OE_PRICE_ADJUSTMENTS a
1442: WHERE a.header_id = p_header_id
1443: AND NOT EXISTS ( SELECT price_adjustment_id
1444: FROM OE_PRICE_ADJS_HISTORY b
1445: WHERE b.price_adjustment_id = a.price_adjustment_id
1446: AND a.header_id = b.header_id
1447: AND b.version_number = l_version_number
1448: AND b.version_flag = l_version_flag);

Line 1589: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p

1585: WHERE h.header_id = p.header_id
1586: AND p.price_adjustment_id = p_price_adjustment_id;
1587: EXCEPTION WHEN NO_DATA_FOUND THEN
1588: SELECT h.version_number INTO l_current_version_number
1589: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
1590: WHERE h.header_id = p.header_id
1591: AND p.price_adjustment_id = p_price_adjustment_id
1592: AND rownum = 1;
1593: END;

Line 2290: FROM OE_PRICE_ADJS_HISTORY

2286: -- , OPERAND_PER_PQTY
2287: -- , ADJUSTED_AMOUNT_PER_PQTY
2288: --uom end
2289: , LOCK_CONTROL
2290: FROM OE_PRICE_ADJS_HISTORY
2291: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
2292: AND VERSION_NUMBER = l_version_number
2293: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2294: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 2399: FROM OE_PRICE_ADJS_HISTORY

2395: -- , OPERAND_PER_PQTY
2396: -- , ADJUSTED_AMOUNT_PER_PQTY
2397: --uom end
2398: , LOCK_CONTROL
2399: FROM OE_PRICE_ADJS_HISTORY
2400: WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL
2401: AND VERSION_NUMBER = l_version_number
2402: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2403: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4600: FROM OE_PRICE_ADJS_HISTORY

4596: --uom end
4597: , LOCK_CONTROL
4598: -- eBTax changes
4599: , TAX_RATE_ID
4600: FROM OE_PRICE_ADJS_HISTORY
4601: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
4602: and version_number = l_version_number
4603: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4604: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4712: FROM OE_PRICE_ADJS_HISTORY

4708: , LOCK_CONTROL
4709: -- eBTax changes
4710: , TAX_RATE_ID
4711:
4712: FROM OE_PRICE_ADJS_HISTORY
4713: WHERE line_id = p_line_id
4714: and version_number = l_version_number
4715: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4716: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4823: FROM OE_PRICE_ADJS_HISTORY

4819: --uom end
4820: , LOCK_CONTROL
4821: -- eBTax changes
4822: , TAX_RATE_ID
4823: FROM OE_PRICE_ADJS_HISTORY
4824: WHERE header_id = p_header_id
4825: and line_id is not null
4826: and version_number = l_version_number
4827: AND (PHASE_CHANGE_FLAG = p_phase_change_flag