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.

[Home] [Help]

APPS.GMF_MIGRATION dependencies on GMF_LOT_COST_ADJUSTMENTS

Line 4953: G_Table_name := 'GMF_LOT_COST_ADJUSTMENTS';

4949:
4950: BEGIN
4951:
4952: G_Migration_run_id := P_migration_run_id;
4953: G_Table_name := 'GMF_LOT_COST_ADJUSTMENTS';
4954: G_Context := 'Lot Cost Adjustments Migration';
4955: X_failure_count := 0;
4956:
4957: /********************************

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

4971:
4972: BEGIN
4973:
4974: /**********************************************************
4975: * Update a row in GMF_LOT_COST_ADJUSTMENTS for cost Types *
4976: **********************************************************/
4977:
4978: UPDATE gmf_lot_cost_adjustments a
4979: SET a.cost_type_id

Line 4978: UPDATE gmf_lot_cost_adjustments a

4974: /**********************************************************
4975: * Update a row in GMF_LOT_COST_ADJUSTMENTS for cost Types *
4976: **********************************************************/
4977:
4978: UPDATE gmf_lot_cost_adjustments a
4979: SET a.cost_type_id
4980: = (
4981: SELECT x.cost_Type_id
4982: FROM cm_mthd_mst x

Line 5056: INSERT INTO gmf_lot_cost_adjustments

5052: BEGIN
5053: /****************************************************************************
5054: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
5055: ****************************************************************************/
5056: INSERT INTO gmf_lot_cost_adjustments
5057: (
5058: adjustment_id,
5059: adjustment_date,
5060: reason_code,

Line 5158: FROM gmf_lot_cost_adjustments a,

5154: a.inventory_item_id,
5155: a.legal_entity_id,
5156: b.lot_number,
5157: a.organization_id
5158: FROM gmf_lot_cost_adjustments a,
5159: ic_lots_mst_mig b
5160: WHERE a.lot_id = b.lot_id
5161: AND nvl(b.additional_status_lot,0) = 1
5162: AND (

Line 5170: FROM gmf_lot_cost_adjustments x

5166: OR (a.legal_entity_id IS NOT NULL AND a.co_code IS NOT NULL)
5167: )
5168: AND NOT EXISTS (
5169: SELECT 'RECORD_ALREADY_EXISTS'
5170: FROM gmf_lot_cost_adjustments x
5171: WHERE x.legal_entity_id = a.legal_entity_id
5172: AND x.organization_id = a.organization_id
5173: AND x.inventory_item_id = a.inventory_item_id
5174: AND x.cost_type_id = a.cost_type_id

Line 5246: gmf_lot_cost_adjustments b

5242: a.last_updated_by,
5243: a.last_update_login,
5244: SYSDATE
5245: FROM gmf_lot_cost_adjustment_dtls a,
5246: gmf_lot_cost_adjustments b
5247: WHERE a.adjustment_id = b.text_code
5248: AND b.text_code IS NOT NULL
5249: AND (
5250: (b.cost_type_id IS NOT NULL AND b.cost_mthd_code IS NULL)

Line 11006: FROM gmf_lot_Cost_adjustments a,

11002: AND a.whse_code = b.whse_code
11003: UNION
11004: SELECT a.item_id,
11005: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
11006: FROM gmf_lot_Cost_adjustments a,
11007: ic_whse_mst b
11008: WHERE a.item_id IS NOT NULL
11009: AND a.whse_code = b.whse_code
11010: UNION

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

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

Line 12826: gmf_lot_cost_adjustments.*

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

Line 12831: FROM gmf_lot_cost_adjustments

12827: FROM (
12828: SELECT ''ORGANIZATION_ID'' column_name,
12829: ''Warehouse Code: ''|| whse_code parameters,
12830: count(*) records
12831: FROM gmf_lot_cost_adjustments
12832: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12833: GROUP BY whse_code
12834: HAVING count(*) > 0
12835: UNION

Line 12839: FROM gmf_lot_cost_adjustments a, ic_item_mst b

12835: UNION
12836: SELECT ''INVENTORY_ITEM_ID'' column_name,
12837: ''Item No: ''|| b.item_no parameters,
12838: count(*) records
12839: FROM gmf_lot_cost_adjustments a, ic_item_mst b
12840: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12841: AND b.item_id = a.item_id
12842: GROUP BY b.item_no
12843: HAVING count(*) > 0

Line 12848: FROM gmf_lot_cost_adjustments

12844: UNION
12845: SELECT ''COST_TYPE_ID'' column_name,
12846: ''Cost Method Code: ''|| cost_mthd_code parameters,
12847: count(*) records
12848: FROM gmf_lot_cost_adjustments
12849: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12850: GROUP BY cost_mthd_code
12851: HAVING count(*) > 0
12852: UNION

Line 12856: FROM gmf_lot_cost_adjustments

12852: UNION
12853: SELECT ''LEGAL_ENTITY_ID'' column_name,
12854: ''Co Code: ''|| co_code parameters,
12855: count(*) records
12856: FROM gmf_lot_cost_adjustments
12857: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL)
12858: GROUP BY co_code
12859: HAVING count(*) > 0
12860: UNION

Line 12864: FROM gmf_lot_cost_adjustments

12860: UNION
12861: SELECT ''LOT_NUMBER'' column_name,
12862: ''Lot Id: ''|| lot_id parameters,
12863: count(*) records
12864: FROM gmf_lot_cost_adjustments
12865: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12866: GROUP BY lot_id
12867: HAVING count(*) > 0
12868: ) gmf_lot_cost_adjustments';

Line 12868: ) gmf_lot_cost_adjustments';

12864: FROM gmf_lot_cost_adjustments
12865: WHERE (lot_number IS NULL AND lot_id IS NOT NULL)
12866: GROUP BY lot_id
12867: HAVING count(*) > 0
12868: ) gmf_lot_cost_adjustments';
12869: l_gmf_material_lot_cost_txns VARCHAR2(32000) := 'SELECT ''GMF_MATERIAL_LOT_COST_TXNS'' table_name,
12870: gmf_material_lot_cost_txns.*
12871: FROM (
12872: SELECT ''COST_TYPE_ID'' column_name,

Line 13777: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *

13773: FROM gmf_lot_cost_burdens;
13774: END IF;
13775: END IF;
13776: /*************************************************************
13777: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *
13778: *************************************************************/
13779: IF l_table_name IN ('GMF_LOT_COST_ADJUSTMENTS') THEN
13780: IF p_log_level = 1 THEN
13781: l_sql_statement := l_sql_statement

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

13775: END IF;
13776: /*************************************************************
13777: * Migration Error Logging for table GMF_LOT_COST_ADJUSTMENTS *
13778: *************************************************************/
13779: IF l_table_name IN ('GMF_LOT_COST_ADJUSTMENTS') THEN
13780: IF p_log_level = 1 THEN
13781: l_sql_statement := l_sql_statement
13782: ||
13783: '( (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)

Line 13801: FROM gmf_lot_cost_adjustments;

13797: l_inventory_item_count,
13798: l_cost_type_count,
13799: l_legal_entity_count,
13800: l_lot_number_count
13801: FROM gmf_lot_cost_adjustments;
13802: END IF;
13803: END IF;
13804: /***************************************************************
13805: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *

Line 14030: ELSIF l_table_name = 'GMF_LOT_COST_ADJUSTMENTS' THEN

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;
14032: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14033: CLOSE cur_gmf_log_errors;
14034: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN

Line 14031: OPEN cur_gmf_log_errors FOR l_gmf_lot_cost_adjustments;

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;
14032: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14033: CLOSE cur_gmf_log_errors;
14034: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN
14035: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;