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 4705: G_Table_name := 'GMF_LOT_COSTED_ITEMS';

4701:
4702: BEGIN
4703:
4704: G_Migration_run_id := P_migration_run_id;
4705: G_Table_name := 'GMF_LOT_COSTED_ITEMS';
4706: G_Context := 'Lot Costed Items Migration';
4707: X_failure_count := 0;
4708:
4709: /********************************

Line 4730: UPDATE gmf_lot_costed_items a

4726: /***************************************************************
4727: * Update a row for cost Types, LE, Organization Id and Item Id *
4728: ***************************************************************/
4729:
4730: UPDATE gmf_lot_costed_items a
4731: SET a.cost_type_id
4732: = (
4733: SELECT x.cost_Type_id
4734: FROM cm_mthd_mst x

Line 4793: UPDATE gmf_lot_costed_items a

4789: /***************************************************************
4790: * Update a row for Master_Organization Id and Item Id *
4791: ***************************************************************/
4792:
4793: UPDATE gmf_lot_costed_items a
4794: SET (
4795: a.master_organization_id,
4796: a.inventory_item_id
4797: )

Line 10989: FROM gmf_lot_costed_items a,

10985: AND a.whse_code = b.whse_code
10986: UNION
10987: SELECT a.item_id,
10988: DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
10989: FROM gmf_lot_costed_items a,
10990: sy_orgn_mst b,
10991: ic_whse_mst c
10992: WHERE a.item_id IS NOT NULL
10993: AND a.co_code = b.co_Code

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

12732: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12733: GROUP BY lot_id
12734: HAVING count(*) > 0
12735: ) gmf_lot_costs';
12736: l_gmf_lot_costed_items VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTED_ITEMS'' table_name,
12737: gmf_lot_costed_items.*
12738: FROM (
12739: SELECT ''LEGAL_ENTITY_ID'' column_name,
12740: ''Co Code: ''|| co_code parameters,

Line 12737: gmf_lot_costed_items.*

12733: GROUP BY lot_id
12734: HAVING count(*) > 0
12735: ) gmf_lot_costs';
12736: l_gmf_lot_costed_items VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTED_ITEMS'' table_name,
12737: gmf_lot_costed_items.*
12738: FROM (
12739: SELECT ''LEGAL_ENTITY_ID'' column_name,
12740: ''Co Code: ''|| co_code parameters,
12741: count(*) records

Line 12742: FROM gmf_lot_costed_items

12738: FROM (
12739: SELECT ''LEGAL_ENTITY_ID'' column_name,
12740: ''Co Code: ''|| co_code parameters,
12741: count(*) records
12742: FROM gmf_lot_costed_items
12743: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
12744: GROUP BY co_code
12745: HAVING count(*) > 0
12746: UNION

Line 12750: FROM gmf_lot_costed_items a, ic_item_mst b

12746: UNION
12747: SELECT ''MASTER_ORGANIZATION_ID'' column_name,
12748: ''Item No: ''|| b.item_no ||'' Legal Entity: ''||a.legal_entity_id parameters,
12749: count(*) records
12750: FROM gmf_lot_costed_items a, ic_item_mst b
12751: WHERE (a.legal_entity_id IS NULL AND a.item_id IS NOT NULL)
12752: AND b.item_id = a.item_id
12753: GROUP BY b.item_no, a.legal_entity_id
12754: HAVING count(*) > 0

Line 12759: FROM gmf_lot_costed_items a, ic_item_mst b

12755: UNION
12756: SELECT ''INVENTORY_ITEM_ID'' column_name,
12757: ''Item No: ''|| b.item_no parameters,
12758: count(*) records
12759: FROM gmf_lot_costed_items a, ic_item_mst b
12760: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12761: AND b.item_id = a.item_id
12762: GROUP BY b.item_no
12763: HAVING count(*) > 0

Line 12768: FROM gmf_lot_costed_items

12764: UNION
12765: SELECT ''COST_TYPE_ID'' column_name,
12766: ''Cost Method Code: ''|| cost_mthd_code parameters,
12767: count(*) records
12768: FROM gmf_lot_costed_items
12769: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12770: GROUP BY cost_mthd_code
12771: HAVING count(*) > 0
12772: ) gmf_lot_costed_items';

Line 12772: ) gmf_lot_costed_items';

12768: FROM gmf_lot_costed_items
12769: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12770: GROUP BY cost_mthd_code
12771: HAVING count(*) > 0
12772: ) gmf_lot_costed_items';
12773: l_gmf_lot_cost_burdens VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_BURDENS'' table_name,
12774: gmf_lot_cost_burdens.*
12775: FROM (
12776: SELECT ''ORGANIZATION_ID'' column_name,

Line 13721: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *

13717: FROM gmf_lot_costs;
13718: END IF;
13719: END IF;
13720: /*********************************************************
13721: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *
13722: *********************************************************/
13723: IF l_table_name IN ('GMF_LOT_COSTED_ITEMS') THEN
13724: IF p_log_level = 1 THEN
13725: l_sql_statement := l_sql_statement

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

13719: END IF;
13720: /*********************************************************
13721: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *
13722: *********************************************************/
13723: IF l_table_name IN ('GMF_LOT_COSTED_ITEMS') THEN
13724: IF p_log_level = 1 THEN
13725: l_sql_statement := l_sql_statement
13726: ||
13727: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13742: FROM gmf_lot_costed_items;

13738: INTO l_master_organization_count,
13739: l_inventory_item_count,
13740: l_cost_type_count,
13741: l_legal_entity_count
13742: FROM gmf_lot_costed_items;
13743: END IF;
13744: END IF;
13745: /*********************************************************
13746: * Migration Error Logging for table GMF_LOT_COST_BURDENS *

Line 14022: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN

14018: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN
14019: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;
14020: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14021: CLOSE cur_gmf_log_errors;
14022: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN
14023: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;
14024: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14025: CLOSE cur_gmf_log_errors;
14026: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN

Line 14023: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;

14019: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;
14020: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14021: CLOSE cur_gmf_log_errors;
14022: ELSIF l_table_name = 'GMF_LOT_COSTED_ITEMS' THEN
14023: OPEN cur_gmf_log_errors FOR l_gmf_lot_costed_items;
14024: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14025: CLOSE cur_gmf_log_errors;
14026: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN
14027: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_burdens;