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_COSTS

Line 4181: G_Table_name := 'GMF_LOT_COSTS';

4177:
4178: BEGIN
4179:
4180: G_Migration_run_id := P_migration_run_id;
4181: G_Table_name := 'GMF_LOT_COSTS';
4182: G_Context := 'Lot Costs Migration';
4183: X_failure_count := 0;
4184:
4185: /********************************

Line 4206: UPDATE gmf_lot_costs a

4202: /******************************
4203: * Update a row for cost Types *
4204: ******************************/
4205:
4206: UPDATE gmf_lot_costs a
4207: SET a.cost_type_id
4208: = (
4209: SELECT x.cost_Type_id
4210: FROM cm_mthd_mst x

Line 4277: INSERT INTO gmf_lot_costs

4273: BEGIN
4274: /****************************************************************************
4275: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
4276: ****************************************************************************/
4277: INSERT INTO gmf_lot_costs
4278: (
4279: header_id,
4280: unit_cost,
4281: cost_date,

Line 4377: FROM gmf_lot_costs a,

4373: a.cost_type_id,
4374: a.inventory_item_id,
4375: b.lot_number,
4376: a.organization_id
4377: FROM gmf_lot_costs a,
4378: ic_lots_mst_mig b
4379: WHERE a.lot_id = b.lot_id
4380: AND nvl(b.additional_status_lot,0) = 1
4381: AND (

Line 4389: FROM gmf_lot_costs x

4385: OR (a.lot_number IS NOT NULL AND a.lot_id IS NOT NULL)
4386: )
4387: AND NOT EXISTS (
4388: SELECT 'RECORD_ALREADY_EXISTS'
4389: FROM gmf_lot_costs x
4390: WHERE x.organization_id = a.organization_id
4391: AND x.inventory_item_id = a.inventory_item_id
4392: AND x.cost_type_id = a.cost_type_id
4393: AND x.lot_number = b.lot_number

Line 4536: gmf_lot_costs b

4532: a.detail_id,
4533: a.delete_mark,
4534: a.final_cost_flag
4535: FROM gmf_lot_cost_details a,
4536: gmf_lot_costs b
4537: WHERE a.header_id = b.text_code
4538: AND b.text_code IS NOT NULL
4539: AND (
4540: (b.cost_type_id IS NOT NULL AND b.cost_mthd_code IS NULL)

Line 10669: FROM gmf_lot_Costs a,

10665: AND nvl(c.subinventory_ind_flag,'N') <> 'Y'
10666: UNION
10667: SELECT a.item_id,
10668: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10669: FROM gmf_lot_Costs a,
10670: ic_whse_mst b
10671: WHERE a.item_id IS NOT NULL
10672: AND a.whse_code = b.whse_code
10673: UNION

Line 12369: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,

12365: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12366: GROUP BY calendar_code, period_code
12367: HAVING count(*) > 0
12368: ) cm_acst_led';
12369: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12370: gmf_lot_costs.*
12371: FROM (
12372: SELECT ''ORGANIZATION_ID'' column_name,
12373: ''Warehouse Code: ''|| whse_code parameters,

Line 12370: gmf_lot_costs.*

12366: GROUP BY calendar_code, period_code
12367: HAVING count(*) > 0
12368: ) cm_acst_led';
12369: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12370: gmf_lot_costs.*
12371: FROM (
12372: SELECT ''ORGANIZATION_ID'' column_name,
12373: ''Warehouse Code: ''|| whse_code parameters,
12374: count(*) records

Line 12375: FROM gmf_lot_costs

12371: FROM (
12372: SELECT ''ORGANIZATION_ID'' column_name,
12373: ''Warehouse Code: ''|| whse_code parameters,
12374: count(*) records
12375: FROM gmf_lot_costs
12376: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12377: GROUP BY whse_code
12378: HAVING count(*) > 0
12379: UNION

Line 12383: FROM gmf_lot_costs a, ic_item_mst b

12379: UNION
12380: SELECT ''INVENTORY_ITEM_ID'' column_name,
12381: ''Item No: ''|| b.item_no parameters,
12382: count(*) records
12383: FROM gmf_lot_costs a, ic_item_mst b
12384: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12385: AND b.item_id = a.item_id
12386: GROUP BY b.item_no
12387: HAVING count(*) > 0

Line 12392: FROM gmf_lot_costs

12388: UNION
12389: SELECT ''COST_TYPE_ID'' column_name,
12390: ''Cost Method Code: ''|| cost_mthd_code parameters,
12391: count(*) records
12392: FROM gmf_lot_costs
12393: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12394: GROUP BY cost_mthd_code
12395: HAVING count(*) > 0
12396: UNION

Line 12400: FROM gmf_lot_costs

12396: UNION
12397: SELECT ''LOT_NUMBER'' column_name,
12398: ''Lot Id: ''|| lot_id parameters,
12399: count(*) records
12400: FROM gmf_lot_costs
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';

Line 12404: ) gmf_lot_costs';

12400: FROM gmf_lot_costs
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,

Line 13365: * Migration Error Logging for table GMF_LOT_COSTS *

13361: FROM xla_line_assgns_t;
13362: END IF;
13363: END IF;
13364: /**************************************************
13365: * Migration Error Logging for table GMF_LOT_COSTS *
13366: **************************************************/
13367: IF l_table_name IN ('GMF_LOT_COSTS') THEN
13368: IF p_log_level = 1 THEN
13369: l_sql_statement := l_sql_statement

Line 13367: IF l_table_name IN ('GMF_LOT_COSTS') THEN

13363: END IF;
13364: /**************************************************
13365: * Migration Error Logging for table GMF_LOT_COSTS *
13366: **************************************************/
13367: IF l_table_name IN ('GMF_LOT_COSTS') THEN
13368: IF p_log_level = 1 THEN
13369: l_sql_statement := l_sql_statement
13370: ||
13371: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13386: FROM gmf_lot_costs;

13382: INTO l_organization_count,
13383: l_inventory_item_count,
13384: l_cost_type_count,
13385: l_lot_number_count
13386: FROM gmf_lot_costs;
13387: END IF;
13388: END IF;
13389: /*********************************************************
13390: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *

Line 13687: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN

13683: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN
13684: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;
13685: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13686: CLOSE cur_gmf_log_errors;
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

Line 13688: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;

13684: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;
13685: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13686: CLOSE cur_gmf_log_errors;
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;