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_ACPR_CTL

Line 2993: SELECT 'CM_ACPR_CTL'

2989: AND a.cost_mthd_Code is not null
2990: AND a.calendar_code = g.calendar_code
2991: AND a.cost_mthd_code = h.cost_mthd_code
2992: UNION
2993: SELECT 'CM_ACPR_CTL'
2994: FROM cm_acpr_ctl a
2995: WHERE a.calendar_code is not null
2996: AND a.cost_mthd_Code is not null
2997: AND a.calendar_code = g.calendar_code

Line 2994: FROM cm_acpr_ctl a

2990: AND a.calendar_code = g.calendar_code
2991: AND a.cost_mthd_code = h.cost_mthd_code
2992: UNION
2993: SELECT 'CM_ACPR_CTL'
2994: FROM cm_acpr_ctl a
2995: WHERE a.calendar_code is not null
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

Line 11158: G_Table_name := 'CM_ACPR_CTL';

11154:
11155: BEGIN
11156:
11157: G_Migration_run_id := P_migration_run_id;
11158: G_Table_name := 'CM_ACPR_CTL';
11159: G_Context := 'Actual cost control data Migration';
11160: X_failure_count := 0;
11161:
11162: /********************************

Line 11179: * Update row in CM_ACPR_CTL table *

11175: );
11176:
11177:
11178: /**********************************
11179: * Update row in CM_ACPR_CTL table *
11180: ***********************************/
11181:
11182: BEGIN
11183: UPDATE cm_acpr_ctl cac

Line 11183: UPDATE cm_acpr_ctl cac

11179: * Update row in CM_ACPR_CTL table *
11180: ***********************************/
11181:
11182: BEGIN
11183: UPDATE cm_acpr_ctl cac
11184: SET (
11185: cac.legal_entity_id,
11186: cac.period_id,
11187: cac.cost_type_id

Line 11684: * Update row in CM_ACPR_CTL table *

11680: );
11681:
11682:
11683: /**********************************
11684: * Update row in CM_ACPR_CTL table *
11685: ***********************************/
11686:
11687: BEGIN
11688: UPDATE cm_cupd_ctl ccc

Line 12933: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,

12929: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12930: GROUP BY orgn_code
12931: HAVING count(*) > 0
12932: ) cm_whse_src';
12933: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12934: cm_acpr_ctl.*
12935: FROM (
12936: SELECT ''COST_TYPE_ID'' column_name,
12937: ''Cost Method Code: ''|| cost_mthd_code parameters,

Line 12934: cm_acpr_ctl.*

12930: GROUP BY orgn_code
12931: HAVING count(*) > 0
12932: ) cm_whse_src';
12933: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12934: cm_acpr_ctl.*
12935: FROM (
12936: SELECT ''COST_TYPE_ID'' column_name,
12937: ''Cost Method Code: ''|| cost_mthd_code parameters,
12938: count(*) records

Line 12939: FROM cm_acpr_ctl

12935: FROM (
12936: SELECT ''COST_TYPE_ID'' column_name,
12937: ''Cost Method Code: ''|| cost_mthd_code parameters,
12938: count(*) records
12939: FROM cm_acpr_ctl
12940: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12941: GROUP BY cost_mthd_code
12942: HAVING count(*) > 0
12943: UNION

Line 12947: FROM cm_acpr_ctl

12943: UNION
12944: SELECT ''PERIOD_ID'' column_name,
12945: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12946: count(*) records
12947: FROM cm_acpr_ctl
12948: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12949: GROUP BY calendar_code, period_code
12950: HAVING count(*) > 0
12951: UNION

Line 12955: FROM cm_acpr_ctl

12951: UNION
12952: SELECT ''LEGAL_ENTITY_ID'' column_name,
12953: ''Calendar Code: ''|| calendar_code parameters,
12954: count(*) records
12955: FROM cm_acpr_ctl
12956: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12957: GROUP BY calendar_code
12958: HAVING count(*) > 0
12959: ) cm_acpr_ctl';

Line 12959: ) cm_acpr_ctl';

12955: FROM cm_acpr_ctl
12956: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12957: GROUP BY calendar_code
12958: HAVING count(*) > 0
12959: ) cm_acpr_ctl';
12960: l_cm_rlup_ctl VARCHAR2(32000) := 'SELECT ''CM_RLUP_CTL'' table_name,
12961: cm_rlup_ctl.*
12962: FROM (
12963: SELECT ''COST_TYPE_ID'' column_name,

Line 13852: * Migration Error Logging for table CM_ACPR_CTL *

13848: FROM cm_whse_src;
13849: END IF;
13850: END IF;
13851: /************************************************
13852: * Migration Error Logging for table CM_ACPR_CTL *
13853: ************************************************/
13854: IF l_table_name IN ('CM_ACPR_CTL') THEN
13855: IF p_log_level = 1 THEN
13856: l_sql_statement := l_sql_statement

Line 13854: IF l_table_name IN ('CM_ACPR_CTL') THEN

13850: END IF;
13851: /************************************************
13852: * Migration Error Logging for table CM_ACPR_CTL *
13853: ************************************************/
13854: IF l_table_name IN ('CM_ACPR_CTL') THEN
13855: IF p_log_level = 1 THEN
13856: l_sql_statement := l_sql_statement
13857: ||
13858: '( (calendar_code IS NOT NULL AND period_code IS NOT NULL and period_id IS NULL)

Line 13870: FROM cm_acpr_ctl;

13866: SUM(CASE WHEN (calendar_code IS NOT NULL AND legal_entity_id IS NULL) THEN 1 ELSE 0 END)
13867: INTO l_period_count,
13868: l_cost_type_count,
13869: l_legal_entity_count
13870: FROM cm_acpr_ctl;
13871: END IF;
13872: END IF;
13873: /************************************************
13874: * Migration Error Logging for table CM_RLUP_CTL *

Line 14042: ELSIF l_table_name = 'CM_ACPR_CTL' THEN

14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
14040: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14041: CLOSE cur_gmf_log_errors;
14042: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
14043: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;
14044: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14045: CLOSE cur_gmf_log_errors;
14046: ELSIF l_table_name = 'CM_RLUP_CTL' THEN

Line 14043: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;

14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
14040: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14041: CLOSE cur_gmf_log_errors;
14042: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
14043: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;
14044: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14045: CLOSE cur_gmf_log_errors;
14046: ELSIF l_table_name = 'CM_RLUP_CTL' THEN
14047: OPEN cur_gmf_log_errors FOR l_cm_rlup_ctl;