DBA Data[Home] [Help]

APPS.EDW_BSC_BRIDGE dependencies on EDW_FACT_DIM_RELATIONS_MD_V

Line 10: EDW_FACT_DIM_RELATIONS_MD_V.FACT_FK_COL_NAME%TYPE

6: measure_id EDW_FACT_ATTRIBUTES_MD_V.ATTRIBUTE_ID%TYPE
7: );
8:
9: TYPE FactDimColTable IS TABLE of
10: EDW_FACT_DIM_RELATIONS_MD_V.FACT_FK_COL_NAME%TYPE
11: INDEX BY BINARY_INTEGER;
12:
13: TYPE FactMeasureTable IS TABLE of
14: t_FactMeasure

Line 81: FROM EDW_FACT_DIM_RELATIONS_MD_V

77: --excuted once per fact, no need for tuning
78: CURSOR c_facttimedimcol(p_fact_name EDW_FACT_ATTRIBUTES_MD_V.FACT_NAME%TYPE) IS
79: SELECT
80: FACT_FK_COL_NAME
81: FROM EDW_FACT_DIM_RELATIONS_MD_V
82: WHERE
83: DIM_ID = v_time_dimension_id
84: -- use the cached id for better performance,
85: -- it is instanciated at the intialization.

Line 93: FROM EDW_FACT_DIM_RELATIONS_MD_V

89: --excuted once per fact, no need for tuning
90: CURSOR c_factnontimedimcol(p_fact_name EDW_FACT_ATTRIBUTES_MD_V.FACT_NAME%TYPE) IS
91: SELECT
92: FACT_FK_COL_NAME
93: FROM EDW_FACT_DIM_RELATIONS_MD_V
94: WHERE
95: DIM_ID <> v_time_dimension_id
96: -- use the cached id for better performance,
97: -- it is instanciated at the intialization.