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_GL_CCID_C dependencies on FII_DIM_MAPPING_RULES

Line 952: -- This is wrong: Update FII_DIM_MAPPING_RULES to force

948: FII_UTIL.TRUNCATE_TABLE('FII_GL_CCID_DIMENSIONS',g_fii_schema,g_retcode);
949:
950: --------------------------------------------------------------------------
951: --Bug 3205051: we should not force re-summarization for CCID initial load
952: -- This is wrong: Update FII_DIM_MAPPING_RULES to force
953: -- using product assignments
954: --*UPDATE fii_dim_mapping_rules
955: --* SET status_code = 'O',
956: --* last_update_date = sysdate,

Line 954: --*UPDATE fii_dim_mapping_rules

950: --------------------------------------------------------------------------
951: --Bug 3205051: we should not force re-summarization for CCID initial load
952: -- This is wrong: Update FII_DIM_MAPPING_RULES to force
953: -- using product assignments
954: --*UPDATE fii_dim_mapping_rules
955: --* SET status_code = 'O',
956: --* last_update_date = sysdate,
957: --* last_update_login = g_fii_login_id,
958: --* last_updated_by = g_fii_user_id

Line 1003: -- with FII_DIM_MAPPING_RULES the value set id is also populated.

999: -- These information are needed to build the dynamic SQL
1000: -- in the INSERT_INTO_CCID API.
1001: -- For supporting UD1/UD2 dimensions as well segment names for
1002: -- these two dimensions are also populated. Also to avoid join
1003: -- with FII_DIM_MAPPING_RULES the value set id is also populated.
1004: ------------------------------------------------------------------
1005:
1006: FII_UTIL.TRUNCATE_TABLE('FII_ACCT_SEG_GT', g_fii_schema, g_retcode);
1007:

Line 1049: -- with FII_DIM_MAPPING_RULES in INSERT_INTO_CCID_DIM_INIT/INSERT_INTO_CCID_DIM

1045:
1046: --------------------------------------------------------------------------------
1047: -- For supporting UD1/UD2 dimensions as well segment names for
1048: -- these two dimensions are also populated. Also to avoid join
1049: -- with FII_DIM_MAPPING_RULES in INSERT_INTO_CCID_DIM_INIT/INSERT_INTO_CCID_DIM
1050: -- the value set id is also populated.
1051: --------------------------------------------------------------------------------
1052:
1053: IF(G_UD1_ENABLED = 'Y' ) THEN

Line 1057: from fii_dim_mapping_rules

1053: IF(G_UD1_ENABLED = 'Y' ) THEN
1054: g_dimension_name := 'FII_USER_DEFINED_1';
1055: UPDATE FII_ACCT_SEG_GT tab1
1056: SET (udd1_seg_name, udd1_vset_id) = (select application_column_name1, flex_value_set_id1
1057: from fii_dim_mapping_rules
1058: where chart_of_accounts_id = tab1.coa_id
1059: and dimension_short_name = g_dimension_name);
1060: END IF;
1061:

Line 1070: from fii_dim_mapping_rules

1066: IF(G_UD2_ENABLED = 'Y' ) THEN
1067: g_dimension_name := 'FII_USER_DEFINED_2';
1068: UPDATE FII_ACCT_SEG_GT tab1
1069: SET (udd2_seg_name, udd2_vset_id) = (select application_column_name1, flex_value_set_id1
1070: from fii_dim_mapping_rules
1071: where chart_of_accounts_id = tab1.coa_id
1072: and dimension_short_name = g_dimension_name);
1073: END IF;
1074:

Line 1582: fii_dim_mapping_rules map

1578: NVL(map.application_column_name1,'NO_PROD_COLUMN') prod_seg,
1579: map.mapping_type_code assignment_type_code,
1580: 'FALSE' fact_resummarization_needed
1581: FROM fii_gl_ccid_dimensions gcc,
1582: fii_dim_mapping_rules map
1583: WHERE gcc.chart_of_accounts_id = map.chart_of_accounts_id
1584: AND map.dimension_short_name = g_dimension_name
1585: AND gcc.code_combination_id > g_max_ccid
1586: UNION ALL

Line 1591: FROM fii_dim_mapping_rules

