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.FII_BUDGET_FORECAST_C dependencies on FII_DIM_MAPPING_RULES

Line 2077: FII_DIM_MAPPING_RULES r,

2073: nvl(i.company, '-1'), f.ledger_id
2074: FROM FII_BUDGET_INTERFACE i,
2075: (SELECT DISTINCT fv.flex_value_id, int.company, int.ledger_id
2076: FROM FII_BUDGET_INTERFACE int,
2077: FII_DIM_MAPPING_RULES r,
2078: FND_FLEX_VALUES fv,
2079: GL_LEDGERS_PUBLIC_V sob
2080: WHERE r.dimension_short_name = 'FII_COMPANIES'
2081: AND r.chart_of_accounts_id = sob.chart_of_accounts_id

Line 2094: FII_DIM_MAPPING_RULES r,

2090: nvl(i.cost_center, '-1'), f.ledger_id
2091: FROM FII_BUDGET_INTERFACE i,
2092: (SELECT DISTINCT fv.flex_value_id, int.cost_center, int.ledger_id
2093: FROM FII_BUDGET_INTERFACE int,
2094: FII_DIM_MAPPING_RULES r,
2095: FND_FLEX_VALUES fv,
2096: GL_LEDGERS_PUBLIC_V sob
2097: WHERE r.dimension_short_name = 'HRI_CL_ORGCC'
2098: AND r.chart_of_accounts_id = sob.chart_of_accounts_id

Line 2119: FROM FII_DIM_MAPPING_RULES r,

2115: SELECT DISTINCT nvl(f.flex_value_id, i.fin_category_id),
2116: nvl(i.fin_item, '-1'), f.ledger_id
2117: FROM FII_BUDGET_INTERFACE i,
2118: (SELECT DISTINCT fv.flex_value_id, int.fin_item, int.ledger_id
2119: FROM FII_DIM_MAPPING_RULES r,
2120: FII_BUDGET_INTERFACE int,
2121: FND_FLEX_VALUES fv,
2122: GL_LEDGERS_PUBLIC_V sob
2123: WHERE r.dimension_short_name = 'GL_FII_FIN_ITEM'

Line 2137: FROM FII_DIM_MAPPING_RULES r,

2133: SELECT DISTINCT nvl(f.flex_value_id, FIIBUUP_UNASSIGNED_UDD_ID),
2134: nvl(i.user_dim1, 'UNASSIGNED'), f.ledger_id
2135: FROM FII_BUDGET_INTERFACE i,
2136: (SELECT DISTINCT fv.flex_value_id, int.user_dim1 , int.ledger_id
2137: FROM FII_DIM_MAPPING_RULES r,
2138: FII_BUDGET_INTERFACE int,
2139: FND_FLEX_VALUES fv,
2140: GL_LEDGERS_PUBLIC_V sob
2141: WHERE r.dimension_short_name = 'FII_USER_DEFINED_1'

Line 2500: FII_DIM_MAPPING_RULES mr,

2496: NOT EXISTS (
2497: SELECT '1'
2498: FROM FND_FLEX_VALUES fv,
2499: FND_ID_FLEX_SEGMENTS fs,
2500: FII_DIM_MAPPING_RULES mr,
2501: FND_SEGMENT_ATTRIBUTE_VALUES b
2502: WHERE fs.application_id = 101
2503: AND fs.id_flex_code = 'GL#'
2504: AND fs.id_flex_num = mr.chart_of_accounts_id

Line 2536: FII_DIM_MAPPING_RULES mr,

2532: NOT EXISTS (
2533: SELECT '1'
2534: FROM FND_FLEX_VALUES fv,
2535: FND_ID_FLEX_SEGMENTS fs,
2536: FII_DIM_MAPPING_RULES mr,
2537: FND_SEGMENT_ATTRIBUTE_VALUES b
2538: WHERE fs.application_id = 101
2539: AND fs.id_flex_code = 'GL#'
2540: AND fs.id_flex_num = mr.chart_of_accounts_id

Line 2573: fii_dim_mapping_rules mr

2569: SELECT '1'
2570: FROM fnd_flex_values fv,
2571: fnd_id_flex_segments fs,
2572: fnd_segment_attribute_values b,
2573: fii_dim_mapping_rules mr
2574: WHERE fs.application_id = 101
2575: AND fs.id_flex_code = 'GL#'
2576: AND fs.id_flex_num = mr.chart_of_accounts_id
2577: -- AND fs.application_column_name = mr.application_column_name1

Line 2611: fii_dim_mapping_rules mr

2607: (nvl(b.user_dim1_id, -1) NOT IN (
2608: SELECT fv.flex_value_id
2609: FROM fnd_flex_values fv,
2610: fnd_id_flex_segments fs,
2611: fii_dim_mapping_rules mr
2612: WHERE fs.application_id = 101
2613: AND fs.id_flex_code = 'GL#'
2614: AND fs.id_flex_num = mr.chart_of_accounts_id
2615: AND fs.application_column_name = mr.application_column_name1