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 CM_ADJS_DTL

Line 2979: SELECT 'CM_ADJS_DTL'

2975: AND a.cost_mthd_Code is not null
2976: AND a.calendar_code = g.calendar_code
2977: AND a.cost_mthd_code = h.cost_mthd_code
2978: UNION
2979: SELECT 'CM_ADJS_DTL'
2980: FROM cm_adjs_dtl a
2981: WHERE a.calendar_code is not null
2982: AND a.cost_mthd_Code is not null
2983: AND a.calendar_code = g.calendar_code

Line 2980: FROM cm_adjs_dtl a

2976: AND a.calendar_code = g.calendar_code
2977: AND a.cost_mthd_code = h.cost_mthd_code
2978: UNION
2979: SELECT 'CM_ADJS_DTL'
2980: FROM cm_adjs_dtl a
2981: WHERE a.calendar_code is not null
2982: AND a.cost_mthd_Code is not null
2983: AND a.calendar_code = g.calendar_code
2984: AND a.cost_mthd_code = h.cost_mthd_code

Line 3347: * Insert a row in gmf_calendar_assignments for CM_ADJS_DTL table data *

3343: );
3344: END;
3345:
3346: /**********************************************************************
3347: * Insert a row in gmf_calendar_assignments for CM_ADJS_DTL table data *
3348: **********************************************************************/
3349: BEGIN
3350:
3351: INSERT INTO gmf_calendar_assignments

Line 3384: cm_adjs_dtl k,

3380: FROM cm_cldr_hdr_b g,
3381: cm_mthd_mst h,
3382: gl_plcy_mst i,
3383: sy_orgn_mst j,
3384: cm_adjs_dtl k,
3385: ic_whse_mst l
3386: WHERE g.co_code IS NOT NULL
3387: AND l.whse_code = k.whse_code
3388: AND j.orgn_code = l.orgn_code

Line 10615: FROM cm_adjs_dtl a,

10611: AND a.whse_code = b.whse_code
10612: UNION
10613: SELECT a.item_id,
10614: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10615: FROM cm_adjs_dtl a,
10616: ic_whse_mst b
10617: WHERE a.item_id IS NOT NULL
10618: AND a.whse_code = b.whse_code
10619: UNION

Line 12114: l_cm_adjs_dtl VARCHAR2(32000) := 'SELECT ''CM_ADJS_DTL'' table_name,

12110: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12111: GROUP BY usage_um
12112: HAVING count(*) > 0
12113: ) cm_rsrc_dtl';
12114: l_cm_adjs_dtl VARCHAR2(32000) := 'SELECT ''CM_ADJS_DTL'' table_name,
12115: cm_adjs_dtl.*
12116: FROM (
12117: SELECT ''ORGANIZATION_ID'' column_name,
12118: ''Warehouse Code: ''|| whse_code parameters,

Line 12115: cm_adjs_dtl.*

12111: GROUP BY usage_um
12112: HAVING count(*) > 0
12113: ) cm_rsrc_dtl';
12114: l_cm_adjs_dtl VARCHAR2(32000) := 'SELECT ''CM_ADJS_DTL'' table_name,
12115: cm_adjs_dtl.*
12116: FROM (
12117: SELECT ''ORGANIZATION_ID'' column_name,
12118: ''Warehouse Code: ''|| whse_code parameters,
12119: count(*) records

Line 12120: FROM cm_adjs_dtl

12116: FROM (
12117: SELECT ''ORGANIZATION_ID'' column_name,
12118: ''Warehouse Code: ''|| whse_code parameters,
12119: count(*) records
12120: FROM cm_adjs_dtl
12121: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12122: GROUP BY whse_code
12123: HAVING count(*) > 0
12124: UNION

Line 12128: FROM cm_adjs_dtl a, ic_item_mst b

12124: UNION
12125: SELECT ''INVENTORY_ITEM_ID'' column_name,
12126: ''Item No: ''|| b.item_no parameters,
12127: count(*) records
12128: FROM cm_adjs_dtl a, ic_item_mst b
12129: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12130: AND b.item_id = a.item_id
12131: GROUP BY b.item_no
12132: HAVING count(*) > 0

Line 12137: FROM cm_adjs_dtl

12133: UNION
12134: SELECT ''COST_TYPE_ID'' column_name,
12135: ''Cost Method Code: ''|| cost_mthd_code parameters,
12136: count(*) records
12137: FROM cm_adjs_dtl
12138: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12139: GROUP BY cost_mthd_code
12140: HAVING count(*) > 0
12141: UNION

Line 12145: FROM cm_adjs_dtl

12141: UNION
12142: SELECT ''PERIOD_ID'' column_name,
12143: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12144: count(*) records
12145: FROM cm_adjs_dtl
12146: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12147: GROUP BY calendar_code, period_code
12148: HAVING count(*) > 0
12149: UNION

Line 12153: FROM cm_adjs_dtl

12149: UNION
12150: SELECT ''ADJUST_QTY_UOM'' column_name,
12151: ''Adjust qty UM: ''|| adjust_qty_um parameters,
12152: count(*) records
12153: FROM cm_adjs_dtl
12154: WHERE (adjust_qty_uom IS NULL AND adjust_qty_um IS NOT NULL)
12155: GROUP BY adjust_qty_um
12156: HAVING count(*) > 0
12157: UNION

Line 12161: FROM cm_adjs_dtl

12157: UNION
12158: SELECT ''ADJUSTMENT_IND'' column_name,
12159: ''NULL'' parameters,
12160: count(*) records
12161: FROM cm_adjs_dtl
12162: WHERE (adjustment_ind IS NULL)
12163: HAVING count(*) > 0
12164: ) cm_adjs_dtl';
12165: l_cm_cmpt_dtl VARCHAR2(32000) := 'SELECT ''CM_CMPT_DTL'' table_name,

Line 12164: ) cm_adjs_dtl';

