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 GMF_LOT_COSTED_ITEMS

Line 4682: G_Table_name := 'GMF_LOT_COSTED_ITEMS';

4678:
4679: BEGIN
4680:
4681: G_Migration_run_id := P_migration_run_id;
4682: G_Table_name := 'GMF_LOT_COSTED_ITEMS';
4683: G_Context := 'Lot Costed Items Migration';
4684: X_failure_count := 0;
4685:
4686: /********************************

Line 4707: UPDATE gmf_lot_costed_items a

4703: /***************************************************************
4704: * Update a row for cost Types, LE, Organization Id and Item Id *
4705: ***************************************************************/
4706:
4707: UPDATE gmf_lot_costed_items a
4708: SET a.cost_type_id
4709: = (
4710: SELECT x.cost_Type_id
4711: FROM cm_mthd_mst x

Line 4770: UPDATE gmf_lot_costed_items a

4766: /***************************************************************
4767: * Update a row for Master_Organization Id and Item Id *
4768: ***************************************************************/
4769:
4770: UPDATE gmf_lot_costed_items a
4771: SET (
4772: a.master_organization_id,
4773: a.inventory_item_id
4774: )

Line 10659: FROM gmf_lot_costed_items a,

10655: AND a.whse_code = b.whse_code
10656: UNION
10657: SELECT a.item_id,
10658: DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
10659: FROM gmf_lot_costed_items a,
10660: sy_orgn_mst b,
10661: ic_whse_mst c
10662: WHERE a.item_id IS NOT NULL
10663: AND a.co_code = b.co_Code

Line 12405: l_gmf_lot_costed_items VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTED_ITEMS'' table_name,

12401: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12402: GROUP BY lot_id
12403: HAVING count(*) > 0
12404: ) gmf_lot_costs';
12405: l_gmf_lot_costed_items VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTED_ITEMS'' table_name,
12406: gmf_lot_costed_items.*
12407: FROM (
12408: SELECT ''LEGAL_ENTITY_ID'' column_name,
12409: ''Co Code: ''|| co_code parameters,

Line 12406: gmf_lot_costed_items.*

12402: GROUP BY lot_id
12403: HAVING count(*) > 0
12404: ) gmf_lot_costs';
12405: l_gmf_lot_costed_items VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTED_ITEMS'' table_name,
12406: gmf_lot_costed_items.*
12407: FROM (
12408: SELECT ''LEGAL_ENTITY_ID'' column_name,
12409: ''Co Code: ''|| co_code parameters,
12410: count(*) records

Line 12411: FROM gmf_lot_costed_items

12407: FROM (
12408: SELECT ''LEGAL_ENTITY_ID'' column_name,
12409: ''Co Code: ''|| co_code parameters,
12410: count(*) records
12411: FROM gmf_lot_costed_items
12412: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
12413: GROUP BY co_code
12414: HAVING count(*) > 0
12415: UNION

Line 12419: FROM gmf_lot_costed_items a, ic_item_mst b

12415: UNION
12416: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12417: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12418: count(*) records
12419: FROM gmf_lot_costed_items a, ic_item_mst b
12420: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12421: AND b.item_id = a.item_id
12422: GROUP BY b.item_no, a.legal_entity_id
12423: HAVING count(*) > 0

Line 12428: FROM gmf_lot_costed_items a, ic_item_mst b

12424: UNION
12425: SELECT ''INVENTORY_ITEM_ID'' column_name,
12426: ''Item No: ''|| b.item_no parameters,
12427: count(*) records
12428: FROM gmf_lot_costed_items a, ic_item_mst b
12429: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12430: AND b.item_id = a.item_id
12431: GROUP BY b.item_no
12432: HAVING count(*) > 0

Line 12437: FROM gmf_lot_costed_items

12433: UNION
12434: SELECT ''COST_TYPE_ID'' column_name,
12435: ''Cost Method Code: ''|| cost_mthd_code parameters,
12436: count(*) records
12437: FROM gmf_lot_costed_items
12438: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12439: GROUP BY cost_mthd_code
12440: HAVING count(*) > 0
12441: ) gmf_lot_costed_items';

Line 12441: ) gmf_lot_costed_items';

12437: FROM gmf_lot_costed_items
12438: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12439: GROUP BY cost_mthd_code
12440: HAVING count(*) > 0
12441: ) gmf_lot_costed_items';
12442: l_gmf_lot_cost_burdens VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_BURDENS'' table_name,
12443: gmf_lot_cost_burdens.*
12444: FROM (
12445: SELECT ''ORGANIZATION_ID'' column_name,

Line 13390: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *

13386: FROM gmf_lot_costs;
13387: END IF;
13388: END IF;
13389: /*********************************************************
13390: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *
13391: *********************************************************/
13392: IF l_table_name IN ('GMF_LOT_COSTED_ITEMS') THEN
13393: IF p_log_level = 1 THEN
13394: l_sql_statement := l_sql_statement

Line 13392: IF l_table_name IN ('GMF_LOT_COSTED_ITEMS') THEN

13388: END IF;
13389: /*********************************************************
13390: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *
13391: *********************************************************/
13392: IF l_table_name IN ('GMF_LOT_COSTED_ITEMS') THEN
13393: IF p_log_level = 1 THEN
13394: l_sql_statement := l_sql_statement
13395: ||
13396: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13411: FROM gmf_lot_costed_items;

13407: INTO l_master_organization_count,
13408: l_inventory_item_count,
13409: l_cost_type_count,
13410: l_legal_entity_count
13411: FROM gmf_lot_costed_items;
13412: END IF;
13413: END IF;
13414: /*********************************************************
13415: * Migration Error Logging for table GMF_LOT_COST_BURDENS *

Line 13691: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN

13687: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN
13688: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;
13689: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13690: CLOSE cur_gmf_log_errors;
13691: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN
13692: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;
13693: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13694: CLOSE cur_gmf_log_errors;
13695: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN

Line 13692: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;

13688: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;
13689: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13690: CLOSE cur_gmf_log_errors;
13691: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN
13692: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;
13693: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13694: CLOSE cur_gmf_log_errors;
13695: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN
13696: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_burdens;