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_COST_BURDENS

Line 5552: G_Table_name := 'GMF_LOT_COST_BURDENS';

5548:
5549: BEGIN
5550:
5551: G_Migration_run_id := P_migration_run_id;
5552: G_Table_name := 'GMF_LOT_COST_BURDENS';
5553: G_Context := 'Lot Cost Burdens Migration';
5554: X_failure_count := 0;
5555:
5556: /********************************

Line 5574: * Update a row in GMF_LOT_COST_BURDENS for cost Types *

5570:
5571: BEGIN
5572:
5573: /******************************************************
5574: * Update a row in GMF_LOT_COST_BURDENS for cost Types *
5575: ******************************************************/
5576:
5577: UPDATE gmf_lot_cost_burdens a
5578: SET a.cost_type_id

Line 5577: UPDATE gmf_lot_cost_burdens a

5573: /******************************************************
5574: * Update a row in GMF_LOT_COST_BURDENS for cost Types *
5575: ******************************************************/
5576:
5577: UPDATE gmf_lot_cost_burdens a
5578: SET a.cost_type_id
5579: = (
5580: SELECT x.cost_Type_id
5581: FROM cm_mthd_mst x

Line 5661: INSERT INTO gmf_lot_cost_burdens

5657: BEGIN
5658: /****************************************************************************
5659: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
5660: ****************************************************************************/
5661: INSERT INTO gmf_lot_cost_burdens
5662: (
5663: lot_burden_line_id,
5664: resources,
5665: cost_cmpntcls_id,

Line 5775: FROM gmf_lot_cost_burdens a,

5771: a.item_uom,
5772: b.lot_number,
5773: a.organization_id,
5774: a.resource_uom
5775: FROM gmf_lot_cost_burdens a,
5776: ic_lots_mst_mig b
5777: WHERE a.lot_id = b.lot_id
5778: AND nvl(b.additional_status_lot,0) = 1
5779: AND (

Line 5788: FROM gmf_lot_cost_burdens x

5784: OR (a.inventory_item_id IS NOT NULL AND a.item_id IS NOT NULL)
5785: )
5786: AND NOT EXISTS (
5787: SELECT 'RECORD_ALREADY_EXISTS'
5788: FROM gmf_lot_cost_burdens x
5789: WHERE x.organization_id = a.organization_id
5790: AND x.inventory_item_id = a.inventory_item_id
5791: AND x.cost_type_id = a.cost_type_id
5792: AND x.lot_number = b.lot_number

Line 10683: FROM gmf_lot_Cost_burdens a,

10679: AND a.whse_code = b.whse_code
10680: UNION
10681: SELECT a.item_id,
10682: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10683: FROM gmf_lot_Cost_burdens a,
10684: ic_whse_mst b
10685: WHERE a.item_id IS NOT NULL
10686: AND a.whse_code = b.whse_code
10687: ) x

Line 12442: l_gmf_lot_cost_burdens VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_BURDENS'' table_name,

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,
12446: ''Warehouse Code: ''|| whse_code parameters,

Line 12443: gmf_lot_cost_burdens.*

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,
12446: ''Warehouse Code: ''|| whse_code parameters,
12447: count(*) records

Line 12448: FROM gmf_lot_cost_burdens

12444: FROM (
12445: SELECT ''ORGANIZATION_ID'' column_name,
12446: ''Warehouse Code: ''|| whse_code parameters,
12447: count(*) records
12448: FROM gmf_lot_cost_burdens
12449: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12450: GROUP BY whse_code
12451: HAVING count(*) > 0
12452: UNION

Line 12456: FROM gmf_lot_cost_burdens a, ic_item_mst b

12452: UNION
12453: SELECT ''INVENTORY_ITEM_ID'' column_name,
12454: ''Item No: ''|| b.item_no parameters,
12455: count(*) records
12456: FROM gmf_lot_cost_burdens a, ic_item_mst b
12457: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12458: AND b.item_id = a.item_id
12459: GROUP BY b.item_no
12460: HAVING count(*) > 0

Line 12465: FROM gmf_lot_cost_burdens

12461: UNION
12462: SELECT ''COST_TYPE_ID'' column_name,
12463: ''Cost Method Code: ''|| cost_mthd_code parameters,
12464: count(*) records
12465: FROM gmf_lot_cost_burdens
12466: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12467: GROUP BY cost_mthd_code
12468: HAVING count(*) > 0
12469: UNION

Line 12473: FROM gmf_lot_cost_burdens

12469: UNION
12470: SELECT ''ITEM_UOM'' column_name,
12471: ''Item UOM: ''|| Item_um parameters,
12472: count(*) records
12473: FROM gmf_lot_cost_burdens
12474: WHERE (item_uom IS NULL AND item_um IS NOT NULL)
12475: GROUP BY item_um
12476: HAVING count(*) > 0
12477: UNION

Line 12481: FROM gmf_lot_cost_burdens

12477: UNION
12478: SELECT ''RESOURCE_UOM'' column_name,
12479: ''Resource UOM: ''|| Resource_um parameters,
12480: count(*) records
12481: FROM gmf_lot_cost_burdens
12482: WHERE (resource_uom IS NULL AND resource_um IS NOT NULL)
12483: GROUP BY resource_um
12484: HAVING count(*) > 0
12485: UNION

Line 12489: FROM gmf_lot_cost_burdens

12485: UNION
12486: SELECT ''LOT_NUMBER'' column_name,
12487: ''Lot Id: ''|| lot_id parameters,
12488: count(*) records
12489: FROM gmf_lot_cost_burdens
12490: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12491: GROUP BY lot_id
12492: HAVING count(*) > 0
12493: ) gmf_lot_cost_burdens';

Line 12493: ) gmf_lot_cost_burdens';

12489: FROM gmf_lot_cost_burdens
12490: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12491: GROUP BY lot_id
12492: HAVING count(*) > 0
12493: ) gmf_lot_cost_burdens';
12494: l_gmf_lot_cost_adjustments VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_ADJUSTMENTS'' table_name,
12495: gmf_lot_cost_adjustments.*
12496: FROM (
12497: SELECT ''ORGANIZATION_ID'' column_name,

Line 13415: * Migration Error Logging for table GMF_LOT_COST_BURDENS *

13411: FROM gmf_lot_costed_items;
13412: END IF;
13413: END IF;
13414: /*********************************************************
13415: * Migration Error Logging for table GMF_LOT_COST_BURDENS *
13416: *********************************************************/
13417: IF l_table_name IN ('GMF_LOT_COST_BURDENS') THEN
13418: IF p_log_level = 1 THEN
13419: l_sql_statement := l_sql_statement

Line 13417: IF l_table_name IN ('GMF_LOT_COST_BURDENS') THEN

13413: END IF;
13414: /*********************************************************
13415: * Migration Error Logging for table GMF_LOT_COST_BURDENS *
13416: *********************************************************/
13417: IF l_table_name IN ('GMF_LOT_COST_BURDENS') THEN
13418: IF p_log_level = 1 THEN
13419: l_sql_statement := l_sql_statement
13420: ||
13421: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13442: FROM gmf_lot_cost_burdens;

13438: l_cost_type_count,
13439: l_uom_count1,
13440: l_uom_count2,
13441: l_lot_number_count
13442: FROM gmf_lot_cost_burdens;
13443: END IF;
13444: END IF;
13445: /*************************************************************
13446: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *

Line 13695: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN

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;
13697: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13698: CLOSE cur_gmf_log_errors;
13699: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN

Line 13696: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_burdens;

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;
13697: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13698: CLOSE cur_gmf_log_errors;
13699: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN
13700: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_adjustments;