APPS.GMF_MIGRATION dependencies on CM_RLUP_ITM

Line 11142: G_Table_name := 'CM_RLUP_ITM';

11138: p_from_rowid => NULL,
11139: p_to_rowid => NULL
11140: );
11141:
11142: G_Table_name := 'CM_RLUP_ITM';
11143: G_Context := 'Rollup Items Migration';
11144: X_failure_count := 0;
11145:
11146: /********************************

Line 11162: * Update row in CM_RLUP_ITM table *

11158: p_app_short_name => 'GMA'
11159: );
11160:
11161: /**********************************
11162: * Update row in CM_RLUP_ITM table *
11163: ***********************************/
11164:
11165: BEGIN
11166:

Line 11167: UPDATE cm_rlup_itm a

11163: ***********************************/
11164:
11165: BEGIN
11166:
11167: UPDATE cm_rlup_itm a
11168: SET (
11169: a.organization_id,
11170: a.inventory_item_id
11171: )

Line 12674: l_cm_rlup_itm VARCHAR2(32000) := 'SELECT ''CM_RLUP_ITM'' table_name,

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,
12678: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||c.legal_entity_id parameters,

Line 12675: cm_rlup_itm.*

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,
12678: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||c.legal_entity_id parameters,
12679: count(*) records

Line 12690: FROM cm_rlup_itm a, ic_item_mst b

12686: UNION
12687: SELECT ''INVENTORY_ITEM_ID'' column_name,
12688: ''Item No: ''|| b.item_no parameters,
12689: count(*) records
12690: FROM cm_rlup_itm a, ic_item_mst b
12691: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12692: AND b.item_id = a.item_id
12693: GROUP BY b.item_no
12694: HAVING count(*) > 0

Line 12695: ) cm_rlup_itm';

12691: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12692: AND b.item_id = a.item_id
12693: GROUP BY b.item_no
12694: HAVING count(*) > 0
12695: ) cm_rlup_itm';
12696: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
12697: cm_cupd_ctl.*
12698: FROM (
12699: SELECT ''COST_TYPE_ID'' column_name,

Line 13571: * Migration Error Logging for table CM_RLUP_ITM *

13567: FROM cm_rlup_ctl;
13568: END IF;
13569: END IF;
13570: /************************************************
13571: * Migration Error Logging for table CM_RLUP_ITM *
13572: ************************************************/
13573: IF l_table_name IN ('CM_RLUP_ITM') THEN
13574: IF p_log_level = 1 THEN
13575: l_sql_statement := l_sql_statement

Line 13573: IF l_table_name IN ('CM_RLUP_ITM') THEN

13569: END IF;
13570: /************************************************
13571: * Migration Error Logging for table CM_RLUP_ITM *
13572: ************************************************/
13573: IF l_table_name IN ('CM_RLUP_ITM') THEN
13574: IF p_log_level = 1 THEN
13575: l_sql_statement := l_sql_statement
13576: ||
13577: '( (inventory_item_id is null and item_id is not null)

Line 13586: FROM cm_rlup_itm;

13582: SELECT SUM(CASE WHEN (inventory_item_id IS NULL AND item_id IS NOT NULL) THEN 1 ELSE 0 END),
13583: SUM(CASE WHEN (organization_id IS NULL AND item_id IS NOT NULL) THEN 1 ELSE 0 END)
13584: INTO l_inventory_item_count,
13585: l_master_organization_count
13586: FROM cm_rlup_itm;
13587: END IF;
13588: END IF;
13589: /************************************************
13590: * Migration Error Logging for table CM_CUPD_CTL *

Line 13719: ELSIF l_table_name = 'CM_RLUP_ITM' THEN

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;
13721: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13722: CLOSE cur_gmf_log_errors;
13723: ELSIF l_table_name = 'CM_CUPD_CTL' THEN

Line 13720: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;

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;
13721: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13722: CLOSE cur_gmf_log_errors;
13723: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
13724: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;