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_MATERIAL_LOT_COST_TXNS

Line 5392: G_Table_name := 'GMF_MATERIAL_LOT_COST_TXNS';

5388:
5389: BEGIN
5390:
5391: G_Migration_run_id := P_migration_run_id;
5392: G_Table_name := 'GMF_MATERIAL_LOT_COST_TXNS';
5393: G_Context := 'Material Lot Cost Transactions Migration';
5394: X_failure_count := 0;
5395:
5396: /********************************

Line 5414: * Update a row in GMF_MATERIAL_LOT_COST_TXNS for cost Types *

5410:
5411: BEGIN
5412:
5413: /**********************************************************
5414: * Update a row in GMF_MATERIAL_LOT_COST_TXNS for cost Types *
5415: **********************************************************/
5416:
5417: UPDATE gmf_material_lot_cost_txns a
5418: SET a.cost_type_id = (

Line 5417: UPDATE gmf_material_lot_cost_txns a

5413: /**********************************************************
5414: * Update a row in GMF_MATERIAL_LOT_COST_TXNS for cost Types *
5415: **********************************************************/
5416:
5417: UPDATE gmf_material_lot_cost_txns a
5418: SET a.cost_type_id = (
5419: SELECT x.cost_Type_id
5420: FROM cm_mthd_mst x
5421: WHERE x.cost_mthd_code = a.cost_type_code

Line 12869: l_gmf_material_lot_cost_txns VARCHAR2(32000) := 'SELECT ''GMF_MATERIAL_LOT_COST_TXNS'' table_name,

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,
12873: ''Cost Type Code: ''|| cost_type_code parameters,

Line 12870: gmf_material_lot_cost_txns.*

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,
12873: ''Cost Type Code: ''|| cost_type_code parameters,
12874: count(*) records

Line 12875: FROM gmf_material_lot_cost_txns

12871: FROM (
12872: SELECT ''COST_TYPE_ID'' column_name,
12873: ''Cost Type Code: ''|| cost_type_code parameters,
12874: count(*) records
12875: FROM gmf_material_lot_cost_txns
12876: WHERE (cost_type_id IS NULL AND cost_type_code IS NOT NULL)
12877: GROUP BY cost_type_code
12878: HAVING count(*) > 0
12879: UNION

Line 12883: FROM gmf_material_lot_cost_txns

12879: UNION
12880: SELECT ''COST_TRANS_UOM'' column_name,
12881: ''Cost Trans UOM: ''|| cost_trans_uom parameters,
12882: count(*) records
12883: FROM gmf_material_lot_cost_txns
12884: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12885: GROUP BY cost_trans_uom
12886: HAVING count(*) > 0
12887: ) gmf_material_lot_cost_txns';

Line 12887: ) gmf_material_lot_cost_txns';

12883: FROM gmf_material_lot_cost_txns
12884: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12885: GROUP BY cost_trans_uom
12886: HAVING count(*) > 0
12887: ) gmf_material_lot_cost_txns';
12888: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12889: cm_whse_src.*
12890: FROM (
12891: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,

Line 13805: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *

13801: FROM gmf_lot_cost_adjustments;
13802: END IF;
13803: END IF;
13804: /***************************************************************
13805: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *
13806: ***************************************************************/
13807: IF l_table_name IN ('GMF_MATERIAL_LOT_COST_TXNS') THEN
13808: IF p_log_level = 1 THEN
13809: l_sql_statement := l_sql_statement

Line 13807: IF l_table_name IN ('GMF_MATERIAL_LOT_COST_TXNS') THEN

13803: END IF;
13804: /***************************************************************
13805: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *
13806: ***************************************************************/
13807: IF l_table_name IN ('GMF_MATERIAL_LOT_COST_TXNS') THEN
13808: IF p_log_level = 1 THEN
13809: l_sql_statement := l_sql_statement
13810: ||
13811: '( (cost_type_id IS NULL AND cost_type_code IS NOT NULL)

Line 13820: FROM gmf_material_lot_cost_txns;

13816: SELECT SUM(CASE WHEN (cost_type_id IS NULL AND cost_type_code IS NOT NULL) THEN 1 ELSE 0 END),
13817: SUM(CASE WHEN (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL) THEN 1 ELSE 0 END)
13818: INTO l_cost_type_count,
13819: l_uom_count1
13820: FROM gmf_material_lot_cost_txns;
13821: END IF;
13822: END IF;
13823: /************************************************
13824: * Migration Error Logging for table CM_WHSE_SRC *

Line 14034: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN

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;
14036: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14037: CLOSE cur_gmf_log_errors;
14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN

Line 14035: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;

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;
14036: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14037: CLOSE cur_gmf_log_errors;
14038: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
14039: OPEN cur_gmf_log_errors FOR l_cm_whse_src;