APPS.ZPB_DHMINTERFACE_GRP dependencies on FEM_XDIM_DIMENSIONS

Line 155: from FEM_XDIM_DIMENSIONS A,

151: A.MEMBER_B_TABLE_NAME,
152: A.MEMBER_COL,
153: B.ATTRIBUTE_ID,
154: B.ATTRIBUTE_VARCHAR_LABEL
155: from FEM_XDIM_DIMENSIONS A,
156: FEM_DIM_ATTRIBUTES_B B
157: where A.DIMENSION_ID = B.ATTRIBUTE_DIMENSION_ID
158: and B.DIMENSION_ID = 14
159: and B.ATTRIBUTE_VARCHAR_LABEL in

Line 177: FEM_XDIM_DIMENSIONS b

173: select a.ATTRIBUTE_ID,
174: decode (b.DIMENSION_TYPE_CODE, 'LINE', 'L', to_char(a.DIMENSION_ID))
175: DIMENSION_ID
176: from FEM_DIM_ATTRIBUTES_B a,
177: FEM_XDIM_DIMENSIONS b
178: where a.ATTRIBUTE_DIMENSION_ID = p_dimension_id
179: and a.DIMENSION_ID = b.DIMENSION_ID ;
180: begin
181: SAVEPOINT Export_Dimension_Grp;

Line 237: FEM_XDIM_DIMENSIONS

233: l_dim_value_sets,
234: l_dim_table_name,
235: l_dim_type
236: from
237: FEM_XDIM_DIMENSIONS
238: where
239: DIMENSION_ID = p_dimension_id;
240:
241: --

Line 1614: FEM_XDIM_DIMENSIONS

1610: l_dim_value_sets,
1611: l_dim_table_name,
1612: l_dim_type
1613: from
1614: FEM_XDIM_DIMENSIONS
1615: where
1616: DIMENSION_ID = p_dimension_id;
1617:
1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);