Product: | FND - Application Object Library |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FND_IREP_ALL_INTERFACES |
SELECT CLASS_ID
,
CLASS_NAME
,
IREP_NAME
,
CLASS_TYPE
,
PRODUCT_CODE
,
IMPLEMENTATION_NAME
,
DEPLOYED_FLAG
,
GENERATED_FLAG
,
COMPATIBILITY_FLAG
,
ASSOC_CLASS_ID
,
SCOPE_TYPE
,
LIFECYCLE_MODE
,
SOURCE_FILE_PRODUCT
,
SOURCE_FILE_PATH
,
SOURCE_FILE_NAME
,
SOURCE_FILE_VERSION
,
STANDARD_TYPE
,
STANDARD_VERSION
,
STANDARD_SPEC
,
DISPLAY_NAME
,
SHORT_DESCRIPTION
,
OPEN_INTERFACE_FLAG
,
LOAD_ERR
,
LOAD_ERR_MSGS
,
'FND_IREP_CLASSES' AS SRC_TABLE
,
CREATED_BY
FROM FND_IREP_CLASSES_VL
UNION ALL
(SELECT OBJECT_ID
,
OBJ_NAME
,
IREP_NAME
,
IREP_OBJECT_TYPE
,
IREP_PRODUCT
,
NULL
,
NULL
,
NULL
,
IREP_COMPATIBILITY
,
NULL
,
IREP_SCOPE
,
IREP_LIFECYCLE
,
IREP_SOURCE_FILE_PRODUCT
,
IREP_SOURCE_FILE_PATH
,
IREP_SOURCE_FILE_NAME
,
IREP_SOURCE_FILE_VERSION
,
IREP_STANDARD
,
IREP_STANDARD_VERSION
,
IREP_STANDARD_SPEC
,
DISPLAY_NAME
,
DESCRIPTION
,
NULL
,
LOAD_ERR
,
LOAD_ERR_MSGS
,
'FND_OBJECTS' AS SRC_TABLE
,
CREATED_BY
FROM FND_OBJECTS_VL
WHERE IREP_NAME IS NOT NULL)