[Home] [Help] [Dependency Information]
Object Name: | AMS_CONTACT_RESTRICTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_CONTACT_RESTRICTIONS_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 |
---|---|---|---|---|
CONTACT_PREFERENCE_ID | NUMBER | (15) | Yes | |
CONTACT_LEVEL_TABLE | VARCHAR2 | (30) | Yes | |
CONTACT_LEVEL_TABLE_ID | NUMBER | (15) | Yes | |
CONTACT_TYPE | VARCHAR2 | (30) | Yes | |
PREFERENCE_CODE | VARCHAR2 | (30) | Yes | |
PREFERENCE_TOPIC_TYPE | VARCHAR2 | (30) | ||
PREFERENCE_TOPIC_TYPE_ID | NUMBER | (15) | ||
PREFERENCE_TOPIC_TYPE_CODE | VARCHAR2 | (30) | ||
PREFERENCE_START_DATE | DATE | Yes | ||
PREFERENCE_END_DATE | DATE | |||
PREFERENCE_START_TIME_HR | NUMBER | |||
PREFERENCE_END_TIME_HR | NUMBER | |||
PREFERENCE_START_TIME_MI | NUMBER | |||
PREFERENCE_END_TIME_MI | NUMBER | |||
MAX_NO_OF_INTERACTIONS | NUMBER | |||
MAX_NO_OF_INTERACT_UOM_CODE | VARCHAR2 | (30) | ||
REQUESTED_BY | VARCHAR2 | (30) | Yes | |
REASON_CODE | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (15) | ||
STATUS | VARCHAR2 | (1) | Yes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | ||
APPLICATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_PREFERENCE_ID
, CONTACT_LEVEL_TABLE
, CONTACT_LEVEL_TABLE_ID
, CONTACT_TYPE
, PREFERENCE_CODE
, PREFERENCE_TOPIC_TYPE
, PREFERENCE_TOPIC_TYPE_ID
, PREFERENCE_TOPIC_TYPE_CODE
, PREFERENCE_START_DATE
, PREFERENCE_END_DATE
, PREFERENCE_START_TIME_HR
, PREFERENCE_END_TIME_HR
, PREFERENCE_START_TIME_MI
, PREFERENCE_END_TIME_MI
, MAX_NO_OF_INTERACTIONS
, MAX_NO_OF_INTERACT_UOM_CODE
, REQUESTED_BY
, REASON_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, STATUS
, CREATED_BY_MODULE
, APPLICATION_ID
FROM APPS.AMS_CONTACT_RESTRICTIONS_V;
APPS.AMS_CONTACT_RESTRICTIONS_V is not referenced by any database object
|
|
|