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.GMF_MIGRATION dependencies on CM_CUPD_CTL

Line 3000: SELECT 'CM_CUPD_CTL'

2996: AND a.cost_mthd_Code is not null
2997: AND a.calendar_code = g.calendar_code
2998: AND a.cost_mthd_code = h.cost_mthd_code
2999: UNION
3000: SELECT 'CM_CUPD_CTL'
3001: FROM cm_cupd_ctl a
3002: WHERE a.calendar_code is not null
3003: AND a.cost_mthd_Code is not null
3004: AND a.calendar_code = g.calendar_code

Line 3001: FROM cm_cupd_ctl a

2997: AND a.calendar_code = g.calendar_code
2998: AND a.cost_mthd_code = h.cost_mthd_code
2999: UNION
3000: SELECT 'CM_CUPD_CTL'
3001: FROM cm_cupd_ctl a
3002: WHERE a.calendar_code is not null
3003: AND a.cost_mthd_Code is not null
3004: AND a.calendar_code = g.calendar_code
3005: AND a.cost_mthd_code = h.cost_mthd_code

Line 11332: G_Table_name := 'CM_CUPD_CTL';

11328:
11329: BEGIN
11330:
11331: G_Migration_run_id := P_migration_run_id;
11332: G_Table_name := 'CM_CUPD_CTL';
11333: G_Context := 'Cost Update control data Migration';
11334: X_failure_count := 0;
11335:
11336: /********************************

Line 11357: UPDATE cm_cupd_ctl ccc

11353: * Update row in CM_ACPR_CTL table *
11354: ***********************************/
11355:
11356: BEGIN
11357: UPDATE cm_cupd_ctl ccc
11358: SET (
11359: ccc.legal_entity_id,
11360: ccc.period_id,
11361: ccc.cost_type_id

Line 12696: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,

12692: AND b.item_id = a.item_id
12693: GROUP BY b.item_no
12694: HAVING count(*) > 0
12695: ) cm_rlup_itm';
12696: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
12697: cm_cupd_ctl.*
12698: FROM (
12699: SELECT ''COST_TYPE_ID'' column_name,
12700: ''Cost Method Code: ''|| cost_mthd_code parameters,

Line 12697: cm_cupd_ctl.*

12693: GROUP BY b.item_no
12694: HAVING count(*) > 0
12695: ) cm_rlup_itm';
12696: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
12697: cm_cupd_ctl.*
12698: FROM (
12699: SELECT ''COST_TYPE_ID'' column_name,
12700: ''Cost Method Code: ''|| cost_mthd_code parameters,
12701: count(*) records

Line 12702: FROM cm_cupd_ctl

12698: FROM (
12699: SELECT ''COST_TYPE_ID'' column_name,
12700: ''Cost Method Code: ''|| cost_mthd_code parameters,
12701: count(*) records
12702: FROM cm_cupd_ctl
12703: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12704: GROUP BY cost_mthd_code
12705: HAVING count(*) > 0
12706: UNION

Line 12710: FROM cm_cupd_ctl

12706: UNION
12707: SELECT ''PERIOD_ID'' column_name,
12708: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12709: count(*) records
12710: FROM cm_cupd_ctl
12711: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12712: GROUP BY calendar_code, period_code
12713: HAVING count(*) > 0
12714: UNION

Line 12718: FROM cm_cupd_ctl

12714: UNION
12715: SELECT ''LEGAL_ENTITY_ID'' column_name,
12716: ''Calendar Code: ''|| calendar_code parameters,
12717: count(*) records
12718: FROM cm_cupd_ctl
12719: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12720: GROUP BY calendar_code
12721: HAVING count(*) > 0
12722: ) cm_cupd_ctl';

Line 12722: ) cm_cupd_ctl';

12718: FROM cm_cupd_ctl
12719: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12720: GROUP BY calendar_code
12721: HAVING count(*) > 0
12722: ) cm_cupd_ctl';
12723: l_gl_subr_sta VARCHAR2(32000) := 'SELECT ''GL_SUBR_STA'' table_name,
12724: gl_subr_sta.*
12725: FROM (
12726: SELECT ''CREV_CURR_COST_TYPE_ID'' column_name,

Line 13590: * Migration Error Logging for table CM_CUPD_CTL *

13586: FROM cm_rlup_itm;
13587: END IF;
13588: END IF;
13589: /************************************************
13590: * Migration Error Logging for table CM_CUPD_CTL *
13591: ************************************************/
13592: IF l_table_name IN ('CM_CUPD_CTL') THEN
13593: IF p_log_level = 1 THEN
13594: l_sql_statement := l_sql_statement

Line 13592: IF l_table_name IN ('CM_CUPD_CTL') THEN

13588: END IF;
13589: /************************************************
13590: * Migration Error Logging for table CM_CUPD_CTL *
13591: ************************************************/
13592: IF l_table_name IN ('CM_CUPD_CTL') THEN
13593: IF p_log_level = 1 THEN
13594: l_sql_statement := l_sql_statement
13595: ||
13596: '( (calendar_code IS NOT NULL AND period_code IS NOT NULL and period_id IS NULL)

Line 13608: FROM cm_cupd_ctl;

13604: SUM(CASE WHEN (calendar_code IS NOT NULL AND legal_entity_id IS NULL) THEN 1 ELSE 0 END)
13605: INTO l_period_count,
13606: l_cost_type_count,
13607: l_legal_entity_count
13608: FROM cm_cupd_ctl;
13609: END IF;
13610: END IF;
13611: /************************************************
13612: * Migration Error Logging for table GL_SUBR_STA *

Line 13723: ELSIF l_table_name = 'CM_CUPD_CTL' THEN

13719: ELSIF l_table_name = 'CM_RLUP_ITM' THEN
13720: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;
13721: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13722: CLOSE cur_gmf_log_errors;
13723: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
13724: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;
13725: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13726: CLOSE cur_gmf_log_errors;
13727: ELSIF l_table_name = 'GL_SUBR_STA' THEN

Line 13724: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;

13720: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;
13721: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13722: CLOSE cur_gmf_log_errors;
13723: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
13724: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;
13725: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13726: CLOSE cur_gmf_log_errors;
13727: ELSIF l_table_name = 'GL_SUBR_STA' THEN
13728: OPEN cur_gmf_log_errors FOR l_gl_subr_sta;