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_HISTORY_UTIL dependencies on OE_SALES_CREDIT_HISTORY

Line 8: -- 4. oe_sales_credit_history

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
12: -- be sent in as NULL and p_phase_change_flag = 'Y'.

Line 1520: INSERT INTO OE_SALES_CREDIT_HISTORY (

1516:
1517: -- Create History Records for SalesCredits
1518: l_api_name := 'Create_Sales_Credits_History';
1519:
1520: INSERT INTO OE_SALES_CREDIT_HISTORY (
1521: SALES_CREDIT_ID,
1522: HEADER_ID,
1523: HIST_CREATION_DATE,
1524: CREATION_DATE,

Line 1608: FROM OE_SALES_CREDIT_HISTORY b

1604: p_phase_change_flag --PHASE_CHANGE_FLAG,
1605: FROM oe_sales_credits a
1606: WHERE a.header_id = p_header_id
1607: AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
1608: FROM OE_SALES_CREDIT_HISTORY b
1609: WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID
1610: AND a.header_id = b.header_id
1611: AND b.VERSION_NUMBER = l_version_number
1612: AND b.version_flag = l_version_flag);

Line 1667: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s

1663: WHERE h.header_id = s.header_id
1664: AND s.sales_credit_id = p_sales_credit_id;
1665: EXCEPTION WHEN NO_DATA_FOUND THEN
1666: SELECT h.version_number INTO l_current_version_number
1667: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
1668: WHERE h.header_id = s.header_id
1669: AND s.sales_credit_id = p_sales_credit_id
1670: AND rownum = 1;
1671: END;

Line 2772: FROM OE_SALES_CREDIT_HISTORY

2768: -- , SALES_GROUP_ID
2769: -- , SALES_GROUP_UPDATED
2770: --SG }
2771: , LOCK_CONTROL
2772: FROM OE_SALES_CREDIT_HISTORY
2773: WHERE SALES_CREDIT_ID = p_sales_credit_id
2774: AND VERSION_NUMBER = l_version_number
2775: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2776: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 2814: FROM OE_SALES_CREDIT_HISTORY

2810: -- , SALES_GROUP_ID
2811: -- , SALES_GROUP_UPDATED
2812: --SG }
2813: , LOCK_CONTROL
2814: FROM OE_SALES_CREDIT_HISTORY
2815: WHERE HEADER_ID = p_header_id
2816: AND LINE_ID IS NULL
2817: AND VERSION_NUMBER = l_version_number
2818: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

Line 5225: FROM OE_SALES_CREDIT_HISTORY

5221: , sales_credit_type_id
5222: , SALES_CREDIT_ID
5223: , WH_UPDATE_DATE
5224: , LOCK_CONTROL
5225: FROM OE_SALES_CREDIT_HISTORY
5226: WHERE SALES_CREDIT_ID = p_sales_credit_id
5227: AND VERSION_NUMBER = l_version_number
5228: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5229: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 5263: FROM OE_SALES_CREDIT_HISTORY

5259: , sales_credit_type_id
5260: , SALES_CREDIT_ID
5261: , WH_UPDATE_DATE
5262: , LOCK_CONTROL
5263: FROM OE_SALES_CREDIT_HISTORY
5264: WHERE LINE_ID = p_line_id
5265: AND VERSION_NUMBER = l_version_number
5266: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5267: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 5301: FROM OE_SALES_CREDIT_HISTORY

5297: , sales_credit_type_id
5298: , SALES_CREDIT_ID
5299: , WH_UPDATE_DATE
5300: , LOCK_CONTROL
5301: FROM OE_SALES_CREDIT_HISTORY
5302: WHERE HEADER_ID = p_header_id
5303: AND LINE_ID IS NOT NULL
5304: AND VERSION_NUMBER = l_version_number
5305: AND (PHASE_CHANGE_FLAG = p_phase_change_flag