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

VIEW: APPS.JTF_SOURCES

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

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_SOURCES_ALL table


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
LOOKUP_CODE VARCHAR2 (30) Yes
LOOKUP_TYPE VARCHAR2 (30) Yes
MEANING VARCHAR2 (80) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
DESCRIPTION VARCHAR2 (240)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

RELATED_ID1 NUMBER

RELATED_ID2 NUMBER

RELATED_ID3 NUMBER

RELATED_ID4 NUMBER

RELATED_ID5 NUMBER

ORG_ID NUMBER

Query Text

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


SELECT SOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOOKUP_CODE
,      LOOKUP_TYPE
,      MEANING
,      ENABLED_FLAG
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      RELATED_ID1
,      RELATED_ID2
,      RELATED_ID3
,      RELATED_ID4
,      RELATED_ID5
,      ORG_ID
FROM APPS.JTF_SOURCES;

Dependencies

[top of page]

APPS.JTF_SOURCES references the following:

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

SchemaAPPS
ViewJTF_TERRITORIES_NAV
Package BodyJTF_TERRITORY_GET_PUB - show dependent code
ViewJTF_TERR_ESCALATIONS_NAV
Package BodyJTF_TERR_JSP_LOV_RECS_PUB - show dependent code
ViewJTF_TERR_SRCH_ADV_TYPE_V
ViewJTF_TERR_SRCH_TYPE_V
ViewJTF_TERR_TEMPLATES_NAV
ViewJTF_TERR_TYPES_NAV