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

VIEW: POS.POS_CONTACT_REQUESTS#

Object Details
Object Name: POS_CONTACT_REQUESTS#
Object Type: VIEW
Owner: POS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTACT_REQUEST_ID NUMBER
Yes
MAPPING_ID NUMBER
Yes
CONTACT_PARTY_ID NUMBER

REQUEST_STATUS VARCHAR2 (30) Yes
REQUEST_TYPE VARCHAR2 (30) Yes
HAS_BACKING_DOC VARCHAR2 (1)
CONTACT_TITLE VARCHAR2 (30)
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Yes
MIDDLE_NAME VARCHAR2 (60)
JOB_TITLE VARCHAR2 (60)
EMAIL_ADDRESS VARCHAR2 (2000)
PHONE_AREA_CODE VARCHAR2 (10)
PHONE_NUMBER VARCHAR2 (40)
PHONE_EXTENSION VARCHAR2 (20)
FAX_AREA_CODE VARCHAR2 (10)
FAX_NUMBER VARCHAR2 (40)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CREATE_USER_ACCOUNT VARCHAR2 (1)
DO_NOT_DELETE VARCHAR2 (1)
DEPARTMENT VARCHAR2 (60)
ALT_CONTACT_NAME VARCHAR2 (240)
ALT_AREA_CODE VARCHAR2 (10)
ALT_PHONE_NUMBER VARCHAR2 (40)
URL VARCHAR2 (2000)
Query Text

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


SELECT CONTACT_REQUEST_ID
,      MAPPING_ID
,      CONTACT_PARTY_ID
,      REQUEST_STATUS
,      REQUEST_TYPE
,      HAS_BACKING_DOC
,      CONTACT_TITLE
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      JOB_TITLE
,      EMAIL_ADDRESS
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      FAX_AREA_CODE
,      FAX_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATE_USER_ACCOUNT
,      DO_NOT_DELETE
,      DEPARTMENT
,      ALT_CONTACT_NAME
,      ALT_AREA_CODE
,      ALT_PHONE_NUMBER
,      URL
FROM POS.POS_CONTACT_REQUESTS#;

Dependencies

[top of page]

POS.POS_CONTACT_REQUESTS# references the following:

SchemaPOS
TablePOS_CONTACT_REQUESTS
POS.POS_CONTACT_REQUESTS# is referenced by following:

SchemaAPPS
SynonymPOS_CONTACT_REQUESTS