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 11663: G_Table_name := 'CM_CUPD_CTL';

11659:
11660: BEGIN
11661:
11662: G_Migration_run_id := P_migration_run_id;
11663: G_Table_name := 'CM_CUPD_CTL';
11664: G_Context := 'Cost Update control data Migration';
11665: X_failure_count := 0;
11666:
11667: /********************************

Line 11688: UPDATE cm_cupd_ctl ccc

11684: * Update row in CM_ACPR_CTL table *
11685: ***********************************/
11686:
11687: BEGIN
11688: UPDATE cm_cupd_ctl ccc
11689: SET (
11690: ccc.legal_entity_id,
11691: ccc.period_id,
11692: ccc.cost_type_id

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

13023: AND b.item_id = a.item_id
13024: GROUP BY b.item_no
13025: HAVING count(*) > 0
13026: ) cm_rlup_itm';
13027: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
13028: cm_cupd_ctl.*
13029: FROM (
13030: SELECT ''COST_TYPE_ID'' column_name,
13031: ''Cost Method Code: ''|| cost_mthd_code parameters,

Line 13028: cm_cupd_ctl.*

13024: GROUP BY b.item_no
13025: HAVING count(*) > 0
13026: ) cm_rlup_itm';
13027: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
13028: cm_cupd_ctl.*
13029: FROM (
13030: SELECT ''COST_TYPE_ID'' column_name,
13031: ''Cost Method Code: ''|| cost_mthd_code parameters,
13032: count(*) records

Line 13033: FROM cm_cupd_ctl

13029: FROM (
13030: SELECT ''COST_TYPE_ID'' column_name,
13031: ''Cost Method Code: ''|| cost_mthd_code parameters,
13032: count(*) records
13033: FROM cm_cupd_ctl
13034: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
13035: GROUP BY cost_mthd_code
13036: HAVING count(*) > 0
13037: UNION

Line 13041: FROM cm_cupd_ctl

13037: UNION
13038: SELECT ''PERIOD_ID'' column_name,
13039: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
13040: count(*) records
13041: FROM cm_cupd_ctl
13042: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
13043: GROUP BY calendar_code, period_code
13044: HAVING count(*) > 0
13045: UNION

Line 13049: FROM cm_cupd_ctl

13045: UNION
13046: SELECT ''LEGAL_ENTITY_ID'' column_name,
13047: ''Calendar Code: ''|| calendar_code parameters,
13048: count(*) records
13049: FROM cm_cupd_ctl
13050: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
13051: GROUP BY calendar_code
13052: HAVING count(*) > 0
13053: ) cm_cupd_ctl';

Line 13053: ) cm_cupd_ctl';

13049: FROM cm_cupd_ctl
13050: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
13051: GROUP BY calendar_code
13052: HAVING count(*) > 0
13053: ) cm_cupd_ctl';
13054: l_gl_subr_sta VARCHAR2(32000) := 'SELECT ''GL_SUBR_STA'' table_name,
13055: gl_subr_sta.*
13056: FROM (
13057: SELECT ''CREV_CURR_COST_TYPE_ID'' column_name,

Line 13921: * Migration Error Logging for table CM_CUPD_CTL *

13917: FROM cm_rlup_itm;
13918: END IF;
13919: END IF;
13920: /************************************************
13921: * Migration Error Logging for table CM_CUPD_CTL *
13922: ************************************************/
13923: IF l_table_name IN ('CM_CUPD_CTL') THEN
13924: IF p_log_level = 1 THEN
13925: l_sql_statement := l_sql_statement

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

13919: END IF;
13920: /************************************************
13921: * Migration Error Logging for table CM_CUPD_CTL *
13922: ************************************************/
13923: IF l_table_name IN ('CM_CUPD_CTL') THEN
13924: IF p_log_level = 1 THEN
13925: l_sql_statement := l_sql_statement
13926: ||
13927: '( (calendar_code IS NOT NULL AND period_code IS NOT NULL and period_id IS NULL)

Line 13939: FROM cm_cupd_ctl;

13935: SUM(CASE WHEN (calendar_code IS NOT NULL AND legal_entity_id IS NULL) THEN 1 ELSE 0 END)
13936: INTO l_period_count,
13937: l_cost_type_count,
13938: l_legal_entity_count
13939: FROM cm_cupd_ctl;
13940: END IF;
13941: END IF;
13942: /************************************************
13943: * Migration Error Logging for table GL_SUBR_STA *

Line 14054: ELSIF l_table_name = 'CM_CUPD_CTL' THEN

14050: ELSIF l_table_name = 'CM_RLUP_ITM' THEN
14051: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;
14052: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14053: CLOSE cur_gmf_log_errors;
14054: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
14055: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;
14056: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14057: CLOSE cur_gmf_log_errors;
14058: ELSIF l_table_name = 'GL_SUBR_STA' THEN

Line 14055: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;

14051: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;
14052: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14053: CLOSE cur_gmf_log_errors;
14054: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
14055: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;
14056: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14057: CLOSE cur_gmf_log_errors;
14058: ELSIF l_table_name = 'GL_SUBR_STA' THEN
14059: OPEN cur_gmf_log_errors FOR l_gl_subr_sta;