DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 232: FEM_DIM_ATTR_VERSIONS_B E

228: from FEM_GLOBAL_VS_COMBO_DEFS A,
229: FEM_VALUE_SETS_VL B,
230: FEM_LEDGERS_ATTR C,
231: FEM_DIM_ATTRIBUTES_B D,
232: FEM_DIM_ATTR_VERSIONS_B E
233: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
234: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
235: and E.DEFAULT_VERSION_FLAG = 'Y'
236: and C.ATTRIBUTE_ID = D.ATTRIBUTE_ID

Line 265: FEM_DIM_ATTR_VERSIONS_B C, '||l_dim_table||' D

261: and B.DIMENSION_VARCHAR_LABEL = 'CALENDAR';
262:
263: l_command := 'select A.DIM_ATTRIBUTE_NUMERIC_MEMBER
264: from '||l_attr_table||' A, FEM_DIM_ATTRIBUTES_B B,
265: FEM_DIM_ATTR_VERSIONS_B C, '||l_dim_table||' D
266: where A.'||l_cal_dim_col||' = D.'||l_cal_dim_col||'
267: and D.'||l_cal_dim_code||' = '''||l_def_mbr_code||'''
268: and A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
269: and A.ATTRIBUTE_ID = C.ATTRIBUTE_ID