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 10827: G_Table_name := 'CM_ACPR_CTL';

10823:
10824: BEGIN
10825:
10826: G_Migration_run_id := P_migration_run_id;
10827: G_Table_name := 'CM_ACPR_CTL';
10828: G_Context := 'Actual cost control data Migration';
10829: X_failure_count := 0;
10830:
10831: /********************************

Line 10848: * Update row in CM_ACPR_CTL table *

10844: );
10845:
10846:
10847: /**********************************
10848: * Update row in CM_ACPR_CTL table *
10849: ***********************************/
10850:
10851: BEGIN
10852: UPDATE cm_acpr_ctl cac

Line 10852: UPDATE cm_acpr_ctl cac

10848: * Update row in CM_ACPR_CTL table *
10849: ***********************************/
10850:
10851: BEGIN
10852: UPDATE cm_acpr_ctl cac
10853: SET (
10854: cac.legal_entity_id,
10855: cac.period_id,
10856: cac.cost_type_id

Line 11353: * Update row in CM_ACPR_CTL table *

11349: );
11350:
11351:
11352: /**********************************
11353: * Update row in CM_ACPR_CTL table *
11354: ***********************************/
11355:
11356: BEGIN
11357: UPDATE cm_cupd_ctl ccc

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

12598: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12599: GROUP BY orgn_code
12600: HAVING count(*) > 0
12601: ) cm_whse_src';
12602: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12603: cm_acpr_ctl.*
12604: FROM (
12605: SELECT ''COST_TYPE_ID'' column_name,
12606: ''Cost Method Code: ''|| cost_mthd_code parameters,

Line 12603: cm_acpr_ctl.*

12599: GROUP BY orgn_code
12600: HAVING count(*) > 0
12601: ) cm_whse_src';
12602: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12603: cm_acpr_ctl.*
12604: FROM (
12605: SELECT ''COST_TYPE_ID'' column_name,
12606: ''Cost Method Code: ''|| cost_mthd_code parameters,
12607: count(*) records

Line 12608: FROM cm_acpr_ctl

12604: FROM (
12605: SELECT ''COST_TYPE_ID'' column_name,
12606: ''Cost Method Code: ''|| cost_mthd_code parameters,
12607: count(*) records
12608: FROM cm_acpr_ctl
12609: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12610: GROUP BY cost_mthd_code
12611: HAVING count(*) > 0
12612: UNION

Line 12616: FROM cm_acpr_ctl

12612: UNION
12613: SELECT ''PERIOD_ID'' column_name,
12614: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12615: count(*) records
12616: FROM cm_acpr_ctl
12617: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12618: GROUP BY calendar_code, period_code
12619: HAVING count(*) > 0
12620: UNION

Line 12624: FROM cm_acpr_ctl

12620: UNION
12621: SELECT ''LEGAL_ENTITY_ID'' column_name,
12622: ''Calendar Code: ''|| calendar_code parameters,
12623: count(*) records
12624: FROM cm_acpr_ctl
12625: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12626: GROUP BY calendar_code
12627: HAVING count(*) > 0
12628: ) cm_acpr_ctl';

Line 12628: ) cm_acpr_ctl';

12624: FROM cm_acpr_ctl
12625: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12626: GROUP BY calendar_code
12627: HAVING count(*) > 0
12628: ) cm_acpr_ctl';
12629: l_cm_rlup_ctl VARCHAR2(32000) := 'SELECT ''CM_RLUP_CTL'' table_name,
12630: cm_rlup_ctl.*
12631: FROM (
12632: SELECT ''COST_TYPE_ID'' column_name,

Line 13521: * Migration Error Logging for table CM_ACPR_CTL *

13517: FROM cm_whse_src;
13518: END IF;
13519: END IF;
13520: /************************************************
13521: * Migration Error Logging for table CM_ACPR_CTL *
13522: ************************************************/
13523: IF l_table_name IN ('CM_ACPR_CTL') THEN
13524: IF p_log_level = 1 THEN
13525: l_sql_statement := l_sql_statement

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

13519: END IF;
13520: /************************************************
13521: * Migration Error Logging for table CM_ACPR_CTL *
13522: ************************************************/
13523: IF l_table_name IN ('CM_ACPR_CTL') THEN
13524: IF p_log_level = 1 THEN
13525: l_sql_statement := l_sql_statement
13526: ||
13527: '( (calendar_code IS NOT NULL AND period_code IS NOT NULL and period_id IS NULL)

Line 13539: FROM cm_acpr_ctl;

13535: SUM(CASE WHEN (calendar_code IS NOT NULL AND legal_entity_id IS NULL) THEN 1 ELSE 0 END)
13536: INTO l_period_count,
13537: l_cost_type_count,
13538: l_legal_entity_count
13539: FROM cm_acpr_ctl;
13540: END IF;
13541: END IF;
13542: /************************************************
13543: * Migration Error Logging for table CM_RLUP_CTL *

Line 13711: ELSIF l_table_name = 'CM_ACPR_CTL' THEN

13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
13709: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13710: CLOSE cur_gmf_log_errors;
13711: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
13712: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;
13713: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13714: CLOSE cur_gmf_log_errors;
13715: ELSIF l_table_name = 'CM_RLUP_CTL' THEN

Line 13712: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;

13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
13709: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13710: CLOSE cur_gmf_log_errors;
13711: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
13712: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;
13713: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13714: CLOSE cur_gmf_log_errors;
13715: ELSIF l_table_name = 'CM_RLUP_CTL' THEN
13716: OPEN cur_gmf_log_errors FOR l_cm_rlup_ctl;