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.

[Home] [Help]

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 12402: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,

12398: l_invalid_number_error_count PLS_INTEGER := 0;
12399: l_not_picked_up_error_count PLS_INTEGER := 0;
12400: l_total_error_count PLS_INTEGER := 0;
12401:
12402: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,
12403: cm_rsrc_dtl.*
12404: FROM (
12405: SELECT ''LEGAL_ENTITY_ID'' column_name,
12406: ''Orgn Code: ''|| orgn_code parameters,

Line 12403: cm_rsrc_dtl.*

12399: l_not_picked_up_error_count PLS_INTEGER := 0;
12400: l_total_error_count PLS_INTEGER := 0;
12401:
12402: l_cm_rsrc_dtl VARCHAR2(32000) := 'SELECT ''CM_RSRC_DTL'' table_name,
12403: cm_rsrc_dtl.*
12404: FROM (
12405: SELECT ''LEGAL_ENTITY_ID'' column_name,
12406: ''Orgn Code: ''|| orgn_code parameters,
12407: count(*) records

Line 12408: FROM cm_rsrc_dtl

12404: FROM (
12405: SELECT ''LEGAL_ENTITY_ID'' column_name,
12406: ''Orgn Code: ''|| orgn_code parameters,
12407: count(*) records
12408: FROM cm_rsrc_dtl
12409: WHERE (legal_entity_id IS NULL AND orgn_code IS NOT NULL)
12410: GROUP BY orgn_code
12411: HAVING count(*) > 0
12412: UNION

Line 12416: FROM cm_rsrc_dtl

12412: UNION
12413: SELECT ''ORGANIZATION_ID'' column_name,
12414: ''Orgn Code: ''|| orgn_code parameters,
12415: count(*) records
12416: FROM cm_rsrc_dtl
12417: WHERE (organization_id IS NULL AND delete_mark = 0 AND orgn_code IS NOT NULL)
12418: GROUP BY orgn_code
12419: HAVING count(*) > 0
12420: UNION

Line 12424: FROM cm_rsrc_dtl

12420: UNION
12421: SELECT ''COST_TYPE_ID'' column_name,
12422: ''Cost Method Code: ''|| cost_mthd_code parameters,
12423: count(*) records
12424: FROM cm_rsrc_dtl
12425: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12426: GROUP BY cost_mthd_code
12427: HAVING count(*) > 0
12428: UNION

Line 12432: FROM cm_rsrc_dtl

12428: UNION
12429: SELECT ''PERIOD_ID'' column_name,
12430: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12431: count(*) records
12432: FROM cm_rsrc_dtl
12433: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12434: GROUP BY calendar_code, period_code
12435: HAVING count(*) > 0
12436: UNION

Line 12440: FROM cm_rsrc_dtl

12436: UNION
12437: SELECT ''USAGE_UOM'' column_name,
12438: ''UM Code: ''|| usage_um parameters,
12439: count(*) records
12440: FROM cm_rsrc_dtl
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';

Line 12444: ) cm_rsrc_dtl';

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

Line 13367: * Migration Error Logging for table CM_RSRC_DTL *

13363: RETURN;
13364: END IF;
13365: IF p_log_level IN (1, 2) THEN
13366: /************************************************
13367: * Migration Error Logging for table CM_RSRC_DTL *
13368: ************************************************/
13369: IF l_table_name IN ('CM_RSRC_DTL') THEN
13370: IF p_log_level = 1 THEN
13371: l_sql_statement := l_sql_statement

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

13365: IF p_log_level IN (1, 2) THEN
13366: /************************************************
13367: * Migration Error Logging for table CM_RSRC_DTL *
13368: ************************************************/
13369: IF l_table_name IN ('CM_RSRC_DTL') THEN
13370: IF p_log_level = 1 THEN
13371: l_sql_statement := l_sql_statement
13372: ||
13373: '( (legal_entity_id IS NULL AND orgn_code IS NOT NULL)

Line 13395: FROM cm_rsrc_dtl;

13391: l_cost_type_count,
13392: l_period_count,
13393: l_uom_count1,
13394: l_organization_count
13395: FROM cm_rsrc_dtl;
13396: END IF;
13397: END IF;
13398: /************************************************
13399: * Migration Error Logging for table CM_ADJS_DTL *

Line 13974: IF l_table_name = 'CM_RSRC_DTL' THEN

13970: FROM gl_subr_sta;
13971: END IF;
13972: END IF;
13973: ELSIF p_log_level = 3 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

Line 13975: OPEN cur_gmf_log_errors FOR l_cm_rsrc_dtl;

13971: END IF;
13972: END IF;
13973: ELSIF p_log_level = 3 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;