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_COM_CC_DIM_MAPS_PKG dependencies on FII_GL_CCID_DIMENSIONS

Line 159: -- in FII_GL_CCID_DIMENSIONS which might not be present in the

155: g_phase := 'Insert into FII_COM_CC_DIM_MAP_GT';
156:
157: ------------------------------------------------------------------------------
158: -- There is a possibility of having Company_id and cost_center_id
159: -- in FII_GL_CCID_DIMENSIONS which might not be present in the
160: -- corresponding Dimension hierarchy (it might now be mapped)
161: -- To populate those id's also in FII_COM_CC_DIM_MAPS_GT
162: -- outer join is used.
163: -- Also since both Company and Cost Center Dimension can be mapped

Line 166: -- mapped to Balancing Segment then the Company_id from FII_GL_CCID_DIMENSIONS

162: -- outer join is used.
163: -- Also since both Company and Cost Center Dimension can be mapped
164: -- to either Balancing / Cost Center Segment so we need to identify
165: -- that the dimension is mapped to which segment. If the Dimension
166: -- mapped to Balancing Segment then the Company_id from FII_GL_CCID_DIMENSIONS
167: -- or FII_BUDGET_BASE should be mapped to the dimension table
168: -- and if the dimension is mapped to Cost Center Segment then
169: -- Cost_Center_id From FII_GL_CCID_DIMENSIONS and FII_BUDGET_BASE
170: -- should be mapped to the dimension table. Decode is used for this purpose

Line 169: -- Cost_Center_id From FII_GL_CCID_DIMENSIONS and FII_BUDGET_BASE

165: -- that the dimension is mapped to which segment. If the Dimension
166: -- mapped to Balancing Segment then the Company_id from FII_GL_CCID_DIMENSIONS
167: -- or FII_BUDGET_BASE should be mapped to the dimension table
168: -- and if the dimension is mapped to Cost Center Segment then
169: -- Cost_Center_id From FII_GL_CCID_DIMENSIONS and FII_BUDGET_BASE
170: -- should be mapped to the dimension table. Decode is used for this purpose
171: --------------------------------------------------------------------------------
172:
173: INSERT INTO FII_COM_CC_DIM_MAPS_GT (PARENT_COMPANY_DIM_ID,

Line 184: from FII_GL_CCID_DIMENSIONS

180: h2.parent_cc_id,
181: g.cost_center_id
182: FROM
183: (select distinct COMPANY_ID, COST_CENTER_ID
184: from FII_GL_CCID_DIMENSIONS
185: UNION
186: select distinct COMPANY_ID, COST_CENTER_ID
187: from FII_BUDGET_BASE
188: )g,