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 10335: * data in CM_WHSE_SRC *

10331: * Migrate_source_Warehouses *
10332: * *
10333: * DESCRIPTION: *
10334: * This PL/SQL procedure is used to transform the Source Warehouses *
10335: * data in CM_WHSE_SRC *
10336: * *
10337: * PARAMETERS: *
10338: * P_migration_run_id - id to use to right to migration log *
10339: * x_exception_count - Number of exceptions occurred. *

Line 10369: G_Table_name := 'CM_WHSE_SRC';

10365:
10366: BEGIN
10367:
10368: G_Migration_run_id := P_migration_run_id;
10369: G_Table_name := 'CM_WHSE_SRC';
10370: G_Context := 'Source Warehouses Migration';
10371: X_failure_count := 0;
10372:
10373: /********************************

Line 10392: UPDATE cm_whse_src a

10388: /***********************************************
10389: * Update rows For Source Warehouses *
10390: ***********************************************/
10391:
10392: UPDATE cm_whse_src a
10393: SET (
10394: a.organization_id,
10395: a.legal_entity_id,
10396: a.delete_mark

Line 10413: UPDATE cm_whse_src a

10409: WHERE (a.legal_entity_id IS NULL AND a.orgn_code IS NOT NULL)
10410: OR (a.organization_id IS NULL AND a.orgn_code IS NOT NULL)
10411: OR (a.source_organization_id IS NULL AND a.whse_code IS NOT NULL);
10412:
10413: UPDATE cm_whse_src a
10414: SET (
10415: a.master_organization_id,
10416: a.inventory_item_id
10417: )

Line 10441: INTO cm_whse_src

10437: * Insert records for Warehouses falling under OPM Organizations not migrated as Inventory Organizations *
10438: ********************************************************************************************************/
10439:
10440: INSERT
10441: INTO cm_whse_src
10442: (
10443: src_whse_id,
10444: calendar_code,
10445: period_code,

Line 10482: FROM cm_whse_src a,

10478: e.mtl_organization_id,
10479: a.source_organization_id,
10480: a.master_organization_id,
10481: a.legal_entity_id
10482: FROM cm_whse_src a,
10483: ic_whse_mst e
10484: WHERE NOT EXISTS (
10485: SELECT 'X'
10486: FROM cm_whse_src x

Line 10486: FROM cm_whse_src x

10482: FROM cm_whse_src a,
10483: ic_whse_mst e
10484: WHERE NOT EXISTS (
10485: SELECT 'X'
10486: FROM cm_whse_src x
10487: WHERE x.legal_entity_id = a.legal_entity_id
10488: AND nvl(x.organization_id, -1) = nvl(e.mtl_organization_id, -1)
10489: AND x.calendar_code = a.calendar_code
10490: AND x.period_code = a.period_code

Line 10643: FROM cm_whse_src a,

10639: AND a.whse_code = b.whse_code
10640: UNION
10641: SELECT a.item_id,
10642: 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
10643: FROM cm_whse_src a,
10644: ic_whse_mst b,
10645: ic_whse_mst c
10646: WHERE a.item_id IS NOT NULL
10647: AND b.orgn_code = a.orgn_code

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

12553: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12554: GROUP BY cost_trans_uom
12555: HAVING count(*) > 0
12556: ) gmf_material_lot_cost_txns';
12557: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12558: cm_whse_src.*
12559: FROM (
12560: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12561: ''Warehouse Code: ''|| whse_code parameters,

Line 12558: cm_whse_src.*

12554: GROUP BY cost_trans_uom
12555: HAVING count(*) > 0
12556: ) gmf_material_lot_cost_txns';
12557: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12558: cm_whse_src.*
12559: FROM (
12560: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12561: ''Warehouse Code: ''|| whse_code parameters,
12562: count(*) records

Line 12563: FROM cm_whse_src

12559: FROM (
12560: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,
12561: ''Warehouse Code: ''|| whse_code parameters,
12562: count(*) records
12563: FROM cm_whse_src
12564: WHERE (source_organization_id IS NULL AND whse_code IS NOT NULL)
12565: GROUP BY whse_code
12566: HAVING count(*) > 0
12567: UNION

Line 12571: FROM cm_whse_src

12567: UNION
12568: SELECT ''ORGANIZATION_ID'' column_name,
12569: ''Orgn Code: ''|| orgn_code parameters,
12570: count(*) records
12571: FROM cm_whse_src
12572: WHERE (organization_id IS NULL AND orgn_code IS NOT NULL AND delete_mark = 0)
12573: GROUP BY orgn_code
12574: HAVING count(*) > 0
12575: UNION

Line 12579: FROM cm_whse_src a, ic_item_mst b

12575: UNION
12576: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12577: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12578: count(*) records
12579: FROM cm_whse_src a, ic_item_mst b
12580: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12581: AND b.item_id = a.item_id
12582: GROUP BY b.item_no, a.legal_entity_id
12583: HAVING count(*) > 0

Line 12588: FROM cm_whse_src a, ic_item_mst b

12584: UNION
12585: SELECT ''INVENTORY_ITEM_ID'' column_name,
12586: ''Item No: ''|| b.item_no parameters,
12587: count(*) records
12588: FROM cm_whse_src a, ic_item_mst b
12589: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12590: AND b.item_id = a.item_id
12591: GROUP BY b.item_no
12592: HAVING count(*) > 0

Line 12597: FROM cm_whse_src

12593: UNION
12594: SELECT ''LEGAL_ENTITY_ID'' column_name,
12595: ''Orgn Code: ''|| orgn_code parameters,
12596: count(*) records
12597: FROM cm_whse_src
12598: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12599: GROUP BY orgn_code
12600: HAVING count(*) > 0
12601: ) cm_whse_src';

Line 12601: ) cm_whse_src';

12597: FROM cm_whse_src
12598: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12599: GROUP BY orgn_code
12600: HAVING count(*) > 0
12601: ) cm_whse_src';
12602: l_cm_acpr_ctl VARCHAR2(32000) := 'SELECT ''CM_ACPR_CTL'' table_name,
12603: cm_acpr_ctl.*
12604: FROM (
12605: SELECT ''COST_TYPE_ID'' column_name,

Line 13493: * Migration Error Logging for table CM_WHSE_SRC *

13489: FROM gmf_material_lot_cost_txns;
13490: END IF;
13491: END IF;
13492: /************************************************
13493: * Migration Error Logging for table CM_WHSE_SRC *
13494: ************************************************/
13495: IF l_table_name IN ('CM_WHSE_SRC') THEN
13496: IF p_log_level = 1 THEN
13497: l_sql_statement := l_sql_statement

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

13491: END IF;
13492: /************************************************
13493: * Migration Error Logging for table CM_WHSE_SRC *
13494: ************************************************/
13495: IF l_table_name IN ('CM_WHSE_SRC') THEN
13496: IF p_log_level = 1 THEN
13497: l_sql_statement := l_sql_statement
13498: ||
13499: '( (legal_entity_id IS NULL AND orgn_code IS NOT NULL)

Line 13517: FROM cm_whse_src;

13513: l_inventory_item_count,
13514: l_organization_count,
13515: l_legal_entity_count,
13516: l_master_organization_count
13517: FROM cm_whse_src;
13518: END IF;
13519: END IF;
13520: /************************************************
13521: * Migration Error Logging for table CM_ACPR_CTL *

Line 13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN

13703: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN
13704: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;
13705: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13706: CLOSE cur_gmf_log_errors;
13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
13709: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13710: CLOSE cur_gmf_log_errors;
13711: ELSIF l_table_name = 'CM_ACPR_CTL' THEN

Line 13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;

13704: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;
13705: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13706: CLOSE cur_gmf_log_errors;
13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;
13709: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13710: CLOSE cur_gmf_log_errors;
13711: ELSIF l_table_name = 'CM_ACPR_CTL' THEN
13712: OPEN cur_gmf_log_errors FOR l_cm_acpr_ctl;