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 10945: FROM cm_adjs_dtl a,

10941: AND a.whse_code = b.whse_code
10942: UNION
10943: SELECT a.item_id,
10944: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10945: FROM cm_adjs_dtl a,
10946: ic_whse_mst b
10947: WHERE a.item_id IS NOT NULL
10948: AND a.whse_code = b.whse_code
10949: UNION

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

12441: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12442: GROUP BY usage_um
12443: HAVING count(*) > 0
12444: ) cm_rsrc_dtl';
12445: l_cm_adjs_dtl VARCHAR2(32000) := 'SELECT ''CM_ADJS_DTL'' table_name,
12446: cm_adjs_dtl.*
12447: FROM (
12448: SELECT ''ORGANIZATION_ID'' column_name,
12449: ''Warehouse Code: ''|| whse_code parameters,

Line 12446: cm_adjs_dtl.*

12442: GROUP BY usage_um
12443: HAVING count(*) > 0
12444: ) cm_rsrc_dtl';
12445: l_cm_adjs_dtl VARCHAR2(32000) := 'SELECT ''CM_ADJS_DTL'' table_name,
12446: cm_adjs_dtl.*
12447: FROM (
12448: SELECT ''ORGANIZATION_ID'' column_name,
12449: ''Warehouse Code: ''|| whse_code parameters,
12450: count(*) records

Line 12451: FROM cm_adjs_dtl

12447: FROM (
12448: SELECT ''ORGANIZATION_ID'' column_name,
12449: ''Warehouse Code: ''|| whse_code parameters,
12450: count(*) records
12451: FROM cm_adjs_dtl
12452: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12453: GROUP BY whse_code
12454: HAVING count(*) > 0
12455: UNION

Line 12459: FROM cm_adjs_dtl a, ic_item_mst b

12455: UNION
12456: SELECT ''INVENTORY_ITEM_ID'' column_name,
12457: ''Item No: ''|| b.item_no parameters,
12458: count(*) records
12459: FROM cm_adjs_dtl a, ic_item_mst b
12460: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12461: AND b.item_id = a.item_id
12462: GROUP BY b.item_no
12463: HAVING count(*) > 0

Line 12468: FROM cm_adjs_dtl

12464: UNION
12465: SELECT ''COST_TYPE_ID'' column_name,
12466: ''Cost Method Code: ''|| cost_mthd_code parameters,
12467: count(*) records
12468: FROM cm_adjs_dtl
12469: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12470: GROUP BY cost_mthd_code
12471: HAVING count(*) > 0
12472: UNION

Line 12476: FROM cm_adjs_dtl

12472: UNION
12473: SELECT ''PERIOD_ID'' column_name,
12474: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12475: count(*) records
12476: FROM cm_adjs_dtl
12477: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12478: GROUP BY calendar_code, period_code
12479: HAVING count(*) > 0
12480: UNION

Line 12484: FROM cm_adjs_dtl

12480: UNION
12481: SELECT ''ADJUST_QTY_UOM'' column_name,
12482: ''Adjust qty UM: ''|| adjust_qty_um parameters,
12483: count(*) records
12484: FROM cm_adjs_dtl
12485: WHERE (adjust_qty_uom IS NULL AND adjust_qty_um IS NOT NULL)
12486: GROUP BY adjust_qty_um
12487: HAVING count(*) > 0
12488: UNION

Line 12492: FROM cm_adjs_dtl

12488: UNION
12489: SELECT ''ADJUSTMENT_IND'' column_name,
12490: ''NULL'' parameters,
12491: count(*) records
12492: FROM cm_adjs_dtl
12493: WHERE (adjustment_ind IS NULL)
12494: HAVING count(*) > 0
12495: ) cm_adjs_dtl';
12496: l_cm_cmpt_dtl VARCHAR2(32000) := 'SELECT ''CM_CMPT_DTL'' table_name,

Line 12495: ) cm_adjs_dtl';

12491: count(*) records
12492: FROM cm_adjs_dtl
12493: WHERE (adjustment_ind IS NULL)
12494: HAVING count(*) > 0
12495: ) cm_adjs_dtl';
12496: l_cm_cmpt_dtl VARCHAR2(32000) := 'SELECT ''CM_CMPT_DTL'' table_name,
12497: cm_cmpt_dtl.*
12498: FROM (
12499: SELECT ''ORGANIZATION_ID'' column_name,

Line 13399: * Migration Error Logging for table CM_ADJS_DTL *

13395: FROM cm_rsrc_dtl;
13396: END IF;
13397: END IF;
13398: /************************************************
13399: * Migration Error Logging for table CM_ADJS_DTL *
13400: ************************************************/
13401: IF l_table_name IN ('CM_ADJS_DTL') THEN
13402: IF p_log_level = 1 THEN
13403: l_sql_statement := l_sql_statement

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

13397: END IF;
13398: /************************************************
13399: * Migration Error Logging for table CM_ADJS_DTL *
13400: ************************************************/
13401: IF l_table_name IN ('CM_ADJS_DTL') THEN
13402: IF p_log_level = 1 THEN
13403: l_sql_statement := l_sql_statement
13404: ||
13405: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13430: FROM cm_adjs_dtl;

13426: l_cost_type_count,
13427: l_period_count,
13428: l_uom_count1,
13429: l_adjustment_ind_count
13430: FROM cm_adjs_dtl;
13431: END IF;
13432: END IF;
13433: /************************************************
13434: * Migration Error Logging for table CM_CMPT_DTL *

Line 13978: ELSIF l_table_name = 'CM_ADJS_DTL' THEN

13974: IF l_table_name = 'CM_RSRC_DTL' THEN
13975: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;
13976: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13977: CLOSE cur_gmf_log_errors;
13978: ELSIF l_table_name = 'CM_ADJS_DTL' THEN
13979: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;
13980: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13981: CLOSE cur_gmf_log_errors;
13982: ELSIF l_table_name = 'CM_CMPT_DTL' THEN

Line 13979: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;

13975: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;
13976: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13977: CLOSE cur_gmf_log_errors;
13978: ELSIF l_table_name = 'CM_ADJS_DTL' THEN
13979: OPEN cur_gmf_log_errors FOR l_cm_adjs_dtl;
13980: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13981: CLOSE cur_gmf_log_errors;
13982: ELSIF l_table_name = 'CM_CMPT_DTL' THEN
13983: OPEN cur_gmf_log_errors FOR l_cm_cmpt_dtl;