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_RLUP_CTL

Line 2986: SELECT 'CM_RLUP_CTL'

2982: AND a.cost_mthd_Code is not null
2983: AND a.calendar_code = g.calendar_code
2984: AND a.cost_mthd_code = h.cost_mthd_code
2985: UNION
2986: SELECT 'CM_RLUP_CTL'
2987: FROM cm_rlup_ctl a
2988: WHERE a.calendar_code is not null
2989: AND a.cost_mthd_Code is not null
2990: AND a.calendar_code = g.calendar_code

Line 2987: FROM cm_rlup_ctl a

2983: AND a.calendar_code = g.calendar_code
2984: AND a.cost_mthd_code = h.cost_mthd_code
2985: UNION
2986: SELECT 'CM_RLUP_CTL'
2987: FROM cm_rlup_ctl a
2988: WHERE a.calendar_code is not null
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

Line 11350: G_Table_name := 'CM_RLUP_CTL';

11346:
11347: BEGIN
11348:
11349: G_Migration_run_id := P_migration_run_id;
11350: G_Table_name := 'CM_RLUP_CTL';
11351: G_Context := 'Rollup Control Record Migration';
11352: X_failure_count := 0;
11353:
11354: /********************************

Line 11370: * Update row in CM_RLUP_CTL table *

11366: p_app_short_name => 'GMA'
11367: );
11368:
11369: /**********************************
11370: * Update row in CM_RLUP_CTL table *
11371: ***********************************/
11372:
11373: BEGIN
11374:

Line 11375: UPDATE cm_rlup_ctl crc

