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_ADJUSTMENTS

Line 4930: G_Table_name := 'GMF_LOT_COST_ADJUSTMENTS';

4926:
4927: BEGIN
4928:
4929: G_Migration_run_id := P_migration_run_id;
4930: G_Table_name := 'GMF_LOT_COST_ADJUSTMENTS';
4931: G_Context := 'Lot Cost Adjustments Migration';
4932: X_failure_count := 0;
4933:
4934: /********************************

Line 4952: * Update a row in GMF_LOT_COST_ADJUSTMENTS for cost Types *

4948:
4949: BEGIN
4950:
4951: /**********************************************************
4952: * Update a row in GMF_LOT_COST_ADJUSTMENTS for cost Types *
4953: **********************************************************/
4954:
4955: UPDATE gmf_lot_cost_adjustments a
4956: SET a.cost_type_id

Line 4955: UPDATE gmf_lot_cost_adjustments a

4951: /**********************************************************
4952: * Update a row in GMF_LOT_COST_ADJUSTMENTS for cost Types *
4953: **********************************************************/
4954:
4955: UPDATE gmf_lot_cost_adjustments a
4956: SET a.cost_type_id
4957: = (
4958: SELECT x.cost_Type_id
4959: FROM cm_mthd_mst x

Line 5033: INSERT INTO gmf_lot_cost_adjustments

5029: BEGIN
5030: /****************************************************************************
5031: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
5032: ****************************************************************************/
5033: INSERT INTO gmf_lot_cost_adjustments
5034: (
5035: adjustment_id,
5036: adjustment_date,
5037: reason_code,

Line 5135: FROM gmf_lot_cost_adjustments a,

5131: a.inventory_item_id,
5132: a.legal_entity_id,
5133: b.lot_number,
5134: a.organization_id
5135: FROM gmf_lot_cost_adjustments a,
5136: ic_lots_mst_mig b
5137: WHERE a.lot_id = b.lot_id
5138: AND nvl(b.additional_status_lot,0) = 1
5139: AND (

Line 5147: FROM gmf_lot_cost_adjustments x

5143: OR (a.legal_entity_id IS NOT NULL AND a.co_code IS NOT NULL)
5144: )
5145: AND NOT EXISTS (
5146: SELECT 'RECORD_ALREADY_EXISTS'
5147: FROM gmf_lot_cost_adjustments x
5148: WHERE x.legal_entity_id = a.legal_entity_id
5149: AND x.organization_id = a.organization_id
5150: AND x.inventory_item_id = a.inventory_item_id
5151: AND x.cost_type_id = a.cost_type_id

Line 5223: gmf_lot_cost_adjustments b

5219: a.last_updated_by,
5220: a.last_update_login,
5221: SYSDATE
5222: FROM gmf_lot_cost_adjustment_dtls a,
5223: gmf_lot_cost_adjustments b
5224: WHERE a.adjustment_id = b.text_code
5225: AND b.text_code IS NOT NULL
5226: AND (
5227: (b.cost_type_id IS NOT NULL AND b.cost_mthd_code IS NULL)

Line 10676: FROM gmf_lot_Cost_adjustments a,

10672: AND a.whse_code = b.whse_code
10673: UNION
10674: SELECT a.item_id,
10675: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10676: FROM gmf_lot_Cost_adjustments a,
10677: ic_whse_mst b
10678: WHERE a.item_id IS NOT NULL
10679: AND a.whse_code = b.whse_code
10680: UNION

Line 12494: l_gmf_lot_cost_adjustments VARCHAR2(32000) := 'SELECT ''GMF_LOT_COST_ADJUSTMENTS'' table_name,

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

Line 12495: gmf_lot_cost_adjustments.*

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

Line 12500: FROM gmf_lot_cost_adjustments

12496: FROM (
12497: SELECT ''ORGANIZATION_ID'' column_name,
12498: ''Warehouse Code: ''|| whse_code parameters,
12499: count(*) records
12500: FROM gmf_lot_cost_adjustments
12501: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12502: GROUP BY whse_code
12503: HAVING count(*) > 0
12504: UNION

Line 12508: FROM gmf_lot_cost_adjustments a, ic_item_mst b

12504: UNION
12505: SELECT ''INVENTORY_ITEM_ID'' column_name,
12506: ''Item No: ''|| b.item_no parameters,
12507: count(*) records
12508: FROM gmf_lot_cost_adjustments a, ic_item_mst b
12509: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12510: AND b.item_id = a.item_id
12511: GROUP BY b.item_no
12512: HAVING count(*) > 0

Line 12517: FROM gmf_lot_cost_adjustments

12513: UNION
12514: SELECT ''COST_TYPE_ID'' column_name,
12515: ''Cost Method Code: ''|| cost_mthd_code parameters,
12516: count(*) records
12517: FROM gmf_lot_cost_adjustments
12518: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12519: GROUP BY cost_mthd_code
12520: HAVING count(*) > 0
12521: UNION

Line 12525: FROM gmf_lot_cost_adjustments

12521: UNION
12522: SELECT ''LEGAL_ENTITY_ID'' column_name,
12523: ''Co Code: ''|| co_code parameters,
12524: count(*) records
12525: FROM gmf_lot_cost_adjustments
12526: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
12527: GROUP BY co_code
12528: HAVING count(*) > 0
12529: UNION

Line 12533: FROM gmf_lot_cost_adjustments

12529: UNION
12530: SELECT ''LOT_NUMBER'' column_name,
12531: ''Lot Id: ''|| lot_id parameters,
12532: count(*) records
12533: FROM gmf_lot_cost_adjustments
12534: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12535: GROUP BY lot_id
12536: HAVING count(*) > 0
12537: ) gmf_lot_cost_adjustments';

Line 12537: ) gmf_lot_cost_adjustments';

12533: FROM gmf_lot_cost_adjustments
12534: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12535: GROUP BY lot_id
12536: HAVING count(*) > 0
12537: ) gmf_lot_cost_adjustments';
12538: l_gmf_material_lot_cost_txns VARCHAR2(32000) := 'SELECT ''GMF_MATERIAL_LOT_COST_TXNS'' table_name,
12539: gmf_material_lot_cost_txns.*
12540: FROM (
12541: SELECT ''COST_TYPE_ID'' column_name,

Line 13446: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *

13442: FROM gmf_lot_cost_burdens;
13443: END IF;
13444: END IF;
13445: /*************************************************************
13446: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *
13447: *************************************************************/
13448: IF l_table_name IN ('GMF_LOT_COST_ADJUSTMENTS') THEN
13449: IF p_log_level = 1 THEN
13450: l_sql_statement := l_sql_statement

Line 13448: IF l_table_name IN ('GMF_LOT_COST_ADJUSTMENTS') THEN

13444: END IF;
13445: /*************************************************************
13446: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *
13447: *************************************************************/
13448: IF l_table_name IN ('GMF_LOT_COST_ADJUSTMENTS') THEN
13449: IF p_log_level = 1 THEN
13450: l_sql_statement := l_sql_statement
13451: ||
13452: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13470: FROM gmf_lot_cost_adjustments;

13466: l_inventory_item_count,
13467: l_cost_type_count,
13468: l_legal_entity_count,
13469: l_lot_number_count
13470: FROM gmf_lot_cost_adjustments;
13471: END IF;
13472: END IF;
13473: /***************************************************************
13474: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *

Line 13699: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN

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;
13701: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13702: CLOSE cur_gmf_log_errors;
13703: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN

Line 13700: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_adjustments;

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;
13701: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13702: CLOSE cur_gmf_log_errors;
13703: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN
13704: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;