APPS.GMF_MIGRATION dependencies on CM_RLUP_ITM

Line 11473: G_Table_name := 'CM_RLUP_ITM';

11469: p_from_rowid => NULL,
11470: p_to_rowid => NULL
11471: );
11472:
11473: G_Table_name := 'CM_RLUP_ITM';
11474: G_Context := 'Rollup Items Migration';
11475: X_failure_count := 0;
11476:
11477: /********************************

Line 11493: * Update row in CM_RLUP_ITM table *

11489: p_app_short_name => 'GMA'
11490: );
11491:
11492: /**********************************
11493: * Update row in CM_RLUP_ITM table *
11494: ***********************************/
11495:
11496: BEGIN
11497:

Line 11498: UPDATE cm_rlup_itm a

11494: ***********************************/
11495:
11496: BEGIN
11497:
11498: UPDATE cm_rlup_itm a
11499: SET (
11500: a.organization_id,
11501: a.inventory_item_id
11502: )

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

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

Line 13006: cm_rlup_itm.*

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

Line 13021: FROM cm_rlup_itm a, ic_item_mst b

13017: UNION
13018: SELECT ''INVENTORY_ITEM_ID'' column_name,
13019: ''Item No: ''|| b.item_no parameters,
13020: count(*) records
13021: FROM cm_rlup_itm a, ic_item_mst b
13022: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
13023: AND b.item_id = a.item_id
13024: GROUP BY b.item_no
13025: HAVING count(*) > 0

Line 13026: ) cm_rlup_itm';

13022: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
13023: AND b.item_id = a.item_id
13024: GROUP BY b.item_no
13025: HAVING count(*) > 0
13026: ) cm_rlup_itm';
13027: l_cm_cupd_ctl VARCHAR2(32000) := 'SELECT ''CM_CUPD_CTL'' table_name,
13028: cm_cupd_ctl.*
13029: FROM (
13030: SELECT ''COST_TYPE_ID'' column_name,

Line 13902: * Migration Error Logging for table CM_RLUP_ITM *

13898: FROM cm_rlup_ctl;
13899: END IF;
13900: END IF;
13901: /************************************************
13902: * Migration Error Logging for table CM_RLUP_ITM *
13903: ************************************************/
13904: IF l_table_name IN ('CM_RLUP_ITM') THEN
13905: IF p_log_level = 1 THEN
13906: l_sql_statement := l_sql_statement

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

13900: END IF;
13901: /************************************************
13902: * Migration Error Logging for table CM_RLUP_ITM *
13903: ************************************************/
13904: IF l_table_name IN ('CM_RLUP_ITM') THEN
13905: IF p_log_level = 1 THEN
13906: l_sql_statement := l_sql_statement
13907: ||
13908: '( (inventory_item_id is null and item_id is not null)

Line 13917: FROM cm_rlup_itm;

13913: SELECT SUM(CASE WHEN (inventory_item_id IS NULL AND item_id IS NOT NULL) THEN 1 ELSE 0 END),
13914: SUM(CASE WHEN (organization_id IS NULL AND item_id IS NOT NULL) THEN 1 ELSE 0 END)
13915: INTO l_inventory_item_count,
13916: l_master_organization_count
13917: FROM cm_rlup_itm;
13918: END IF;
13919: END IF;
13920: /************************************************
13921: * Migration Error Logging for table CM_CUPD_CTL *

Line 14050: ELSIF l_table_name = 'CM_RLUP_ITM' THEN

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;
14052: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14053: CLOSE cur_gmf_log_errors;
14054: ELSIF l_table_name = 'CM_CUPD_CTL' THEN

Line 14051: OPEN cur_gmf_log_errors FOR l_cm_rlup_itm;

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;
14052: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14053: CLOSE cur_gmf_log_errors;
14054: ELSIF l_table_name = 'CM_CUPD_CTL' THEN
14055: OPEN cur_gmf_log_errors FOR l_cm_cupd_ctl;