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 5369: G_Table_name := 'GMF_MATERIAL_LOT_COST_TXNS';

5365:
5366: BEGIN
5367:
5368: G_Migration_run_id := P_migration_run_id;
5369: G_Table_name := 'GMF_MATERIAL_LOT_COST_TXNS';
5370: G_Context := 'Material Lot Cost Transactions Migration';
5371: X_failure_count := 0;
5372:
5373: /********************************

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

5387:
5388: BEGIN
5389:
5390: /**********************************************************
5391: * Update a row in GMF_MATERIAL_LOT_COST_TXNS for cost Types *
5392: **********************************************************/
5393:
5394: UPDATE gmf_material_lot_cost_txns a
5395: SET a.cost_type_id = (

Line 5394: UPDATE gmf_material_lot_cost_txns a

5390: /**********************************************************
5391: * Update a row in GMF_MATERIAL_LOT_COST_TXNS for cost Types *
5392: **********************************************************/
5393:
5394: UPDATE gmf_material_lot_cost_txns a
5395: SET a.cost_type_id = (
5396: SELECT x.cost_Type_id
5397: FROM cm_mthd_mst x
5398: WHERE x.cost_mthd_code = a.cost_type_code

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

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

Line 12539: gmf_material_lot_cost_txns.*

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

Line 12544: FROM gmf_material_lot_cost_txns

12540: FROM (
12541: SELECT ''COST_TYPE_ID'' column_name,
12542: ''Cost Type Code: ''|| cost_type_code parameters,
12543: count(*) records
12544: FROM gmf_material_lot_cost_txns
12545: WHERE (cost_type_id IS NULL AND cost_type_code IS NOT NULL)
12546: GROUP BY cost_type_code
12547: HAVING count(*) > 0
12548: UNION

Line 12552: FROM gmf_material_lot_cost_txns

12548: UNION
12549: SELECT ''COST_TRANS_UOM'' column_name,
12550: ''Cost Trans UOM: ''|| cost_trans_uom parameters,
12551: count(*) records
12552: FROM gmf_material_lot_cost_txns
12553: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12554: GROUP BY cost_trans_uom
12555: HAVING count(*) > 0
12556: ) gmf_material_lot_cost_txns';

Line 12556: ) gmf_material_lot_cost_txns';

12552: FROM gmf_material_lot_cost_txns
12553: WHERE (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL)
12554: GROUP BY cost_trans_uom
12555: HAVING count(*) > 0
12556: ) gmf_material_lot_cost_txns';
12557: l_cm_whse_src VARCHAR2(32000) := 'SELECT ''CM_WHSE_SRC'' table_name,
12558: cm_whse_src.*
12559: FROM (
12560: SELECT ''SOURCE_ORGANIZATION_ID'' column_name,

Line 13474: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *

13470: FROM gmf_lot_cost_adjustments;
13471: END IF;
13472: END IF;
13473: /***************************************************************
13474: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *
13475: ***************************************************************/
13476: IF l_table_name IN ('GMF_MATERIAL_LOT_COST_TXNS') THEN
13477: IF p_log_level = 1 THEN
13478: l_sql_statement := l_sql_statement

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

13472: END IF;
13473: /***************************************************************
13474: * Migration Error Logging for table GMF_MATERIAL_LOT_COST_TXNS *
13475: ***************************************************************/
13476: IF l_table_name IN ('GMF_MATERIAL_LOT_COST_TXNS') THEN
13477: IF p_log_level = 1 THEN
13478: l_sql_statement := l_sql_statement
13479: ||
13480: '( (cost_type_id IS NULL AND cost_type_code IS NOT NULL)

Line 13489: FROM gmf_material_lot_cost_txns;

13485: SELECT SUM(CASE WHEN (cost_type_id IS NULL AND cost_type_code IS NOT NULL) THEN 1 ELSE 0 END),
13486: SUM(CASE WHEN (cost_trans_um IS NULL AND cost_trans_uom IS NOT NULL) THEN 1 ELSE 0 END)
13487: INTO l_cost_type_count,
13488: l_uom_count1
13489: FROM gmf_material_lot_cost_txns;
13490: END IF;
13491: END IF;
13492: /************************************************
13493: * Migration Error Logging for table CM_WHSE_SRC *

Line 13703: ELSIF l_table_name = 'GMF_MATERIAL_LOT_COST_TXNS' THEN

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;
13705: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13706: CLOSE cur_gmf_log_errors;
13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN

Line 13704: OPEN cur_gmf_log_errors FOR l_gmf_material_lot_cost_txns;

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;
13705: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13706: CLOSE cur_gmf_log_errors;
13707: ELSIF l_table_name = 'CM_WHSE_SRC' THEN
13708: OPEN cur_gmf_log_errors FOR l_cm_whse_src;