DBA Data[Home] [Help]

APPS.FEM_TABLE_PUBLISH_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 232: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL

228: CURSOR get_table_name_csr IS
229: SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;
230:
231: CURSOR get_condition_Obj_id_cursor IS
232: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
233: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
234: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;
235:
236: CURSOR get_table_display_name_cursor IS

Line 234: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;

230:
231: CURSOR get_condition_Obj_id_cursor IS
232: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
233: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
234: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;
235:
236: CURSOR get_table_display_name_cursor IS
237: SELECT DISPLAY_NAME FROM FEM_TABLES_VL WHERE TABLE_NAME = l_tablename;
238:

Line 652: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL

648: CURSOR get_table_name_csr IS
649: SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;
650:
651: CURSOR get_condition_Obj_id_cursor IS
652: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
653: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
654: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;
655:
656:

Line 654: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;

650:
651: CURSOR get_condition_Obj_id_cursor IS
652: SELECT FEM_DATA_INSPECTORS.CONDITION_OBJ_ID, FEM_OBJECT_CATALOG_VL.OBJECT_NAME FROM FEM_DATA_INSPECTORS, FEM_OBJECT_CATALOG_VL
653: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND
654: FEM_OBJECT_CATALOG_VL.OBJECT_ID = FEM_DATA_INSPECTORS.CONDITION_OBJ_ID;
655:
656:
657: CURSOR column_order_csr IS
658: SELECT COLUMN_NAME,