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 11019: G_Table_name := 'CM_RLUP_CTL';

11015:
11016: BEGIN
11017:
11018: G_Migration_run_id := P_migration_run_id;
11019: G_Table_name := 'CM_RLUP_CTL';
11020: G_Context := 'Rollup Control Record Migration';
11021: X_failure_count := 0;
11022:
11023: /********************************

Line 11039: * Update row in CM_RLUP_CTL table *

11035: p_app_short_name => 'GMA'
11036: );
11037:
11038: /**********************************
11039: * Update row in CM_RLUP_CTL table *
11040: ***********************************/
11041:
11042: BEGIN
11043:

Line 11044: UPDATE cm_rlup_ctl crc

11040: ***********************************/
11041:
11042: BEGIN
11043:
11044: UPDATE cm_rlup_ctl crc
11045: SET (
11046: crc.legal_entity_id,
11047: crc.period_id,
11048: crc.cost_type_id

Line 11071: UPDATE cm_rlup_ctl a

11067: WHERE (crc.CALENDAR_CODE IS NOT NULL AND crc.PERIOD_CODE IS NOT NULL AND crc.PERIOD_ID IS NULL)
11068: OR (crc.COST_MTHD_CODE IS NOT NULL AND crc.COST_TYPE_ID IS NULL)
11069: OR (crc.CALENDAR_CODE IS NOT NULL AND crc.LEGAL_ENTITY_ID IS NULL);
11070:
11071: UPDATE cm_rlup_ctl a
11072: SET (
11073: a.master_organization_id,
11074: a.inventory_item_id
11075: )

Line 11178: cm_rlup_ctl x

11174: y.inventory_item_id
11175: FROM ic_item_mst_b_mig y,
11176: mtl_parameters z,
11177: hr_organization_information hoi,
11178: cm_rlup_ctl x
11179: WHERE y.item_id = a.item_id
11180: AND y.organization_id = z.organization_id
11181: AND hoi.organization_id = z.organization_id
11182: AND hoi.org_information_context = 'Accounting Information'

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

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

Line 12630: cm_rlup_ctl.*

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

Line 12635: FROM cm_rlup_ctl

12631: FROM (
12632: SELECT ''COST_TYPE_ID'' column_name,
12633: ''Cost Method Code: ''|| cost_mthd_code parameters,
12634: count(*) records
12635: FROM cm_rlup_ctl
12636: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12637: GROUP BY cost_mthd_code
12638: HAVING count(*) > 0
12639: UNION

Line 12643: FROM cm_rlup_ctl

12639: UNION
12640: SELECT ''PERIOD_ID'' column_name,
12641: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12642: count(*) records
12643: FROM cm_rlup_ctl
12644: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12645: GROUP BY calendar_code, period_code
12646: HAVING count(*) > 0
12647: UNION

Line 12651: FROM cm_rlup_ctl

12647: UNION
12648: SELECT ''LEGAL_ENTITY_ID'' column_name,
12649: ''Calendar Code: ''|| calendar_code parameters,
12650: count(*) records
12651: FROM cm_rlup_ctl
12652: WHERE (legal_entity_id IS NULL AND calendar_code IS NOT NULL)
12653: GROUP BY calendar_code
12654: HAVING count(*) > 0
12655: UNION

Line 12659: FROM cm_rlup_ctl a, ic_item_mst b

12655: UNION
12656: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12657: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12658: count(*) records
12659: FROM cm_rlup_ctl a, ic_item_mst b
12660: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12661: AND b.item_id = a.item_id
12662: GROUP BY b.item_no, a.legal_entity_id
12663: HAVING count(*) > 0

Line 12668: FROM cm_rlup_ctl a, ic_item_mst b

12664: UNION
12665: SELECT ''INVENTORY_ITEM_ID'' column_name,
12666: ''Item No: ''|| b.item_no parameters,
12667: count(*) records
12668: FROM cm_rlup_ctl a, ic_item_mst b
12669: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12670: AND b.item_id = a.item_id
12671: GROUP BY b.item_no
12672: HAVING count(*) > 0

Line 12673: ) cm_rlup_ctl';

12669: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12670: AND b.item_id = a.item_id
12671: GROUP BY b.item_no
12672: HAVING count(*) > 0
12673: ) cm_rlup_ctl';
12674: l_cm_rlup_itm VARCHAR2(32000) := 'SELECT ''CM_RLUP_ITM'' table_name,
12675: cm_rlup_itm.*
12676: FROM (
12677: SELECT ''ORGANIZATION_ID'' column_name,

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

12676: FROM (
12677: SELECT ''ORGANIZATION_ID'' column_name,
12678: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||c.legal_entity_id parameters,
12679: count(*) records
12680: FROM cm_rlup_ctl a, ic_item_mst b, cm_rlup_ctl c
12681: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12682: AND b.item_id = a.item_id
12683: AND c.rollup_id = a.rollup_id
12684: GROUP BY b.item_no, c.legal_entity_id

Line 13543: * Migration Error Logging for table CM_RLUP_CTL *

13539: FROM cm_acpr_ctl;
13540: END IF;
13541: END IF;
13542: /************************************************
13543: * Migration Error Logging for table CM_RLUP_CTL *
13544: ************************************************/
13545: IF l_table_name IN ('CM_RLUP_CTL') THEN
13546: IF p_log_level = 1 THEN
13547: l_sql_statement := l_sql_statement

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

13541: END IF;
13542: /************************************************
13543: * Migration Error Logging for table CM_RLUP_CTL *
13544: ************************************************/
13545: IF l_table_name IN ('CM_RLUP_CTL') THEN
13546: IF p_log_level = 1 THEN
13547: l_sql_statement := l_sql_statement
13548: ||
13549: '( (calendar_code is not null and period_code is not null and period_id is null)

Line 13567: FROM cm_rlup_ctl;

13563: l_cost_type_count,
13564: l_legal_entity_count,
13565: l_inventory_item_count,
13566: l_master_organization_count
13567: FROM cm_rlup_ctl;
13568: END IF;
13569: END IF;
13570: /************************************************
13571: * Migration Error Logging for table CM_RLUP_ITM *

Line 13715: ELSIF l_table_name = 'CM_RLUP_CTL' THEN

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;
13717: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13718: CLOSE cur_gmf_log_errors;
13719: ELSIF l_table_name = 'CM_RLUP_ITM' THEN

Line 13716: OPEN cur_gmf_log_errors FOR l_cm_rlup_ctl;

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;
13717: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13718: CLOSE cur_gmf_log_errors;
13719: ELSIF l_table_name = 'CM_RLUP_ITM' THEN
13720: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;