DBA Data[Home] [Help]

APPS.FEM_TABLE_PUBLISH_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 202: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

198: EnabledTableColumnEO.FEM_DATA_TYPE_CODE,
199: EnabledTableColumnEO.DIMENSION_ID,
200: DataInspectorColumnsEO.SORT_SEQUENCE,
201: DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
202: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
203: member_name_col,
204: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
205: member_code_col,
206: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

Line 204: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

200: DataInspectorColumnsEO.SORT_SEQUENCE,
201: DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
202: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
203: member_name_col,
204: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
205: member_code_col,
206: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
207: member_table_name,
208: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

Line 206: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

202: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
203: member_name_col,
204: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
205: member_code_col,
206: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
207: member_table_name,
208: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
209: dimension_varchar_label,
210: (select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,

Line 211: (select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col

207: member_table_name,
208: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
209: dimension_varchar_label,
210: (select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,
211: (select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col
212: FROM FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,
213: FEM_TAB_COLUMNS_V EnabledTableColumnEO
214: WHERE EnabledTableColumnEO.TABLE_NAME = DataInspectorColumnsEO.TABLE_NAME
215: AND EnabledTableColumnEO.COLUMN_NAME = DataInspectorColumnsEO.COLUMN_NAME

Line 631: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

627: EnabledTableColumnEO.FEM_DATA_TYPE_CODE,
628: EnabledTableColumnEO.DIMENSION_ID,
629: DataInspectorColumnsEO.SORT_SEQUENCE,
630: DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
631: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
632: member_name_col,
633: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
634: member_code_col,
635: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

Line 633: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

629: DataInspectorColumnsEO.SORT_SEQUENCE,
630: DataInspectorColumnsEO.SORT_DIRECTION_FLAG,
631: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
632: member_name_col,
633: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
634: member_code_col,
635: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
636: member_table_name,
637: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

Line 635: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS

631: (select member_name_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
632: member_name_col,
633: (select member_display_code_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
634: member_code_col,
635: (select member_vl_object_name from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
636: member_table_name,
637: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
638: dimension_varchar_label,
639: (select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,

Line 640: (select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col

636: member_table_name,
637: (select dimension_varchar_label from fem_dimensions_b where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS
638: dimension_varchar_label,
639: (select dimension_name from fem_dimensions_vl where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS dimension_name,
640: (select member_col from fem_xdim_dimensions where dimension_id = EnabledTableColumnEO.DIMENSION_ID) AS member_col
641: FROM FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,
642: FEM_TAB_COLUMNS_V EnabledTableColumnEO
643: WHERE EnabledTableColumnEO.TABLE_NAME = DataInspectorColumnsEO.TABLE_NAME
644: AND EnabledTableColumnEO.COLUMN_NAME = DataInspectorColumnsEO.COLUMN_NAME