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

VIEW: APPS.JTF_QUAL_TYPES

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Same as JTF_QUAL_TYPES_ALL table


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUAL_TYPE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NAME VARCHAR2 (40) Yes
DESCRIPTION VARCHAR2 (80) Yes
SELECT_CLAUSE VARCHAR2 (1000)
WHERE_CLAUSE VARCHAR2 (1000)
VIEW_NAME VARCHAR2 (30)
VIEW_DDL_FILENAME VARCHAR2 (60)
RELATED_ID1 NUMBER

RELATED_ID2 NUMBER

RELATED_ID3 NUMBER

RELATED_ID4 NUMBER

RELATED_ID5 NUMBER

ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT QUAL_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      SELECT_CLAUSE
,      WHERE_CLAUSE
,      VIEW_NAME
,      VIEW_DDL_FILENAME
,      RELATED_ID1
,      RELATED_ID2
,      RELATED_ID3
,      RELATED_ID4
,      RELATED_ID5
,      ORG_ID
FROM APPS.JTF_QUAL_TYPES;

Dependencies

[top of page]

APPS.JTF_QUAL_TYPES references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymJTF_QUAL_TYPES_ALL
APPS.JTF_QUAL_TYPES is referenced by following:

SchemaAPPS
ViewAS_TERRITORIES_V
ViewJTF_SEEDED_QUAL_USGS_V
Package BodyJTF_TERRITORY_RESOURCE_PVT - show dependent code
Package BodyJTF_TERR_DIAGNOSTIC_TEST - show dependent code
Package BodyJTF_TERR_ENGINE_GEN2_PVT - show dependent code
Package BodyJTF_TERR_ENGINE_GEN_PVT - show dependent code
Package BodyJTF_TERR_JSP_REPORTS - show dependent code
ViewJTF_TERR_QUALIFIERS_V
ViewJTF_TERR_RSC_ACCESS_V
ViewJTF_TERR_TRANSACTIONS_V
ViewJTF_TERR_TYPE_QUALIFIERS_V
ViewJTF_TYPE_QTYPE_USGS_V
ViewJTF_TYPE_TRANSACTIONS_V