DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTY_ALL_ENABLED_ATTRIBUTES_V

Object Details
Object Name: JTY_ALL_ENABLED_ATTRIBUTES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTY_ALL_ENABLED_ATTRIBUTES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


All Enabled Attributes View


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUAL_USG_ID NUMBER
Yes Jqu Qual Usg Id
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Jqu Application Short Name
SEEDED_QUAL_ID NUMBER
Yes Jqu Seeded Qual Id
QUAL_TYPE_USG_ID NUMBER
Yes Jqu Qual Type Usg Id
SEEDED_FLAG VARCHAR2 (1)
Seeded Flag
DISPLAY_TYPE VARCHAR2 (40)
Display Type
CONVERT_TO_ID_FLAG VARCHAR2 (1)
Convert To Id Flag
SEEDED_QUAL_NAME VARCHAR2 (60) Yes Seeded Qual Name
DESCRIPTION VARCHAR2 (240)
Description
QUAL_TYPE_ID NUMBER
Yes Qual Type Id
QUALIFIER_TYPE_NAME VARCHAR2 (40) Yes Qualifier Type Name
QUALIFIER_TYPE_DESCRIPTION VARCHAR2 (240)
Qualifier Type Description
SOURCE_ID NUMBER
Yes Source Id
LOOKUP_CODE VARCHAR2 (30) Yes Lookup Code
USAGE VARCHAR2 (240) Yes Usage
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUAL_USG_ID
,      APPLICATION_SHORT_NAME
,      SEEDED_QUAL_ID
,      QUAL_TYPE_USG_ID
,      SEEDED_FLAG
,      DISPLAY_TYPE
,      CONVERT_TO_ID_FLAG
,      SEEDED_QUAL_NAME
,      DESCRIPTION
,      QUAL_TYPE_ID
,      QUALIFIER_TYPE_NAME
,      QUALIFIER_TYPE_DESCRIPTION
,      SOURCE_ID
,      LOOKUP_CODE
,      USAGE
FROM APPS.JTY_ALL_ENABLED_ATTRIBUTES_V;

Dependencies

[top of page]

APPS.JTY_ALL_ENABLED_ATTRIBUTES_V references the following:

SchemaAPPS
SynonymJTF_QUAL_TYPES_ALL
SynonymJTF_QUAL_TYPE_USGS_ALL
SynonymJTF_QUAL_USGS_ALL
SynonymJTF_SEEDED_QUAL_ALL
SynonymJTF_SOURCES_ALL
APPS.JTY_ALL_ENABLED_ATTRIBUTES_V is referenced by following:

SchemaAPPS
Package BodyCSF_RESOURCE_PUB - show dependent code