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 10959: FROM cm_cmpt_dtl a,

10955: AND a.whse_code = b.whse_code
10956: UNION
10957: SELECT a.item_id,
10958: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10959: FROM cm_cmpt_dtl a,
10960: ic_whse_mst b
10961: WHERE a.item_id IS NOT NULL
10962: AND a.whse_code = b.whse_code
10963: UNION

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

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

Line 12497: cm_cmpt_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,
12500: ''Warehouse Code: ''|| whse_code parameters,
12501: count(*) records

Line 12502: FROM cm_cmpt_dtl

12498: FROM (
12499: SELECT ''ORGANIZATION_ID'' column_name,
12500: ''Warehouse Code: ''|| whse_code parameters,
12501: count(*) records
12502: FROM cm_cmpt_dtl
12503: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12504: GROUP BY whse_code
12505: HAVING count(*) > 0
12506: UNION

Line 12510: FROM cm_cmpt_dtl a, ic_item_mst b

12506: UNION
12507: SELECT ''INVENTORY_ITEM_ID'' column_name,
12508: ''Item No: ''|| b.item_no parameters,
12509: count(*) records
12510: FROM cm_cmpt_dtl a, ic_item_mst b
12511: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12512: AND b.item_id = a.item_id
12513: GROUP BY b.item_no
12514: HAVING count(*) > 0

Line 12519: FROM cm_cmpt_dtl

12515: UNION
12516: SELECT ''COST_TYPE_ID'' column_name,
12517: ''Cost Method Code: ''|| cost_mthd_code parameters,
12518: count(*) records
12519: FROM cm_cmpt_dtl
12520: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12521: GROUP BY cost_mthd_code
12522: HAVING count(*) > 0
12523: UNION

Line 12527: FROM cm_cmpt_dtl

12523: UNION
12524: SELECT ''PERIOD_ID'' column_name,
12525: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12526: count(*) records
12527: FROM cm_cmpt_dtl
12528: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12529: GROUP BY calendar_code, period_code
12530: HAVING count(*) > 0
12531: ) cm_cmpt_dtl';

Line 12531: ) cm_cmpt_dtl';

12527: FROM cm_cmpt_dtl
12528: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12529: GROUP BY calendar_code, period_code
12530: HAVING count(*) > 0
12531: ) cm_cmpt_dtl';
12532: l_cm_brdn_dtl VARCHAR2(32000) := 'SELECT ''CM_BRDN_DTL'' table_name,
12533: cm_brdn_dtl.*
12534: FROM (
12535: SELECT ''ORGANIZATION_ID'' column_name,

Line 13434: * Migration Error Logging for table CM_CMPT_DTL *

13430: FROM cm_adjs_dtl;
13431: END IF;
13432: END IF;
13433: /************************************************
13434: * Migration Error Logging for table CM_CMPT_DTL *
13435: ************************************************/
13436: IF l_table_name IN ('CM_CMPT_DTL') THEN
13437: IF p_log_level = 1 THEN
13438: l_sql_statement := l_sql_statement

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

13432: END IF;
13433: /************************************************
13434: * Migration Error Logging for table CM_CMPT_DTL *
13435: ************************************************/
13436: IF l_table_name IN ('CM_CMPT_DTL') THEN
13437: IF p_log_level = 1 THEN
13438: l_sql_statement := l_sql_statement
13439: ||
13440: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13459: FROM cm_cmpt_dtl;

13455: INTO l_organization_count,
13456: l_inventory_item_count,
13457: l_cost_type_count,
13458: l_period_count
13459: FROM cm_cmpt_dtl;
13460: END IF;
13461: END IF;
13462: /************************************************
13463: * Migration Error Logging for table CM_BRDN_DTL *

Line 13982: ELSIF l_table_name = 'CM_CMPT_DTL' THEN

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;
13984: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13985: CLOSE cur_gmf_log_errors;
13986: ELSIF l_table_name = 'CM_BRDN_DTL' THEN

Line 13983: OPEN cur_gmf_log_errors FOR l_cm_cmpt_dtl;

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;
13984: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13985: CLOSE cur_gmf_log_errors;
13986: ELSIF l_table_name = 'CM_BRDN_DTL' THEN
13987: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;