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_BUDGET_BASE

Line 167: -- or FII_BUDGET_BASE should be mapped to the dimension table

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
171: --------------------------------------------------------------------------------

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 187: from FII_BUDGET_BASE

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,
189:
190: (SELECT fh.parent_COMPANY_id, fh.child_COMPANY_id
191: FROM FII_FULL_COMPANY_HIERS fh