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

VIEW: JTF.JTF_CAL_ADDRESSES#

Object Details
Object Name: JTF_CAL_ADDRESSES#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ADDRESS_ID NUMBER
Yes
RESOURCE_ID NUMBER
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LAST_NAME VARCHAR2 (2000)
FIRST_NAME VARCHAR2 (2000)
JOB_TITLE VARCHAR2 (2000)
COMPANY VARCHAR2 (2000)
PRIMARY_CONTACT NUMBER

CONTACT1_TYPE VARCHAR2 (2000)
CONTACT1 VARCHAR2 (2000)
CONTACT2_TYPE VARCHAR2 (2000)
CONTACT2 VARCHAR2 (2000)
CONTACT3_TYPE VARCHAR2 (2000)
CONTACT3 VARCHAR2 (2000)
CONTACT4_TYPE VARCHAR2 (2000)
CONTACT4 VARCHAR2 (2000)
CONTACT5_TYPE VARCHAR2 (2000)
CONTACT5 VARCHAR2 (2000)
WWW_ADDRESS VARCHAR2 (2000)
ASSISTANT_NAME VARCHAR2 (2000)
ASSISTANT_PHONE VARCHAR2 (2000)
CATEGORY NUMBER

ADDRESS1 VARCHAR2 (2000)
ADDRESS2 VARCHAR2 (2000)
ADDRESS3 VARCHAR2 (2000)
ADDRESS4 VARCHAR2 (2000)
CITY VARCHAR2 (2000)
COUNTY VARCHAR2 (2000)
STATE VARCHAR2 (2000)
ZIP VARCHAR2 (2000)
COUNTRY VARCHAR2 (2000)
NOTE VARCHAR2 (4000)
PRIVATE_FLAG VARCHAR2 (1)
DELETED_AS_OF DATE

APPLICATION_ID NUMBER

SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT ADDRESS_ID
,      RESOURCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_NAME
,      FIRST_NAME
,      JOB_TITLE
,      COMPANY
,      PRIMARY_CONTACT
,      CONTACT1_TYPE
,      CONTACT1
,      CONTACT2_TYPE
,      CONTACT2
,      CONTACT3_TYPE
,      CONTACT3
,      CONTACT4_TYPE
,      CONTACT4
,      CONTACT5_TYPE
,      CONTACT5
,      WWW_ADDRESS
,      ASSISTANT_NAME
,      ASSISTANT_PHONE
,      CATEGORY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTY
,      STATE
,      ZIP
,      COUNTRY
,      NOTE
,      PRIVATE_FLAG
,      DELETED_AS_OF
,      APPLICATION_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_CAL_ADDRESSES#;

Dependencies

[top of page]

JTF.JTF_CAL_ADDRESSES# references the following:

SchemaJTF
TableJTF_CAL_ADDRESSES
JTF.JTF_CAL_ADDRESSES# is referenced by following:

SchemaAPPS
SynonymJTF_CAL_ADDRESSES