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_RSRC_DTL

Line 2958: SELECT 'CM_RSRC_DTL'

2954: AND i.legal_entity_id IS NOT NULL
2955: AND g.cost_mthd_code <> h.cost_mthd_code
2956: AND i.co_code = g.co_code
2957: AND EXISTS (
2958: SELECT 'CM_RSRC_DTL'
2959: FROM cm_rsrc_dtl a
2960: WHERE a.calendar_code is not null
2961: AND a.cost_mthd_Code is not null
2962: AND a.calendar_code = g.calendar_code

Line 2959: FROM cm_rsrc_dtl a

2955: AND g.cost_mthd_code <> h.cost_mthd_code
2956: AND i.co_code = g.co_code
2957: AND EXISTS (
2958: SELECT 'CM_RSRC_DTL'
2959: FROM cm_rsrc_dtl a
2960: WHERE a.calendar_code is not null
2961: AND a.cost_mthd_Code is not null
2962: AND a.calendar_code = g.calendar_code
2963: AND a.cost_mthd_code = h.cost_mthd_code

Line 3057: * Insert a row in gmf_calendar_assignments for CM_RSRC_DTL table data *

3053: );
3054: END;
3055:
3056: /**********************************************************************
3057: * Insert a row in gmf_calendar_assignments for CM_RSRC_DTL table data *
3058: **********************************************************************/
3059: BEGIN
3060:
3061: INSERT INTO gmf_calendar_assignments

Line 3094: cm_rsrc_dtl k

3090: FROM cm_cldr_hdr_b g,
3091: cm_mthd_mst h,
3092: gl_plcy_mst i,
3093: sy_orgn_mst j,
3094: cm_rsrc_dtl k
3095: WHERE g.co_code IS NOT NULL
3096: AND j.orgn_code = k.orgn_code
3097: AND i.co_code = j.co_code
3098: AND i.legal_entity_id IS NOT NULL

Line 12071: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,

12067: l_invalid_number_error_count PLS_INTEGER := 0;
12068: l_not_picked_up_error_count PLS_INTEGER := 0;
12069: l_total_error_count PLS_INTEGER := 0;
12070:
12071: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,
12072: cm_rsrc_dtl.*
12073: FROM (
12074: SELECT ''LEGAL_ENTITY_ID'' column_name,
12075: ''Orgn Code: ''|| orgn_code parameters,

Line 12072: cm_rsrc_dtl.*

12068: l_not_picked_up_error_count PLS_INTEGER := 0;
12069: l_total_error_count PLS_INTEGER := 0;
12070:
12071: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,
12072: cm_rsrc_dtl.*
12073: FROM (
12074: SELECT ''LEGAL_ENTITY_ID'' column_name,
12075: ''Orgn Code: ''|| orgn_code parameters,
12076: count(*) records

Line 12077: FROM cm_rsrc_dtl

12073: FROM (
12074: SELECT ''LEGAL_ENTITY_ID'' column_name,
12075: ''Orgn Code: ''|| orgn_code parameters,
12076: count(*) records
12077: FROM cm_rsrc_dtl
12078: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12079: GROUP BY orgn_code
12080: HAVING count(*) > 0
12081: UNION

Line 12085: FROM cm_rsrc_dtl

12081: UNION
12082: SELECT ''ORGANIZATION_ID'' column_name,
12083: ''Orgn Code: ''|| orgn_code parameters,
12084: count(*) records
12085: FROM cm_rsrc_dtl
12086: WHERE (organization_id IS NULL AND delete_mark = 0 AND orgn_code IS NOT NULL)
12087: GROUP BY orgn_code
12088: HAVING count(*) > 0
12089: UNION

Line 12093: FROM cm_rsrc_dtl

12089: UNION
12090: SELECT ''COST_TYPE_ID'' column_name,
12091: ''Cost Method Code: ''|| cost_mthd_code parameters,
12092: count(*) records
12093: FROM cm_rsrc_dtl
12094: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12095: GROUP BY cost_mthd_code
12096: HAVING count(*) > 0
12097: UNION

Line 12101: FROM cm_rsrc_dtl

12097: UNION
12098: SELECT ''PERIOD_ID'' column_name,
12099: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12100: count(*) records
12101: FROM cm_rsrc_dtl
12102: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12103: GROUP BY calendar_code, period_code
12104: HAVING count(*) > 0
12105: UNION

Line 12109: FROM cm_rsrc_dtl

12105: UNION
12106: SELECT ''USAGE_UOM'' column_name,
12107: ''UM Code: ''|| usage_um parameters,
12108: count(*) records
12109: FROM cm_rsrc_dtl
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';

Line 12113: ) cm_rsrc_dtl';

12109: FROM cm_rsrc_dtl
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,

Line 13036: * Migration Error Logging for table CM_RSRC_DTL *

13032: RETURN;
13033: END IF;
13034: IF p_log_level IN (1, 2) THEN
13035: /************************************************
13036: * Migration Error Logging for table CM_RSRC_DTL *
13037: ************************************************/
13038: IF l_table_name IN ('CM_RSRC_DTL') THEN
13039: IF p_log_level = 1 THEN
13040: l_sql_statement := l_sql_statement

Line 13038: IF l_table_name IN ('CM_RSRC_DTL') THEN

13034: IF p_log_level IN (1, 2) THEN
13035: /************************************************
13036: * Migration Error Logging for table CM_RSRC_DTL *
13037: ************************************************/
13038: IF l_table_name IN ('CM_RSRC_DTL') THEN
13039: IF p_log_level = 1 THEN
13040: l_sql_statement := l_sql_statement
13041: ||
13042: '( (legal_entity_id IS NULL AND orgn_code IS NOT NULL)

Line 13064: FROM cm_rsrc_dtl;

13060: l_cost_type_count,
13061: l_period_count,
13062: l_uom_count1,
13063: l_organization_count
13064: FROM cm_rsrc_dtl;
13065: END IF;
13066: END IF;
13067: /************************************************
13068: * Migration Error Logging for table CM_ADJS_DTL *

Line 13643: IF l_table_name = 'CM_RSRC_DTL' THEN

13639: FROM gl_subr_sta;
13640: END IF;
13641: END IF;
13642: ELSIF p_log_level = 3 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

Line 13644: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;

13640: END IF;
13641: END IF;
13642: ELSIF p_log_level = 3 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;