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_BRDN_DTL

Line 2972: SELECT 'CM_BRDN_DTL'

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
2971: UNION
2972: SELECT 'CM_BRDN_DTL'
2973: FROM cm_brdn_dtl a
2974: WHERE a.calendar_code is not null
2975: AND a.cost_mthd_Code is not null
2976: AND a.calendar_code = g.calendar_code

Line 2973: FROM cm_brdn_dtl a

2969: AND a.calendar_code = g.calendar_code
2970: AND a.cost_mthd_code = h.cost_mthd_code
2971: UNION
2972: SELECT 'CM_BRDN_DTL'
2973: FROM cm_brdn_dtl a
2974: WHERE a.calendar_code is not null
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

Line 3153: * Insert a row in gmf_calendar_assignments for CM_BRDN_DTL table data *

3149: );
3150: END;
3151:
3152: /**********************************************************************
3153: * Insert a row in gmf_calendar_assignments for CM_BRDN_DTL table data *
3154: **********************************************************************/
3155: BEGIN
3156:
3157: INSERT INTO gmf_calendar_assignments

Line 3190: cm_brdn_dtl k

3186: FROM cm_cldr_hdr_b g,
3187: cm_mthd_mst h,
3188: gl_plcy_mst i,
3189: sy_orgn_mst j,
3190: cm_brdn_dtl k
3191: WHERE g.co_code IS NOT NULL
3192: AND j.orgn_code = k.orgn_code
3193: AND i.co_code = j.co_code
3194: AND i.legal_entity_id IS NOT NULL

Line 10622: FROM cm_brdn_dtl a,

10618: AND a.whse_code = b.whse_code
10619: UNION
10620: SELECT a.item_id,
10621: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10622: FROM cm_brdn_dtl a,
10623: ic_whse_mst b
10624: WHERE a.item_id IS NOT NULL
10625: AND a.whse_code = b.whse_code
10626: UNION

Line 12201: l_cm_brdn_dtl VARCHAR2(32000) := 'SELECT ''CM_BRDN_DTL'' table_name,

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

Line 12202: cm_brdn_dtl.*

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,
12205: ''Warehouse Code: ''|| whse_code parameters,
12206: count(*) records

Line 12207: FROM cm_brdn_dtl

12203: FROM (
12204: SELECT ''ORGANIZATION_ID'' column_name,
12205: ''Warehouse Code: ''|| whse_code parameters,
12206: count(*) records
12207: FROM cm_brdn_dtl
12208: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12209: GROUP BY whse_code
12210: HAVING count(*) > 0
12211: UNION

Line 12215: FROM cm_brdn_dtl a, ic_item_mst b

12211: UNION
12212: SELECT ''INVENTORY_ITEM_ID'' column_name,
12213: ''Item No: ''|| b.item_no parameters,
12214: count(*) records
12215: FROM cm_brdn_dtl a, ic_item_mst b
12216: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12217: AND b.item_id = a.item_id
12218: GROUP BY b.item_no
12219: HAVING count(*) > 0

Line 12224: FROM cm_brdn_dtl

12220: UNION
12221: SELECT ''COST_TYPE_ID'' column_name,
12222: ''Cost Method Code: ''|| cost_mthd_code parameters,
12223: count(*) records
12224: FROM cm_brdn_dtl
12225: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12226: GROUP BY cost_mthd_code
12227: HAVING count(*) > 0
12228: UNION

Line 12232: FROM cm_brdn_dtl

12228: UNION
12229: SELECT ''PERIOD_ID'' column_name,
12230: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12231: count(*) records
12232: FROM cm_brdn_dtl
12233: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12234: GROUP BY calendar_code, period_code
12235: HAVING count(*) > 0
12236: UNION

Line 12240: FROM cm_brdn_dtl

12236: UNION
12237: SELECT ''ITEM_UOM'' column_name,
12238: ''Item UM: ''|| item_um parameters,
12239: count(*) records
12240: FROM cm_brdn_dtl
12241: WHERE (item_uom IS NULL AND item_um IS NOT NULL)
12242: GROUP BY item_um
12243: HAVING count(*) > 0
12244: UNION

Line 12248: FROM cm_brdn_dtl

12244: UNION
12245: SELECT ''BURDEN_UOM'' column_name,
12246: ''Burden UM: ''|| burden_um parameters,
12247: count(*) records
12248: FROM cm_brdn_dtl
12249: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12250: GROUP BY burden_um
12251: HAVING count(*) > 0
12252: ) cm_brdn_dtl';

Line 12252: ) cm_brdn_dtl';

12248: FROM cm_brdn_dtl
12249: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12250: GROUP BY burden_um
12251: HAVING count(*) > 0
12252: ) cm_brdn_dtl';
12253: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12254: gl_item_cst.*
12255: FROM (
12256: SELECT ''ORGANIZATION_ID'' column_name,

Line 13132: * Migration Error Logging for table CM_BRDN_DTL *

13128: FROM cm_cmpt_dtl;
13129: END IF;
13130: END IF;
13131: /************************************************
13132: * Migration Error Logging for table CM_BRDN_DTL *
13133: ************************************************/
13134: IF l_table_name IN ('CM_BRDN_DTL') THEN
13135: IF p_log_level = 1 THEN
13136: l_sql_statement := l_sql_statement

Line 13134: IF l_table_name IN ('CM_BRDN_DTL') THEN

13130: END IF;
13131: /************************************************
13132: * Migration Error Logging for table CM_BRDN_DTL *
13133: ************************************************/
13134: IF l_table_name IN ('CM_BRDN_DTL') THEN
13135: IF p_log_level = 1 THEN
13136: l_sql_statement := l_sql_statement
13137: ||
13138: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13163: FROM cm_brdn_dtl;

13159: l_cost_type_count,
13160: l_period_count,
13161: l_uom_count1,
13162: l_uom_count2
13163: FROM cm_brdn_dtl;
13164: END IF;
13165: END IF;
13166: /************************************************
13167: * Migration Error Logging for table GL_ITEM_CST *

Line 13655: ELSIF l_table_name = 'CM_BRDN_DTL' THEN

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;
13657: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13658: CLOSE cur_gmf_log_errors;
13659: ELSIF l_table_name = 'GL_ITEM_CST' THEN

Line 13656: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;

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;
13657: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13658: CLOSE cur_gmf_log_errors;
13659: ELSIF l_table_name = 'GL_ITEM_CST' THEN
13660: OPEN cur_gmf_log_errors FOR l_gl_item_cst;