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.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 72: REM | to update RELATION_COL in BSC_SYS_DIM_LEVEL_RELS |

68: REM | 08-Feb-04 skchoudh Enh#3873195 drill_to_form_function column |
69: REM | is added |
70: REM | 14-FEB-2005 ashankar modified Alter_One_By_N_Tables and |
71: REM | Alter_M_By_N_Tables.Added the cascading logic |
72: REM | to update RELATION_COL in BSC_SYS_DIM_LEVEL_RELS |
73: REM | 15-FEB-05 ppandey Enh #4016669, support ID, Value for Autogen DO |
74: REM | 16-FEB-2005 ashankar Bug#4184438 Added the Synch Up API |
75: REM | BSC_SYNC_MVLOGS.Sync_dim_table_mv_log |
76: REM | 11-Mar-05 ankgoel Enh#2690720 - AG Report enh |

Line 324: FROM BSC_SYS_DIM_LEVEL_RELS

320: l_child_dim_obj VARCHAR2(32000);
321:
322: CURSOR c_Dim_Level_Child IS
323: SELECT dim_level_id
324: FROM BSC_SYS_DIM_LEVEL_RELS
325: WHERE parent_dim_level_id = p_Dim_Level_Id
326: AND RELATION_TYPE <> 2;
327:
328: BEGIN

Line 481: UPDATE bsc_sys_dim_level_rels

477: BEGIN
478: BSC_APPS.Init_Bsc_Apps;
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480:
481: UPDATE bsc_sys_dim_level_rels
482: SET relation_col = p_Relation_Col
483: WHERE dim_level_id = p_Dim_Level_Id
484: AND parent_dim_level_id = p_Parent_Dim_Level_Id
485: AND relation_type = 2;

Line 487: UPDATE bsc_sys_dim_level_rels

483: WHERE dim_level_id = p_Dim_Level_Id
484: AND parent_dim_level_id = p_Parent_Dim_Level_Id
485: AND relation_type = 2;
486:
487: UPDATE bsc_sys_dim_level_rels
488: SET relation_col = p_Relation_Col
489: WHERE dim_level_id = p_Parent_Dim_Level_Id
490: AND parent_dim_level_id = p_Dim_Level_Id
491: AND relation_type = 2;

Line 3496: FROM BSC_SYS_DIM_LEVEL_RELS

3492: END IF;
3493:
3494: --check if the dimension is associated in relationships, if so raise an exception
3495: SELECT COUNT(1) INTO l_count
3496: FROM BSC_SYS_DIM_LEVEL_RELS
3497: WHERE dim_level_id = l_bsc_dim_id
3498: OR parent_dim_level_id = l_bsc_dim_id;
3499: IF (l_count > 0) THEN
3500: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_OBJ_RELS');

Line 4065: bsc_sys_dim_level_rels_v b

4061: (SELECT level_pk_col
4062: FROM bsc_sys_dim_levels_b
4063: WHERE dim_level_id =b.parent_dim_level_id) AS pk_col
4064: FROM
4065: bsc_sys_dim_level_rels_v b
4066: WHERE
4067: b.dim_level_id= p_Dim_Level_Rec.Bsc_Level_Id;
4068: BEGIN
4069: FND_MSG_PUB.Initialize;

Line 4547: FROM bsc_sys_dim_level_rels

4543:
4544: --cursor to see, if this dimension object is used in many to many relations
4545: CURSOR c_rel_type IS
4546: SELECT parent_dim_level_id
4547: FROM bsc_sys_dim_level_rels
4548: WHERE dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
4549: AND relation_type = 2;
4550:
4551: CURSOR c_db_tables IS

Line 4562: FROM BSC_SYS_DIM_LEVEL_RELS A

4558: AND (UPPER(COL.Column_Name)) = UPPER(p_Dim_Level_Rec.Bsc_Pk_Col);
4559:
4560: CURSOR c_One_To_N_Index IS
4561: SELECT B.Level_Pk_Col
4562: FROM BSC_SYS_DIM_LEVEL_RELS A
4563: , BSC_SYS_DIM_LEVELS_B B
4564: WHERE A.Dim_Level_Id = p_Dim_Level_Rec.Bsc_Level_Id
4565: AND B.Dim_Level_Id = A.Parent_Dim_Level_Id
4566: AND A.Relation_Type = 1;

Line 4864: FROM BSC_SYS_DIM_LEVEL_RELS

4860: l_error_msg VARCHAR2(4000);
4861:
4862: CURSOR c_MN_Tables IS
4863: SELECT Dim_Level_Id
4864: FROM BSC_SYS_DIM_LEVEL_RELS
4865: WHERE Parent_Dim_Level_Id = p_Dim_Level_Rec.Bsc_Level_Id
4866: AND Relation_Type = 2;
4867: BEGIN
4868: FND_MSG_PUB.Initialize;

Line 5140: FROM BSC_SYS_DIM_LEVEL_RELS

5136: AND INDEX_OWNER = BSC_APPS.get_user_schema;
5137:
5138: CURSOR c_One_by_N IS
5139: SELECT Dim_Level_Id
5140: FROM BSC_SYS_DIM_LEVEL_RELS
5141: WHERE parent_dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
5142: AND relation_type = 1;
5143: BEGIN
5144: FND_MSG_PUB.Initialize;

Line 5307: Here we need to update the relation_col column in BSC_SYS_DIM_LEVEL_RELS

5303: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5304: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5305:
5306: /********************************************************
5307: Here we need to update the relation_col column in BSC_SYS_DIM_LEVEL_RELS
5308: table whenever we are changing the level_pk_col of the parent.
5309: /*******************************************************/
5310: UPDATE BSC_SYS_DIM_LEVEL_RELS
5311: SET RELATION_COL = p_Dim_Level_Rec.Bsc_Pk_Col

Line 5310: UPDATE BSC_SYS_DIM_LEVEL_RELS

5306: /********************************************************
5307: Here we need to update the relation_col column in BSC_SYS_DIM_LEVEL_RELS
5308: table whenever we are changing the level_pk_col of the parent.
5309: /*******************************************************/
5310: UPDATE BSC_SYS_DIM_LEVEL_RELS
5311: SET RELATION_COL = p_Dim_Level_Rec.Bsc_Pk_Col
5312: WHERE dim_level_id = cd.Dim_Level_Id
5313: AND parent_dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
5314: AND relation_type = 1;

Line 6412: FROM BSC_SYS_DIM_LEVEL_RELS_V R

6408: CURSOR c_Rel_Levels IS
6409: SELECT R.SHORT_NAME CHILD_SHORT_NAME
6410: , R.RELATION_COL PARENT_COL
6411: , L.LEVEL_VALUES_VIEW_NAME VIEW_NAME
6412: FROM BSC_SYS_DIM_LEVEL_RELS_V R
6413: , BIS_LEVELS L
6414: WHERE R.SHORT_NAME = L.SHORT_NAME
6415: AND L.SHORT_NAME = p_Dim_Obj_Short_Name
6416: AND R.SOURCE = 'PMF';

Line 7013: FROM BSC_SYS_DIM_LEVEL_RELS_V R

7009: CURSOR c_Rels IS
7010: SELECT R.RELATION_COL,
7011: R.DATA_SOURCE,
7012: R.DATA_SOURCE_TYPE
7013: FROM BSC_SYS_DIM_LEVEL_RELS_V R
7014: WHERE R.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7015: AND R.SHORT_NAME = p_Short_Name
7016: AND R.PARENT_SHORT_NAME = p_Short_Name
7017: AND R.SOURCE = BSC_UTILITY.c_PMF