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)
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)
|
|
|