11371: ***********************************/
11372:
11373: BEGIN
11374:
11375: UPDATE cm_rlup_ctl crc
11376: SET (
11377: crc.legal_entity_id,
11378: crc.period_id,
11379: crc.cost_type_id

Line 11402: UPDATE cm_rlup_ctl a

11398: WHERE (crc.CALENDAR_CODE IS NOT NULL AND crc.PERIOD_CODE IS NOT NULL AND crc.PERIOD_ID IS NULL)
11399: OR (crc.COST_MTHD_CODE IS NOT NULL AND crc.COST_TYPE_ID IS NULL)
11400: OR (crc.CALENDAR_CODE IS NOT NULL AND crc.LEGAL_ENTITY_ID IS NULL);
11401:
11402: UPDATE cm_rlup_ctl a
11403: SET (
11404: a.master_organization_id,
11405: a.inventory_item_id
11406: )

Line 11509: cm_rlup_ctl x

11505: y.inventory_item_id
11506: FROM ic_item_mst_b_mig y,
11507: mtl_parameters z,
11508: hr_organization_information hoi,
11509: cm_rlup_ctl x
11510: WHERE y.item_id = a.item_id
11511: AND y.organization_id = z.organization_id
11512: AND hoi.organization_id = z.organization_id
11513: AND hoi.org_information_context = 'Accounting Information'

Line 12960: l_cm_rlup_ctl VARCHAR2(32000) := 'SELECT ''CM_RLUP_CTL'' table_name,

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,
12964: ''Cost Method Code: ''|| cost_mthd_code parameters,

Line 12961: cm_rlup_ctl.*

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,
12964: ''Cost Method Code: ''|| cost_mthd_code parameters,
12965: count(*) records

Line 12966: FROM cm_rlup_ctl

12962: FROM (
12963: SELECT ''COST_TYPE_ID'' column_name,
12964: ''Cost Method Code: ''|| cost_mthd_code parameters,
12965: count(*) records
12966: FROM cm_rlup_ctl
12967: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12968: GROUP BY cost_mthd_code
12969: HAVING count(*) > 0
12970: UNION

Line 12974: FROM cm_rlup_ctl

12970: UNION
12971: SELECT ''PERIOD_ID'' column_name,
12972: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12973: count(*) records
12974: FROM cm_rlup_ctl
12975: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12976: GROUP BY calendar_code, period_code
12977: HAVING count(*) > 0
12978: UNION

Line 12982: FROM cm_rlup_ctl

12978: UNION
12979: SELECT ''LEGAL_ENTITY_ID'' column_name,
12980: ''Calendar Code: ''|| calendar_code parameters,
12981: count(*) records
12982: FROM cm_rlup_ctl
12983: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12984: GROUP BY calendar_code
12985: HAVING count(*) > 0
12986: UNION

Line 12990: FROM cm_rlup_ctl a, ic_item_mst b

12986: UNION
12987: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12988: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12989: count(*) records
12990: FROM cm_rlup_ctl a, ic_item_mst b
12991: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12992: AND b.item_id = a.item_id
12993: GROUP BY b.item_no, a.legal_entity_id
12994: HAVING count(*) > 0

Line 12999: FROM cm_rlup_ctl a, ic_item_mst b

12995: UNION
12996: SELECT ''INVENTORY_ITEM_ID'' column_name,
12997: ''Item No: ''|| b.item_no parameters,
12998: count(*) records
12999: FROM cm_rlup_ctl a, ic_item_mst b
13000: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
13001: AND b.item_id = a.item_id
13002: GROUP BY b.item_no
13003: HAVING count(*) > 0

Line 13004: ) cm_rlup_ctl';

13000: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
13001: AND b.item_id = a.item_id
13002: GROUP BY b.item_no
13003: HAVING count(*) > 0
13004: ) cm_rlup_ctl';
13005: l_cm_rlup_itm VARCHAR2(32000) := 'SELECT ''CM_RLUP_ITM'' table_name,
13006: cm_rlup_itm.*
13007: FROM (
13008: SELECT ''ORGANIZATION_ID'' column_name,

Line 13011: FROM cm_rlup_ctl a, ic_item_mst b, cm_rlup_ctl c

13007: FROM (
13008: SELECT ''ORGANIZATION_ID'' column_name,
13009: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||c.legal_entity_id parameters,
13010: count(*) records
13011: FROM cm_rlup_ctl a, ic_item_mst b, cm_rlup_ctl c
13012: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
13013: AND b.item_id = a.item_id
13014: AND c.rollup_id = a.rollup_id
13015: GROUP BY b.item_no, c.legal_entity_id

Line 13874: * Migration Error Logging for table CM_RLUP_CTL *

13870: FROM cm_acpr_ctl;
13871: END IF;
13872: END IF;
13873: /************************************************
13874: * Migration Error Logging for table CM_RLUP_CTL *
13875: ************************************************/
13876: IF l_table_name IN ('CM_RLUP_CTL') THEN
13877: IF p_log_level = 1 THEN
13878: l_sql_statement := l_sql_statement

Line 13876: IF l_table_name IN ('CM_RLUP_CTL') THEN

13872: END IF;
13873: /************************************************
13874: * Migration Error Logging for table CM_RLUP_CTL *
13875: ************************************************/
13876: IF l_table_name IN ('CM_RLUP_CTL') THEN
13877: IF p_log_level = 1 THEN
13878: l_sql_statement := l_sql_statement
13879: ||
13880: '( (calendar_code is not null and period_code is not null and period_id is null)

Line 13898: FROM cm_rlup_ctl;

13894: l_cost_type_count,
13895: l_legal_entity_count,
13896: l_inventory_item_count,
13897: l_master_organization_count
13898: FROM cm_rlup_ctl;
13899: END IF;
13900: END IF;
13901: /************************************************
13902: * Migration Error Logging for table CM_RLUP_ITM *

Line 14046: ELSIF l_table_name = 'CM_RLUP_CTL' THEN

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;
14048: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14049: CLOSE cur_gmf_log_errors;
14050: ELSIF l_table_name = 'CM_RLUP_ITM' THEN

Line 14047: OPEN cur_gmf_log_errors FOR l_cm_rlup_ctl;

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;
14048: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14049: CLOSE cur_gmf_log_errors;
14050: ELSIF l_table_name = 'CM_RLUP_ITM' THEN
14051: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;