[Home] [Help] [Dependency Information]
Object Name: | AMS_LT_ORG_CONTACT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LT_ORG_CONTACT_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTACT_ID | NUMBER | (15) | Yes | |
CONTACT_NUMBER | VARCHAR2 | (30) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
DECISION_MAKER_FLAG | VARCHAR2 | (1) | ||
REFERENCE_USE_FLAG | VARCHAR2 | (1) | ||
RANK | VARCHAR2 | (30) | ||
TITLE | VARCHAR2 | (30) | ||
JOB_TITLE | VARCHAR2 | (100) | ||
JOB_TITLE_CODE | VARCHAR2 | (30) | ||
DEPARTMENT | VARCHAR2 | (60) | ||
DEPARTMENT_CODE | VARCHAR2 | (30) | ||
MANAGED_BY | NUMBER | (15) | ||
MAILING_ADDRESS_ID | NUMBER | (15) | ||
MAIL_STOP | VARCHAR2 | (60) | ||
NATIVE_LANGUAGE | VARCHAR2 | (30) | ||
OTHER_LANGUAGE_1 | VARCHAR2 | (30) | ||
OTHER_LANGUAGE_2 | VARCHAR2 | (30) | ||
PARTY_RELATIONSHIP_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_ID
, CONTACT_NUMBER
, PARTY_SITE_ID
, DECISION_MAKER_FLAG
, REFERENCE_USE_FLAG
, RANK
, TITLE
, JOB_TITLE
, JOB_TITLE_CODE
, DEPARTMENT
, DEPARTMENT_CODE
, MANAGED_BY
, MAILING_ADDRESS_ID
, MAIL_STOP
, NATIVE_LANGUAGE
, OTHER_LANGUAGE_1
, OTHER_LANGUAGE_2
, PARTY_RELATIONSHIP_ID
FROM APPS.AMS_LT_ORG_CONTACT_V;
APPS.AMS_LT_ORG_CONTACT_V is not referenced by any database object
|
|
|