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_CMPT_DTL

Line 2965: SELECT 'CM_CMPT_DTL'

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
2964: UNION
2965: SELECT 'CM_CMPT_DTL'
2966: FROM cm_cmpt_dtl a
2967: WHERE a.calendar_code is not null
2968: AND a.cost_mthd_Code is not null
2969: AND a.calendar_code = g.calendar_code

Line 2966: FROM cm_cmpt_dtl a

2962: AND a.calendar_code = g.calendar_code
2963: AND a.cost_mthd_code = h.cost_mthd_code
2964: UNION
2965: SELECT 'CM_CMPT_DTL'
2966: FROM cm_cmpt_dtl a
2967: WHERE a.calendar_code is not null
2968: AND a.cost_mthd_Code is not null
2969: AND a.calendar_code = g.calendar_code
2970: AND a.cost_mthd_code = h.cost_mthd_code

Line 3249: * Insert a row in gmf_calendar_assignments for CM_CMPT_DTL table data *

3245: );
3246: END;
3247:
3248: /**********************************************************************
3249: * Insert a row in gmf_calendar_assignments for CM_CMPT_DTL table data *
3250: **********************************************************************/
3251: BEGIN
3252:
3253: INSERT INTO gmf_calendar_assignments

Line 3286: cm_cmpt_dtl k,

3282: FROM cm_cldr_hdr_b g,
3283: cm_mthd_mst h,
3284: gl_plcy_mst i,
3285: sy_orgn_mst j,
3286: cm_cmpt_dtl k,
3287: ic_whse_mst l
3288: WHERE g.co_code IS NOT NULL
3289: AND l.whse_code = k.whse_code
3290: AND j.orgn_code = l.orgn_code

Line 10629: FROM cm_cmpt_dtl a,

10625: AND a.whse_code = b.whse_code
10626: UNION
10627: SELECT a.item_id,
10628: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10629: FROM cm_cmpt_dtl a,
10630: ic_whse_mst b
10631: WHERE a.item_id IS NOT NULL
10632: AND a.whse_code = b.whse_code
10633: UNION

Line 12165: l_cm_cmpt_dtl VARCHAR2(32000) := 'SELECT ''CM_CMPT_DTL'' table_name,

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,
12169: ''Warehouse Code: ''|| whse_code parameters,

Line 12166: cm_cmpt_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,
12169: ''Warehouse Code: ''|| whse_code parameters,
12170: count(*) records

Line 12171: FROM cm_cmpt_dtl

12167: FROM (
12168: SELECT ''ORGANIZATION_ID'' column_name,
12169: ''Warehouse Code: ''|| whse_code parameters,
12170: count(*) records
12171: FROM cm_cmpt_dtl
12172: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12173: GROUP BY whse_code
12174: HAVING count(*) > 0
12175: UNION

Line 12179: FROM cm_cmpt_dtl a, ic_item_mst b

12175: UNION
12176: SELECT ''INVENTORY_ITEM_ID'' column_name,
12177: ''Item No: ''|| b.item_no parameters,
12178: count(*) records
12179: FROM cm_cmpt_dtl a, ic_item_mst b
12180: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12181: AND b.item_id = a.item_id
12182: GROUP BY b.item_no
12183: HAVING count(*) > 0

Line 12188: FROM cm_cmpt_dtl

12184: UNION
12185: SELECT ''COST_TYPE_ID'' column_name,
12186: ''Cost Method Code: ''|| cost_mthd_code parameters,
12187: count(*) records
12188: FROM cm_cmpt_dtl
12189: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12190: GROUP BY cost_mthd_code
12191: HAVING count(*) > 0
12192: UNION

Line 12196: FROM cm_cmpt_dtl

12192: UNION
12193: SELECT ''PERIOD_ID'' column_name,
12194: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12195: count(*) records
12196: FROM cm_cmpt_dtl
12197: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12198: GROUP BY calendar_code, period_code
12199: HAVING count(*) > 0
12200: ) cm_cmpt_dtl';

Line 12200: ) cm_cmpt_dtl';

12196: FROM cm_cmpt_dtl
12197: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12198: GROUP BY calendar_code, period_code
12199: HAVING count(*) > 0
12200: ) cm_cmpt_dtl';
12201: l_cm_brdn_dtl VARCHAR2(32000) := 'SELECT ''CM_BRDN_DTL'' table_name,
12202: cm_brdn_dtl.*
12203: FROM (
12204: SELECT ''ORGANIZATION_ID'' column_name,

Line 13103: * Migration Error Logging for table CM_CMPT_DTL *

13099: FROM cm_adjs_dtl;
13100: END IF;
13101: END IF;
13102: /************************************************
13103: * Migration Error Logging for table CM_CMPT_DTL *
13104: ************************************************/
13105: IF l_table_name IN ('CM_CMPT_DTL') THEN
13106: IF p_log_level = 1 THEN
13107: l_sql_statement := l_sql_statement

Line 13105: IF l_table_name IN ('CM_CMPT_DTL') THEN

13101: END IF;
13102: /************************************************
13103: * Migration Error Logging for table CM_CMPT_DTL *
13104: ************************************************/
13105: IF l_table_name IN ('CM_CMPT_DTL') THEN
13106: IF p_log_level = 1 THEN
13107: l_sql_statement := l_sql_statement
13108: ||
13109: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13128: FROM cm_cmpt_dtl;

13124: INTO l_organization_count,
13125: l_inventory_item_count,
13126: l_cost_type_count,
13127: l_period_count
13128: FROM cm_cmpt_dtl;
13129: END IF;
13130: END IF;
13131: /************************************************
13132: * Migration Error Logging for table CM_BRDN_DTL *

Line 13651: ELSIF l_table_name = 'CM_CMPT_DTL' THEN

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;
13653: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13654: CLOSE cur_gmf_log_errors;
13655: ELSIF l_table_name = 'CM_BRDN_DTL' THEN

Line 13652: OPEN cur_gmf_log_errors FOR l_cm_cmpt_dtl;

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;
13653: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13654: CLOSE cur_gmf_log_errors;
13655: ELSIF l_table_name = 'CM_BRDN_DTL' THEN
13656: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;