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 10952: FROM cm_brdn_dtl a,

10948: AND a.whse_code = b.whse_code
10949: UNION
10950: SELECT a.item_id,
10951: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10952: FROM cm_brdn_dtl a,
10953: ic_whse_mst b
10954: WHERE a.item_id IS NOT NULL
10955: AND a.whse_code = b.whse_code
10956: UNION

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

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

Line 12533: cm_brdn_dtl.*

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

Line 12538: FROM cm_brdn_dtl

12534: FROM (
12535: SELECT ''ORGANIZATION_ID'' column_name,
12536: ''Warehouse Code: ''|| whse_code parameters,
12537: count(*) records
12538: FROM cm_brdn_dtl
12539: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12540: GROUP BY whse_code
12541: HAVING count(*) > 0
12542: UNION

Line 12546: FROM cm_brdn_dtl a, ic_item_mst b

12542: UNION
12543: SELECT ''INVENTORY_ITEM_ID'' column_name,
12544: ''Item No: ''|| b.item_no parameters,
12545: count(*) records
12546: FROM cm_brdn_dtl a, ic_item_mst b
12547: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12548: AND b.item_id = a.item_id
12549: GROUP BY b.item_no
12550: HAVING count(*) > 0

Line 12555: FROM cm_brdn_dtl

12551: UNION
12552: SELECT ''COST_TYPE_ID'' column_name,
12553: ''Cost Method Code: ''|| cost_mthd_code parameters,
12554: count(*) records
12555: FROM cm_brdn_dtl
12556: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12557: GROUP BY cost_mthd_code
12558: HAVING count(*) > 0
12559: UNION

Line 12563: FROM cm_brdn_dtl

12559: UNION
12560: SELECT ''PERIOD_ID'' column_name,
12561: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12562: count(*) records
12563: FROM cm_brdn_dtl
12564: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12565: GROUP BY calendar_code, period_code
12566: HAVING count(*) > 0
12567: UNION

Line 12571: FROM cm_brdn_dtl

12567: UNION
12568: SELECT ''ITEM_UOM'' column_name,
12569: ''Item UM: ''|| item_um parameters,
12570: count(*) records
12571: FROM cm_brdn_dtl
12572: WHERE (item_uom IS NULL AND item_um IS NOT NULL)
12573: GROUP BY item_um
12574: HAVING count(*) > 0
12575: UNION

Line 12579: FROM cm_brdn_dtl

12575: UNION
12576: SELECT ''BURDEN_UOM'' column_name,
12577: ''Burden UM: ''|| burden_um parameters,
12578: count(*) records
12579: FROM cm_brdn_dtl
12580: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12581: GROUP BY burden_um
12582: HAVING count(*) > 0
12583: ) cm_brdn_dtl';

Line 12583: ) cm_brdn_dtl';

12579: FROM cm_brdn_dtl
12580: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12581: GROUP BY burden_um
12582: HAVING count(*) > 0
12583: ) cm_brdn_dtl';
12584: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12585: gl_item_cst.*
12586: FROM (
12587: SELECT ''ORGANIZATION_ID'' column_name,

Line 13463: * Migration Error Logging for table CM_BRDN_DTL *

13459: FROM cm_cmpt_dtl;
13460: END IF;
13461: END IF;
13462: /************************************************
13463: * Migration Error Logging for table CM_BRDN_DTL *
13464: ************************************************/
13465: IF l_table_name IN ('CM_BRDN_DTL') THEN
13466: IF p_log_level = 1 THEN
13467: l_sql_statement := l_sql_statement

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

13461: END IF;
13462: /************************************************
13463: * Migration Error Logging for table CM_BRDN_DTL *
13464: ************************************************/
13465: IF l_table_name IN ('CM_BRDN_DTL') THEN
13466: IF p_log_level = 1 THEN
13467: l_sql_statement := l_sql_statement
13468: ||
13469: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13494: FROM cm_brdn_dtl;

13490: l_cost_type_count,
13491: l_period_count,
13492: l_uom_count1,
13493: l_uom_count2
13494: FROM cm_brdn_dtl;
13495: END IF;
13496: END IF;
13497: /************************************************
13498: * Migration Error Logging for table GL_ITEM_CST *

Line 13986: ELSIF l_table_name = 'CM_BRDN_DTL' THEN

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;
13988: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13989: CLOSE cur_gmf_log_errors;
13990: ELSIF l_table_name = 'GL_ITEM_CST' THEN

Line 13987: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;

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;
13988: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13989: CLOSE cur_gmf_log_errors;
13990: ELSIF l_table_name = 'GL_ITEM_CST' THEN
13991: OPEN cur_gmf_log_errors FOR l_gl_item_cst;