DBA Data[Home] [Help]

APPS.FEM_TABLE_PUBLISH_PKG dependencies on FEM_DATA_INSPECTOR_COLS

Line 212: FROM FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,

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
216: AND DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId

Line 223: FROM FEM_DATA_INSPECTOR_COLS

219: CURSOR column_order_csr IS
220: SELECT COLUMN_NAME,
221: SORT_SEQUENCE,
222: SORT_DIRECTION_FLAG
223: FROM FEM_DATA_INSPECTOR_COLS
224: WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
225: AND SORT_SEQUENCE IS NOT NULL
226: ORDER BY SORT_SEQUENCE ASC;
227:

Line 641: FROM FEM_DATA_INSPECTOR_COLS DataInspectorColumnsEO,

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
645: AND DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId

Line 661: FROM FEM_DATA_INSPECTOR_COLS

657: CURSOR column_order_csr IS
658: SELECT COLUMN_NAME,
659: SORT_SEQUENCE,
660: SORT_DIRECTION_FLAG
661: FROM FEM_DATA_INSPECTOR_COLS
662: WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
663: AND SORT_SEQUENCE IS NOT NULL
664: ORDER BY SORT_SEQUENCE ASC;
665: