eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_TABLE_PUBLISH_PKG dependencies on FEM_DATA_INSPECTORS

Line 229: SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;

225: AND SORT_SEQUENCE IS NOT NULL
226: ORDER BY SORT_SEQUENCE ASC;
227:
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

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 233: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND

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
237: SELECT DISPLAY_NAME FROM FEM_TABLES_VL WHERE TABLE_NAME = l_tablename;

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 649: SELECT TABLE_NAME FROM FEM_DATA_INSPECTORS WHERE DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId;

645: AND DataInspectorColumnsEO.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId
646: ORDER BY DataInspectorColumnsEO.DISPLAY_SEQUENCE ASC;
647:
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

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 653: WHERE FEM_DATA_INSPECTORS.DATA_INSPECTOR_OBJ_DEF_ID = p_diObjDefId AND

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:
657: CURSOR column_order_csr IS

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,