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 GL_SUBR_STA

Line 11853: G_Table_name := 'GL_SUBR_STA';

11849:
11850: BEGIN
11851:
11852: G_Migration_run_id := P_migration_run_id;
11853: G_Table_name := 'GL_SUBR_STA';
11854: G_Context := 'Sub Ledger control data Migration';
11855: X_failure_count := 0;
11856:
11857: /********************************

Line 11874: * Update row in GL_SUBR_STA table *

11870: );
11871:
11872:
11873: /**********************************
11874: * Update row in GL_SUBR_STA table *
11875: ***********************************/
11876:
11877: BEGIN
11878: UPDATE gl_subr_sta a

Line 11878: UPDATE gl_subr_sta a

11874: * Update row in GL_SUBR_STA table *
11875: ***********************************/
11876:
11877: BEGIN
11878: UPDATE gl_subr_sta a
11879: SET (
11880: a.legal_entity_id,
11881: a.legal_entity_name,
11882: a.base_currency,

Line 11919: UPDATE gl_subr_sta gss

11915: a.post_cm_cadj = 0
11916: where (a.co_code is not null and a.legal_entity_id is null)
11917: OR (a.co_code is not null and a.cost_type_id is null);
11918:
11919: UPDATE gl_subr_sta gss
11920: SET (
11921: gss.crev_curr_cost_type_id,
11922: gss.crev_curr_period_id
11923: )

Line 13054: l_gl_subr_sta VARCHAR2(32000) := 'SELECT ''GL_SUBR_STA'' table_name,

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,
13058: ''Current Cost Method Code: ''|| crev_curr_mthd parameters,

Line 13055: gl_subr_sta.*

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,
13058: ''Current Cost Method Code: ''|| crev_curr_mthd parameters,
13059: count(*) records

Line 13060: FROM gl_subr_sta

13056: FROM (
13057: SELECT ''CREV_CURR_COST_TYPE_ID'' column_name,
13058: ''Current Cost Method Code: ''|| crev_curr_mthd parameters,
13059: count(*) records
13060: FROM gl_subr_sta
13061: WHERE (crev_curr_cost_type_id IS NULL AND crev_curr_mthd IS NOT NULL)
13062: GROUP BY crev_curr_mthd
13063: HAVING count(*) > 0
13064: UNION

Line 13068: FROM gl_subr_sta

13064: UNION
13065: SELECT ''CREV_CURR_PERIOD_ID'' column_name,
13066: ''Current Calendar Code: ''|| crev_curr_calendar ||'', Period Code: ''|| crev_curr_period parameters,
13067: count(*) records
13068: FROM gl_subr_sta
13069: WHERE (crev_curr_calendar is not null and crev_curr_period is not NULL AND crev_curr_period_id is null)
13070: GROUP BY crev_curr_calendar, crev_curr_period
13071: HAVING count(*) > 0
13072: UNION

Line 13076: FROM gl_subr_sta

13072: UNION
13073: SELECT ''CREV_PREV_COST_TYPE_ID'' column_name,
13074: ''Previous Cost Method Code: ''|| crev_prev_mthd parameters,
13075: count(*) records
13076: FROM gl_subr_sta
13077: WHERE (crev_prev_cost_type_id IS NULL AND crev_prev_mthd IS NOT NULL)
13078: GROUP BY crev_prev_mthd
13079: HAVING count(*) > 0
13080: UNION

Line 13084: FROM gl_subr_sta

13080: UNION
13081: SELECT ''CREV_PREV_PERIOD_ID'' column_name,
13082: ''Previous Calendar Code: ''|| crev_prev_calendar ||'', Period Code: ''|| crev_prev_period parameters,
13083: count(*) records
13084: FROM gl_subr_sta
13085: WHERE (crev_prev_calendar is not null and crev_prev_period is not NULL AND crev_prev_period_id is null)
13086: GROUP BY crev_prev_calendar, crev_prev_period
13087: HAVING count(*) > 0
13088: UNION

Line 13092: FROM gl_subr_sta

13088: UNION
13089: SELECT ''LEGAL_ENTITY_ID'' column_name,
13090: ''Co Code: ''|| co_code parameters,
13091: count(*) records
13092: FROM gl_subr_sta
13093: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
13094: GROUP BY co_code
13095: HAVING count(*) > 0
13096: UNION

Line 13100: FROM gl_subr_sta

13096: UNION
13097: SELECT ''COST_TYPE_ID'' column_name,
13098: ''Co Code: ''|| co_code parameters,
13099: count(*) records
13100: FROM gl_subr_sta
13101: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
13102: GROUP BY co_code
13103: HAVING count(*) > 0
13104: ) gl_subr_sta';

Line 13104: ) gl_subr_sta';

13100: FROM gl_subr_sta
13101: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
13102: GROUP BY co_code
13103: HAVING count(*) > 0
13104: ) gl_subr_sta';
13105: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
13106: xla_rules_t.*
13107: FROM (
13108: SELECT ''ALL'' column_name,

Line 13943: * Migration Error Logging for table GL_SUBR_STA *

13939: FROM cm_cupd_ctl;
13940: END IF;
13941: END IF;
13942: /************************************************
13943: * Migration Error Logging for table GL_SUBR_STA *
13944: ************************************************/
13945: IF l_table_name IN ('GL_SUBR_STA') THEN
13946: IF p_log_level = 1 THEN
13947: l_sql_statement := l_sql_statement

Line 13945: IF l_table_name IN ('GL_SUBR_STA') THEN

13941: END IF;
13942: /************************************************
13943: * Migration Error Logging for table GL_SUBR_STA *
13944: ************************************************/
13945: IF l_table_name IN ('GL_SUBR_STA') THEN
13946: IF p_log_level = 1 THEN
13947: l_sql_statement := l_sql_statement
13948: ||
13949: '( (crev_curr_mthd is not null AND crev_curr_cost_type_id IS NULL)

Line 13970: FROM gl_subr_sta;

13966: l_prev_cost_type_count,
13967: l_prev_period_count,
13968: l_legal_entity_count,
13969: l_cost_type_count
13970: FROM gl_subr_sta;
13971: END IF;
13972: END IF;
13973: ELSIF p_log_level = 3 THEN
13974: IF l_table_name = 'CM_RSRC_DTL' THEN

Line 14058: ELSIF l_table_name = 'GL_SUBR_STA' THEN

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;
14060: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14061: CLOSE cur_gmf_log_errors;
14062: END IF;

Line 14059: OPEN cur_gmf_log_errors FOR l_gl_subr_sta;

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;
14060: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14061: CLOSE cur_gmf_log_errors;
14062: END IF;
14063: END IF;