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_WHSE_SRC

Line 10664: * data in CM_WHSE_SRC *

10660: * Migrate_source_Warehouses *
10661: * *
10662: * DESCRIPTION: *
10663: * This PL/SQL procedure is used to transform the Source Warehouses *
10664: * data in CM_WHSE_SRC *
10665: * *
10666: * PARAMETERS: *
10667: * P_migration_run_id - id to use to right to migration log *
10668: * x_exception_count - Number of exceptions occurred. *

Line 10698: G_Table_name := 'CM_WHSE_SRC';

10694:
10695: BEGIN
10696:
10697: G_Migration_run_id := P_migration_run_id;
10698: G_Table_name := 'CM_WHSE_SRC';
10699: G_Context := 'Source Warehouses Migration';
10700: X_failure_count := 0;
10701:
10702: /********************************

Line 10721: UPDATE cm_whse_src a

10717: /***********************************************
10718: * Update rows For Source Warehouses *
10719: ***********************************************/
10720:
10721: UPDATE cm_whse_src a
10722: SET (
10723: a.organization_id,
10724: a.legal_entity_id,
10725: a.delete_mark

Line 10742: UPDATE cm_whse_src a

10738: WHERE (a.legal_entity_id IS NULL AND a.orgn_code IS NOT NULL)
10739: OR (a.organization_id IS NULL AND a.orgn_code IS NOT NULL)
10740: OR (a.source_organization_id IS NULL AND a.whse_code IS NOT NULL);
10741:
10742: UPDATE cm_whse_src a
10743: SET (
10744: a.master_organization_id,
10745: a.inventory_item_id
10746: )

Line 10770: INTO cm_whse_src

10766: * Insert records for Warehouses falling under OPM Organizations not migrated as Inventory Organizations *
10767: ********************************************************************************************************/
10768:
10769: INSERT
10770: INTO cm_whse_src
10771: (
10772: src_whse_id,
10773: calendar_code,
10774: period_code,

Line 10811: FROM cm_whse_src a,

10807: e.mtl_organization_id,
10808: a.source_organization_id,
10809: a.master_organization_id,
10810: a.legal_entity_id
10811: FROM cm_whse_src a,
10812: ic_whse_mst e
10813: WHERE NOT EXISTS (
10814: SELECT 'X'
10815: FROM cm_whse_src x

Line 10815: FROM cm_whse_src x

10811: FROM cm_whse_src a,
10812: ic_whse_mst e
10813: WHERE NOT EXISTS (
10814: SELECT 'X'
10815: FROM cm_whse_src x
10816: WHERE x.legal_entity_id = a.legal_entity_id
10817: AND nvl(x.organization_id, -1) = nvl(e.mtl_organization_id, -1)
10818: AND x.calendar_code = a.calendar_code
10819: AND x.period_code = a.period_code

Line 10973: FROM cm_whse_src a,

10969: AND a.whse_code = b.whse_code
10970: UNION
10971: SELECT a.item_id,
10972: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
10973: FROM cm_whse_src a,
10974: ic_whse_mst b,
10975: ic_whse_mst c
10976: WHERE a.item_id IS NOT NULL
10977: AND b.orgn_code = a.orgn_code

Line 12888: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,

12884: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12885: GROUP BY cost_trans_uom
12886: HAVING count(*) > 0
12887: ) gmf_material_lot_cost_txns';
12888: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12889: cm_whse_src.*
12890: FROM (
12891: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12892: ''Warehouse Code: ''|| whse_code parameters,

Line 12889: cm_whse_src.*

12885: GROUP BY cost_trans_uom
12886: HAVING count(*) > 0
12887: ) gmf_material_lot_cost_txns';
12888: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12889: cm_whse_src.*
12890: FROM (
12891: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12892: ''Warehouse Code: ''|| whse_code parameters,
12893: count(*) records

Line 12894: FROM cm_whse_src

12890: FROM (
12891: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12892: ''Warehouse Code: ''|| whse_code parameters,
12893: count(*) records
12894: FROM cm_whse_src
12895: WHERE (source_organization_id IS NULL AND whse_code IS NOT NULL)
12896: GROUP BY whse_code
12897: HAVING count(*) > 0
12898: UNION

Line 12902: FROM cm_whse_src

12898: UNION
12899: SELECT ''ORGANIZATION_ID'' column_name,
12900: ''Orgn Code: ''|| orgn_code parameters,
12901: count(*) records
12902: FROM cm_whse_src
12903: WHERE (organization_id IS NULL AND orgn_code IS NOT NULL AND delete_mark = 0)
12904: GROUP BY orgn_code
12905: HAVING count(*) > 0
12906: UNION

Line 12910: FROM cm_whse_src a, ic_item_mst b

12906: UNION
12907: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12908: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12909: count(*) records
12910: FROM cm_whse_src a, ic_item_mst b
12911: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12912: AND b.item_id = a.item_id
12913: GROUP BY b.item_no, a.legal_entity_id
12914: HAVING count(*) > 0

Line 12919: FROM cm_whse_src a, ic_item_mst b

12915: UNION
12916: SELECT ''INVENTORY_ITEM_ID'' column_name,
12917: ''Item No: ''|| b.item_no parameters,
12918: count(*) records
12919: FROM cm_whse_src a, ic_item_mst b
12920: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12921: AND b.item_id = a.item_id
12922: GROUP BY b.item_no
12923: HAVING count(*) > 0

Line 12928: FROM cm_whse_src

12924: UNION
12925: SELECT ''LEGAL_ENTITY_ID'' column_name,
12926: ''Orgn Code: ''|| orgn_code parameters,
12927: count(*) records
12928: FROM cm_whse_src
12929: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12930: GROUP BY orgn_code
12931: HAVING count(*) > 0
12932: ) cm_whse_src';

Line 12932: ) cm_whse_src';

12928: FROM cm_whse_src
12929: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12930: GROUP BY orgn_code
12931: HAVING count(*) > 0
12932: ) cm_whse_src';
12933: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12934: cm_acpr_ctl.*
12935: FROM (
12936: SELECT ''COST_TYPE_ID'' column_name,

Line 13824: * Migration Error Logging for table CM_WHSE_SRC *

13820: FROM gmf_material_lot_cost_txns;
13821: END IF;
13822: END IF;
13823: /************************************************
13824: * Migration Error Logging for table CM_WHSE_SRC *
13825: ************************************************/
13826: IF l_table_name IN ('CM_WHSE_SRC') THEN
13827: IF p_log_level = 1 THEN
13828: l_sql_statement := l_sql_statement

Line 13826: IF l_table_name IN ('CM_WHSE_SRC') THEN

13822: END IF;
13823: /************************************************
13824: * Migration Error Logging for table CM_WHSE_SRC *
13825: ************************************************/
13826: IF l_table_name IN ('CM_WHSE_SRC') THEN
13827: IF p_log_level = 1 THEN
13828: l_sql_statement := l_sql_statement
13829: ||
13830: '( (legal_entity_id IS NULL AND orgn_code IS NOT NULL)

Line 13848: FROM cm_whse_src;

13844: l_inventory_item_count,
13845: l_organization_count,
13846: l_legal_entity_count,
13847: l_master_organization_count
13848: FROM cm_whse_src;
13849: END IF;
13850: END IF;
13851: /************************************************
13852: * Migration Error Logging for table CM_ACPR_CTL *

Line 14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN

14034: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN
14035: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;
14036: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14037: CLOSE cur_gmf_log_errors;
14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
14040: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14041: CLOSE cur_gmf_log_errors;
14042: ELSIF l_table_name = 'CM_ACPR_CTL' THEN

Line 14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;

14035: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;
14036: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14037: CLOSE cur_gmf_log_errors;
14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
14040: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14041: CLOSE cur_gmf_log_errors;
14042: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
14043: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;