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 11522: G_Table_name := 'GL_SUBR_STA';

11518:
11519: BEGIN
11520:
11521: G_Migration_run_id := P_migration_run_id;
11522: G_Table_name := 'GL_SUBR_STA';
11523: G_Context := 'Sub Ledger control data Migration';
11524: X_failure_count := 0;
11525:
11526: /********************************

Line 11543: * Update row in GL_SUBR_STA table *

11539: );
11540:
11541:
11542: /**********************************
11543: * Update row in GL_SUBR_STA table *
11544: ***********************************/
11545:
11546: BEGIN
11547: UPDATE gl_subr_sta a

Line 11547: UPDATE gl_subr_sta a

11543: * Update row in GL_SUBR_STA table *
11544: ***********************************/
11545:
11546: BEGIN
11547: UPDATE gl_subr_sta a
11548: SET (
11549: a.legal_entity_id,
11550: a.legal_entity_name,
11551: a.base_currency,

Line 11588: UPDATE gl_subr_sta gss

11584: a.post_cm_cadj = 0
11585: where (a.co_code is not null and a.legal_entity_id is null)
11586: OR (a.co_code is not null and a.cost_type_id is null);
11587:
11588: UPDATE gl_subr_sta gss
11589: SET (
11590: gss.crev_curr_cost_type_id,
11591: gss.crev_curr_period_id
11592: )

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

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

Line 12724: gl_subr_sta.*

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

Line 12729: FROM gl_subr_sta

12725: FROM (
12726: SELECT ''CREV_CURR_COST_TYPE_ID'' column_name,
12727: ''Current Cost Method Code: ''|| crev_curr_mthd parameters,
12728: count(*) records
12729: FROM gl_subr_sta
12730: WHERE (crev_curr_cost_type_id IS NULL AND crev_curr_mthd IS NOT NULL)
12731: GROUP BY crev_curr_mthd
12732: HAVING count(*) > 0
12733: UNION

Line 12737: FROM gl_subr_sta

12733: UNION
12734: SELECT ''CREV_CURR_PERIOD_ID'' column_name,
12735: ''Current Calendar Code: ''|| crev_curr_calendar ||'', Period Code: ''|| crev_curr_period parameters,
12736: count(*) records
12737: FROM gl_subr_sta
12738: WHERE (crev_curr_calendar is not null and crev_curr_period is not NULL AND crev_curr_period_id is null)
12739: GROUP BY crev_curr_calendar, crev_curr_period
12740: HAVING count(*) > 0
12741: UNION

Line 12745: FROM gl_subr_sta

12741: UNION
12742: SELECT ''CREV_PREV_COST_TYPE_ID'' column_name,
12743: ''Previous Cost Method Code: ''|| crev_prev_mthd parameters,
12744: count(*) records
12745: FROM gl_subr_sta
12746: WHERE (crev_prev_cost_type_id IS NULL AND crev_prev_mthd IS NOT NULL)
12747: GROUP BY crev_prev_mthd
12748: HAVING count(*) > 0
12749: UNION

Line 12753: FROM gl_subr_sta

12749: UNION
12750: SELECT ''CREV_PREV_PERIOD_ID'' column_name,
12751: ''Previous Calendar Code: ''|| crev_prev_calendar ||'', Period Code: ''|| crev_prev_period parameters,
12752: count(*) records
12753: FROM gl_subr_sta
12754: WHERE (crev_prev_calendar is not null and crev_prev_period is not NULL AND crev_prev_period_id is null)
12755: GROUP BY crev_prev_calendar, crev_prev_period
12756: HAVING count(*) > 0
12757: UNION

Line 12761: FROM gl_subr_sta

12757: UNION
12758: SELECT ''LEGAL_ENTITY_ID'' column_name,
12759: ''Co Code: ''|| co_code parameters,
12760: count(*) records
12761: FROM gl_subr_sta
12762: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
12763: GROUP BY co_code
12764: HAVING count(*) > 0
12765: UNION

Line 12769: FROM gl_subr_sta

12765: UNION
12766: SELECT ''COST_TYPE_ID'' column_name,
12767: ''Co Code: ''|| co_code parameters,
12768: count(*) records
12769: FROM gl_subr_sta
12770: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
12771: GROUP BY co_code
12772: HAVING count(*) > 0
12773: ) gl_subr_sta';

Line 12773: ) gl_subr_sta';

12769: FROM gl_subr_sta
12770: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
12771: GROUP BY co_code
12772: HAVING count(*) > 0
12773: ) gl_subr_sta';
12774: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
12775: xla_rules_t.*
12776: FROM (
12777: SELECT ''ALL'' column_name,

Line 13612: * Migration Error Logging for table GL_SUBR_STA *

13608: FROM cm_cupd_ctl;
13609: END IF;
13610: END IF;
13611: /************************************************
13612: * Migration Error Logging for table GL_SUBR_STA *
13613: ************************************************/
13614: IF l_table_name IN ('GL_SUBR_STA') THEN
13615: IF p_log_level = 1 THEN
13616: l_sql_statement := l_sql_statement

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

13610: END IF;
13611: /************************************************
13612: * Migration Error Logging for table GL_SUBR_STA *
13613: ************************************************/
13614: IF l_table_name IN ('GL_SUBR_STA') THEN
13615: IF p_log_level = 1 THEN
13616: l_sql_statement := l_sql_statement
13617: ||
13618: '( (crev_curr_mthd is not null AND crev_curr_cost_type_id IS NULL)

Line 13639: FROM gl_subr_sta;

13635: l_prev_cost_type_count,
13636: l_prev_period_count,
13637: l_legal_entity_count,
13638: l_cost_type_count
13639: FROM gl_subr_sta;
13640: END IF;
13641: END IF;
13642: ELSIF p_log_level = 3 THEN
13643: IF l_table_name = 'CM_RSRC_DTL' THEN

Line 13727: ELSIF l_table_name = 'GL_SUBR_STA' THEN

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;
13729: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13730: CLOSE cur_gmf_log_errors;
13731: END IF;

Line 13728: OPEN cur_gmf_log_errors FOR l_gl_subr_sta;

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;
13729: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13730: CLOSE cur_gmf_log_errors;
13731: END IF;
13732: END IF;