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 1457: INSERT INTO OE_SALES_CREDIT_HISTORY (

1453:
1454: -- Create History Records for SalesCredits
1455: l_api_name := 'Create_Sales_Credits_History';
1456:
1457: INSERT INTO OE_SALES_CREDIT_HISTORY (
1458: SALES_CREDIT_ID,
1459: HEADER_ID,
1460: HIST_CREATION_DATE,
1461: CREATION_DATE,

Line 1545: FROM OE_SALES_CREDIT_HISTORY b

1541: p_phase_change_flag --PHASE_CHANGE_FLAG,
1542: FROM oe_sales_credits a
1543: WHERE a.header_id = p_header_id
1544: AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
1545: FROM OE_SALES_CREDIT_HISTORY b
1546: WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID
1547: AND a.header_id = b.header_id
1548: AND b.VERSION_NUMBER = l_version_number
1549: AND b.version_flag = l_version_flag);

Line 1604: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s

1600: WHERE h.header_id = s.header_id
1601: AND s.sales_credit_id = p_sales_credit_id;
1602: EXCEPTION WHEN NO_DATA_FOUND THEN
1603: SELECT h.version_number INTO l_current_version_number
1604: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
1605: WHERE h.header_id = s.header_id
1606: AND s.sales_credit_id = p_sales_credit_id
1607: AND rownum = 1;
1608: END;

Line 2709: FROM OE_SALES_CREDIT_HISTORY

2705: -- , SALES_GROUP_ID
2706: -- , SALES_GROUP_UPDATED
2707: --SG }
2708: , LOCK_CONTROL
2709: FROM OE_SALES_CREDIT_HISTORY
2710: WHERE SALES_CREDIT_ID = p_sales_credit_id
2711: AND VERSION_NUMBER = l_version_number
2712: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2713: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 2751: FROM OE_SALES_CREDIT_HISTORY

2747: -- , SALES_GROUP_ID
2748: -- , SALES_GROUP_UPDATED
2749: --SG }
2750: , LOCK_CONTROL
2751: FROM OE_SALES_CREDIT_HISTORY
2752: WHERE HEADER_ID = p_header_id
2753: AND LINE_ID IS NULL
2754: AND VERSION_NUMBER = l_version_number
2755: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

Line 5129: FROM OE_SALES_CREDIT_HISTORY

5125: , sales_credit_type_id
5126: , SALES_CREDIT_ID
5127: , WH_UPDATE_DATE
5128: , LOCK_CONTROL
5129: FROM OE_SALES_CREDIT_HISTORY
5130: WHERE SALES_CREDIT_ID = p_sales_credit_id
5131: AND VERSION_NUMBER = l_version_number
5132: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5133: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 5167: FROM OE_SALES_CREDIT_HISTORY

5163: , sales_credit_type_id
5164: , SALES_CREDIT_ID
5165: , WH_UPDATE_DATE
5166: , LOCK_CONTROL
5167: FROM OE_SALES_CREDIT_HISTORY
5168: WHERE LINE_ID = p_line_id
5169: AND VERSION_NUMBER = l_version_number
5170: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5171: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 5205: FROM OE_SALES_CREDIT_HISTORY

5201: , sales_credit_type_id
5202: , SALES_CREDIT_ID
5203: , WH_UPDATE_DATE
5204: , LOCK_CONTROL
5205: FROM OE_SALES_CREDIT_HISTORY
5206: WHERE HEADER_ID = p_header_id
5207: AND LINE_ID IS NOT NULL
5208: AND VERSION_NUMBER = l_version_number
5209: AND (PHASE_CHANGE_FLAG = p_phase_change_flag