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 5575: G_Table_name := 'GMF_LOT_COST_BURDENS';

5571:
5572: BEGIN
5573:
5574: G_Migration_run_id := P_migration_run_id;
5575: G_Table_name := 'GMF_LOT_COST_BURDENS';
5576: G_Context := 'Lot Cost Burdens Migration';
5577: X_failure_count := 0;
5578:
5579: /********************************

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

5593:
5594: BEGIN
5595:
5596: /******************************************************
5597: * Update a row in GMF_LOT_COST_BURDENS for cost Types *
5598: ******************************************************/
5599:
5600: UPDATE gmf_lot_cost_burdens a
5601: SET a.cost_type_id

Line 5600: UPDATE gmf_lot_cost_burdens a

5596: /******************************************************
5597: * Update a row in GMF_LOT_COST_BURDENS for cost Types *
5598: ******************************************************/
5599:
5600: UPDATE gmf_lot_cost_burdens a
5601: SET a.cost_type_id
5602: = (
5603: SELECT x.cost_Type_id
5604: FROM cm_mthd_mst x

Line 5684: INSERT INTO gmf_lot_cost_burdens

5680: BEGIN
5681: /****************************************************************************
5682: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
5683: ****************************************************************************/
5684: INSERT INTO gmf_lot_cost_burdens
5685: (
5686: lot_burden_line_id,
5687: resources,
5688: cost_cmpntcls_id,

Line 5798: FROM gmf_lot_cost_burdens a,

5794: a.item_uom,
5795: b.lot_number,
5796: a.organization_id,
5797: a.resource_uom
5798: FROM gmf_lot_cost_burdens a,
5799: ic_lots_mst_mig b
5800: WHERE a.lot_id = b.lot_id
5801: AND nvl(b.additional_status_lot,0) = 1
5802: AND (

Line 5811: FROM gmf_lot_cost_burdens x

5807: OR (a.inventory_item_id IS NOT NULL AND a.item_id IS NOT NULL)
5808: )
5809: AND NOT EXISTS (
5810: SELECT 'RECORD_ALREADY_EXISTS'
5811: FROM gmf_lot_cost_burdens x
5812: WHERE x.organization_id = a.organization_id
5813: AND x.inventory_item_id = a.inventory_item_id
5814: AND x.cost_type_id = a.cost_type_id
5815: AND x.lot_number = b.lot_number

Line 11013: FROM gmf_lot_Cost_burdens a,

11009: AND a.whse_code = b.whse_code
11010: UNION
11011: SELECT a.item_id,
11012: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
11013: FROM gmf_lot_Cost_burdens a,
11014: ic_whse_mst b
11015: WHERE a.item_id IS NOT NULL
11016: AND a.whse_code = b.whse_code
11017: ) x

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

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

Line 12774: gmf_lot_cost_burdens.*

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

Line 12779: FROM gmf_lot_cost_burdens

12775: FROM (
12776: SELECT ''ORGANIZATION_ID'' column_name,
12777: ''Warehouse Code: ''|| whse_code parameters,
12778: count(*) records
12779: FROM gmf_lot_cost_burdens
12780: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12781: GROUP BY whse_code
12782: HAVING count(*) > 0
12783: UNION

Line 12787: FROM gmf_lot_cost_burdens a, ic_item_mst b

12783: UNION
12784: SELECT ''INVENTORY_ITEM_ID'' column_name,
12785: ''Item No: ''|| b.item_no parameters,
12786: count(*) records
12787: FROM gmf_lot_cost_burdens a, ic_item_mst b
12788: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12789: AND b.item_id = a.item_id
12790: GROUP BY b.item_no
12791: HAVING count(*) > 0

Line 12796: FROM gmf_lot_cost_burdens

12792: UNION
12793: SELECT ''COST_TYPE_ID'' column_name,
12794: ''Cost Method Code: ''|| cost_mthd_code parameters,
12795: count(*) records
12796: FROM gmf_lot_cost_burdens
12797: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12798: GROUP BY cost_mthd_code
12799: HAVING count(*) > 0
12800: UNION

Line 12804: FROM gmf_lot_cost_burdens

12800: UNION
12801: SELECT ''ITEM_UOM'' column_name,
12802: ''Item UOM: ''|| Item_um parameters,
12803: count(*) records
12804: FROM gmf_lot_cost_burdens
12805: WHERE (item_uom IS NULL AND item_um IS NOT NULL)
12806: GROUP BY item_um
12807: HAVING count(*) > 0
12808: UNION

Line 12812: FROM gmf_lot_cost_burdens

12808: UNION
12809: SELECT ''RESOURCE_UOM'' column_name,
12810: ''Resource UOM: ''|| Resource_um parameters,
12811: count(*) records
12812: FROM gmf_lot_cost_burdens
12813: WHERE (resource_uom IS NULL AND resource_um IS NOT NULL)
12814: GROUP BY resource_um
12815: HAVING count(*) > 0
12816: UNION

Line 12820: FROM gmf_lot_cost_burdens

12816: UNION
12817: SELECT ''LOT_NUMBER'' column_name,
12818: ''Lot Id: ''|| lot_id parameters,
12819: count(*) records
12820: FROM gmf_lot_cost_burdens
12821: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12822: GROUP BY lot_id
12823: HAVING count(*) > 0
12824: ) gmf_lot_cost_burdens';

Line 12824: ) gmf_lot_cost_burdens';

12820: FROM gmf_lot_cost_burdens
12821: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12822: GROUP BY lot_id
12823: HAVING count(*) > 0
12824: ) gmf_lot_cost_burdens';
12825: l_gmf_lot_cost_adjustments VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_ADJUSTMENTS'' table_name,
12826: gmf_lot_cost_adjustments.*
12827: FROM (
12828: SELECT ''ORGANIZATION_ID'' column_name,

Line 13746: * Migration Error Logging for table GMF_LOT_COST_BURDENS *

13742: FROM gmf_lot_costed_items;
13743: END IF;
13744: END IF;
13745: /*********************************************************
13746: * Migration Error Logging for table GMF_LOT_COST_BURDENS *
13747: *********************************************************/
13748: IF l_table_name IN ('GMF_LOT_COST_BURDENS') THEN
13749: IF p_log_level = 1 THEN
13750: l_sql_statement := l_sql_statement

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

13744: END IF;
13745: /*********************************************************
13746: * Migration Error Logging for table GMF_LOT_COST_BURDENS *
13747: *********************************************************/
13748: IF l_table_name IN ('GMF_LOT_COST_BURDENS') THEN
13749: IF p_log_level = 1 THEN
13750: l_sql_statement := l_sql_statement
13751: ||
13752: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13773: FROM gmf_lot_cost_burdens;

13769: l_cost_type_count,
13770: l_uom_count1,
13771: l_uom_count2,
13772: l_lot_number_count
13773: FROM gmf_lot_cost_burdens;
13774: END IF;
13775: END IF;
13776: /*************************************************************
13777: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *

Line 14026: ELSIF l_table_name = 'GMF_LOT_COST_BURDENS' THEN

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;
14028: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14029: CLOSE cur_gmf_log_errors;
14030: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN

Line 14027: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_burdens;

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;
14028: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14029: CLOSE cur_gmf_log_errors;
14030: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN
14031: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_adjustments;