[Home] [Help] [Dependency Information]
Object Name: | ASO_I_ORG_CONTACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_ORG_CONTACTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_CONTACT_ID | NUMBER | (15) | Yes | Identifier of the organization contact |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | name of the customer |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | Party number |
CUSTOMER_TYPE | VARCHAR2 | (30) | Yes | Type of party. This is limited to person, organization, group or relationship. |
FIRST_NAME | VARCHAR2 | (150) | First name of the person | |
MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
LAST_NAME | VARCHAR2 | (150) | Last name of the person | |
TITLE | VARCHAR2 | (80) | Title | |
JOB_TITLE | VARCHAR2 | (100) | Job Title | |
STATUS | VARCHAR2 | (1) | Organization contact status flag | |
ORG_PARTY_ID | NUMBER | (15) | Yes | ID of the object in the relationship |
CONTACT_NUMBER | VARCHAR2 | (30) | Contact number | |
CONTACT_PARTY_ID | NUMBER | (15) | Yes | ID of the subject in the relationship |
CONTACT_ROLE_TYPE | VARCHAR2 | (30) | This is the Role of the contact , for eg. BILL_TO,SHIP_TO etc. | |
RELATIONSHIP_PARTY_ID | NUMBER | (15) | RELATIONSHIP PARTY ID |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_CONTACT_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_TYPE
, FIRST_NAME
, MIDDLE_NAME
, LAST_NAME
, TITLE
, JOB_TITLE
, STATUS
, ORG_PARTY_ID
, CONTACT_NUMBER
, CONTACT_PARTY_ID
, CONTACT_ROLE_TYPE
, RELATIONSHIP_PARTY_ID
FROM APPS.ASO_I_ORG_CONTACTS_V;
APPS.ASO_I_ORG_CONTACTS_V is not referenced by any database object
|
|
|