12160: count(*) records
12161: FROM cm_adjs_dtl
12162: WHERE (adjustment_ind IS NULL)
12163: HAVING count(*) > 0
12164: ) cm_adjs_dtl';
12165: l_cm_cmpt_dtl VARCHAR2(32000) := 'SELECT ''CM_CMPT_DTL'' table_name,
12166: cm_cmpt_dtl.*
12167: FROM (
12168: SELECT ''ORGANIZATION_ID'' column_name,

Line 13068: * Migration Error Logging for table CM_ADJS_DTL *

13064: FROM cm_rsrc_dtl;
13065: END IF;
13066: END IF;
13067: /************************************************
13068: * Migration Error Logging for table CM_ADJS_DTL *
13069: ************************************************/
13070: IF l_table_name IN ('CM_ADJS_DTL') THEN
13071: IF p_log_level = 1 THEN
13072: l_sql_statement := l_sql_statement

Line 13070: IF l_table_name IN ('CM_ADJS_DTL') THEN

13066: END IF;
13067: /************************************************
13068: * Migration Error Logging for table CM_ADJS_DTL *
13069: ************************************************/
13070: IF l_table_name IN ('CM_ADJS_DTL') THEN
13071: IF p_log_level = 1 THEN
13072: l_sql_statement := l_sql_statement
13073: ||
13074: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13099: FROM cm_adjs_dtl;

13095: l_cost_type_count,
13096: l_period_count,
13097: l_uom_count1,
13098: l_adjustment_ind_count
13099: FROM cm_adjs_dtl;
13100: END IF;
13101: END IF;
13102: /************************************************
13103: * Migration Error Logging for table CM_CMPT_DTL *

Line 13647: ELSIF l_table_name = 'CM_ADJS_DTL' THEN

13643: IF l_table_name = 'CM_RSRC_DTL' THEN
13644: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;
13645: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13646: CLOSE cur_gmf_log_errors;
13647: ELSIF l_table_name = 'CM_ADJS_DTL' THEN
13648: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;
13649: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13650: CLOSE cur_gmf_log_errors;
13651: ELSIF l_table_name = 'CM_CMPT_DTL' THEN

Line 13648: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;

13644: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;
13645: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13646: CLOSE cur_gmf_log_errors;
13647: ELSIF l_table_name = 'CM_ADJS_DTL' THEN
13648: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;
13649: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13650: CLOSE cur_gmf_log_errors;
13651: ELSIF l_table_name = 'CM_CMPT_DTL' THEN
13652: OPEN cur_gmf_log_errors FOR l_cm_cmpt_dtl;