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 4204: G_Table_name := 'GMF_LOT_COSTS';

4200:
4201: BEGIN
4202:
4203: G_Migration_run_id := P_migration_run_id;
4204: G_Table_name := 'GMF_LOT_COSTS';
4205: G_Context := 'Lot Costs Migration';
4206: X_failure_count := 0;
4207:
4208: /********************************

Line 4229: UPDATE gmf_lot_costs a

4225: /******************************
4226: * Update a row for cost Types *
4227: ******************************/
4228:
4229: UPDATE gmf_lot_costs a
4230: SET a.cost_type_id
4231: = (
4232: SELECT x.cost_Type_id
4233: FROM cm_mthd_mst x

Line 4300: INSERT INTO gmf_lot_costs

4296: BEGIN
4297: /****************************************************************************
4298: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
4299: ****************************************************************************/
4300: INSERT INTO gmf_lot_costs
4301: (
4302: header_id,
4303: unit_cost,
4304: cost_date,

Line 4400: FROM gmf_lot_costs a,

4396: a.cost_type_id,
4397: a.inventory_item_id,
4398: b.lot_number,
4399: a.organization_id
4400: FROM gmf_lot_costs a,
4401: ic_lots_mst_mig b
4402: WHERE a.lot_id = b.lot_id
4403: AND nvl(b.additional_status_lot,0) = 1
4404: AND (

Line 4412: FROM gmf_lot_costs x

4408: OR (a.lot_number IS NOT NULL AND a.lot_id IS NOT NULL)
4409: )
4410: AND NOT EXISTS (
4411: SELECT 'RECORD_ALREADY_EXISTS'
4412: FROM gmf_lot_costs x
4413: WHERE x.organization_id = a.organization_id
4414: AND x.inventory_item_id = a.inventory_item_id
4415: AND x.cost_type_id = a.cost_type_id
4416: AND x.lot_number = b.lot_number

Line 4559: gmf_lot_costs b

4555: a.detail_id,
4556: a.delete_mark,
4557: a.final_cost_flag
4558: FROM gmf_lot_cost_details a,
4559: gmf_lot_costs b
4560: WHERE a.header_id = b.text_code
4561: AND b.text_code IS NOT NULL
4562: AND (
4563: (b.cost_type_id IS NOT NULL AND b.cost_mthd_code IS NULL)

Line 10999: FROM gmf_lot_Costs a,

10995: AND nvl(c.subinventory_ind_flag,'N') <> 'Y'
10996: UNION
10997: SELECT a.item_id,
10998: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10999: FROM gmf_lot_Costs a,
11000: ic_whse_mst b
11001: WHERE a.item_id IS NOT NULL
11002: AND a.whse_code = b.whse_code
11003: UNION

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

12696: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12697: GROUP BY calendar_code, period_code
12698: HAVING count(*) > 0
12699: ) cm_acst_led';
12700: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12701: gmf_lot_costs.*
12702: FROM (
12703: SELECT ''ORGANIZATION_ID'' column_name,
12704: ''Warehouse Code: ''|| whse_code parameters,

Line 12701: gmf_lot_costs.*

12697: GROUP BY calendar_code, period_code
12698: HAVING count(*) > 0
12699: ) cm_acst_led';
12700: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12701: gmf_lot_costs.*
12702: FROM (
12703: SELECT ''ORGANIZATION_ID'' column_name,
12704: ''Warehouse Code: ''|| whse_code parameters,
12705: count(*) records

Line 12706: FROM gmf_lot_costs

12702: FROM (
12703: SELECT ''ORGANIZATION_ID'' column_name,
12704: ''Warehouse Code: ''|| whse_code parameters,
12705: count(*) records
12706: FROM gmf_lot_costs
12707: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12708: GROUP BY whse_code
12709: HAVING count(*) > 0
12710: UNION

Line 12714: FROM gmf_lot_costs a, ic_item_mst b

12710: UNION
12711: SELECT ''INVENTORY_ITEM_ID'' column_name,
12712: ''Item No: ''|| b.item_no parameters,
12713: count(*) records
12714: FROM gmf_lot_costs a, ic_item_mst b
12715: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12716: AND b.item_id = a.item_id
12717: GROUP BY b.item_no
12718: HAVING count(*) > 0

Line 12723: FROM gmf_lot_costs

12719: UNION
12720: SELECT ''COST_TYPE_ID'' column_name,
12721: ''Cost Method Code: ''|| cost_mthd_code parameters,
12722: count(*) records
12723: FROM gmf_lot_costs
12724: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12725: GROUP BY cost_mthd_code
12726: HAVING count(*) > 0
12727: UNION

Line 12731: FROM gmf_lot_costs

12727: UNION
12728: SELECT ''LOT_NUMBER'' column_name,
12729: ''Lot Id: ''|| lot_id parameters,
12730: count(*) records
12731: FROM gmf_lot_costs
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';

Line 12735: ) gmf_lot_costs';

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

Line 13696: * Migration Error Logging for table GMF_LOT_COSTS *

13692: FROM xla_line_assgns_t;
13693: END IF;
13694: END IF;
13695: /**************************************************
13696: * Migration Error Logging for table GMF_LOT_COSTS *
13697: **************************************************/
13698: IF l_table_name IN ('GMF_LOT_COSTS') THEN
13699: IF p_log_level = 1 THEN
13700: l_sql_statement := l_sql_statement

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

13694: END IF;
13695: /**************************************************
13696: * Migration Error Logging for table GMF_LOT_COSTS *
13697: **************************************************/
13698: IF l_table_name IN ('GMF_LOT_COSTS') THEN
13699: IF p_log_level = 1 THEN
13700: l_sql_statement := l_sql_statement
13701: ||
13702: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13717: FROM gmf_lot_costs;

13713: INTO l_organization_count,
13714: l_inventory_item_count,
13715: l_cost_type_count,
13716: l_lot_number_count
13717: FROM gmf_lot_costs;
13718: END IF;
13719: END IF;
13720: /*********************************************************
13721: * Migration Error Logging for table GMF_LOT_COSTED_ITEMS *

Line 14018: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN

14014: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN
14015: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;
14016: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14017: CLOSE cur_gmf_log_errors;
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

Line 14019: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;

14015: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;
14016: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14017: CLOSE cur_gmf_log_errors;
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;