1587: SELECT chart_of_accounts_id coa_id,
1588: NVL(application_column_name1,'NO_PROD_COLUMN') prod_seg,
1589: mapping_type_code assignment_type_code,
1590: 'TRUE' fact_resummarization_needed
1591: FROM fii_dim_mapping_rules
1592: WHERE dimension_short_name = g_dimension_name
1593: AND status_code = 'O')
1594: order by 1;
1595:

Line 1650: -- in FII_DIM_MAPPING_RULES table

1646: ---------------------------------------------------
1647: -- Check if the assignment type is 'Single Segment'
1648: -- If assignment type is 'Single Segment', then the
1649: -- product segment column name need to be defined
1650: -- in FII_DIM_MAPPING_RULES table
1651: ---------------------------------------------------
1652: IF (l_prod_seg = 'NO_PROD_COLUMN' AND l_assignment_code = 'S') THEN
1653:
1654: ---------------------------------------------

Line 1669: -- FII_DIM_MAPPING_RULES table

1665: ------------------------------------------------
1666: -- Print out translated message to let user know
1667: -- certain chart of accounts does not have
1668: -- product assignment defined in
1669: -- FII_DIM_MAPPING_RULES table
1670: -------------------------------------------------
1671: FII_MESSAGE.write_output(
1672: msg_name => 'FII_COA_PROD_UNASSIGN',
1673: token_num => 1,

Line 1753: g_phase:= 'Updating FII_DIM_MAPPING_RULES to indicate product assignments are now current';

1749: If g_debug_flag = 'Y' then
1750: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CHANGE_LOG');
1751: End if;
1752:
1753: g_phase:= 'Updating FII_DIM_MAPPING_RULES to indicate product assignments are now current';
1754: If g_debug_flag = 'Y' then
1755: FII_UTIL.Write_Log(g_phase);
1756: End if;
1757:

Line 1761: UPDATE fii_dim_mapping_rules

1757:
1758: -- Bug 4152799
1759: g_dimension_name := 'ENI_ITEM_VBH_CAT';
1760:
1761: UPDATE fii_dim_mapping_rules
1762: SET status_code = 'C',
1763: last_update_date = sysdate,
1764: last_update_login = g_fii_login_id,
1765: last_updated_by = g_fii_user_id

Line 1770: FII_UTIL.Write_Log ('Updated ' || SQL%ROWCOUNT || ' records in FII_DIM_MAPPING_RULES');

1766: WHERE dimension_short_name = g_dimension_name
1767: AND status_code = 'O';
1768:
1769: If g_debug_flag = 'Y' then
1770: FII_UTIL.Write_Log ('Updated ' || SQL%ROWCOUNT || ' records in FII_DIM_MAPPING_RULES');
1771: End if;
1772: END IF;
1773:
1774: If g_debug_flag = 'Y' then

Line 2180: --Bug 3401590: should not update FII_DIM_MAPPING_RULES here

2176:
2177: FII_UTIL.TRUNCATE_TABLE ('FII_GL_CCID_DIMENSIONS', g_fii_schema, g_retcode);
2178:
2179: -------------------------------------------------------------------
2180: --Bug 3401590: should not update FII_DIM_MAPPING_RULES here
2181: --
2182: --**Update FII_DIM_MAPPING_RULES to force using product assignments
2183: --UPDATE fii_dim_mapping_rules
2184: -- SET status_code = 'O',

Line 2182: --**Update FII_DIM_MAPPING_RULES to force using product assignments

2178:
2179: -------------------------------------------------------------------
2180: --Bug 3401590: should not update FII_DIM_MAPPING_RULES here
2181: --
2182: --**Update FII_DIM_MAPPING_RULES to force using product assignments
2183: --UPDATE fii_dim_mapping_rules
2184: -- SET status_code = 'O',
2185: -- last_update_date = sysdate,
2186: -- last_update_login = g_fii_login_id,

Line 2183: --UPDATE fii_dim_mapping_rules

2179: -------------------------------------------------------------------
2180: --Bug 3401590: should not update FII_DIM_MAPPING_RULES here
2181: --
2182: --**Update FII_DIM_MAPPING_RULES to force using product assignments
2183: --UPDATE fii_dim_mapping_rules
2184: -- SET status_code = 'O',
2185: -- last_update_date = sysdate,
2186: -- last_update_login = g_fii_login_id,
2187: -- last_updated_by = g_fii_user_id