[Home] [Help] [Dependency Information]
Object Name: | AMS_P_OSO_SOURCE_CODES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_OSO_SOURCE_CODES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows the information related to a source code. This view is created for sales to use for different reasons like creating leads, registrations. The source type in this view tells what object this source code is attached to. The source type can be Campaign ,campaign Schedule, Offers, event schedules and one off events.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_CODE_ID | NUMBER | Identifier of source code. | ||
SOURCE_CODE | VARCHAR2 | (30) | Source code. | |
SOURCE_TYPE | VARCHAR2 | (30) | Type of activity. | |
OBJECT_ID | NUMBER | Identifier of object. | ||
NAME | VARCHAR2 | (2000) | Name of activity. | |
STATUS | VARCHAR2 | (30) | Status code of activity. | |
START_DATE | DATE | Start date of an activity. | ||
END_DATE | DATE | End date of an activity. | ||
INBOUND_URL | VARCHAR2 | (4000) | Inbound URL. | |
INBOUND_EMAIL_ID | VARCHAR2 | (120) | Inbound Email address. | |
INBOUND_PHONE_NO | VARCHAR2 | (25) | Inbound phone number. | |
RELATED_SOURCE_CODE | VARCHAR2 | (30) | Source code for the related object. | |
RELATED_SOURCE_OBJECT | VARCHAR2 | (30) | Code for the related object. | |
RELATED_SOURCE_ID | NUMBER | Identifier of the related object. | ||
OBJECT_NAME | VARCHAR2 | (80) | Name of the source type. |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_CODE_ID
, SOURCE_CODE
, SOURCE_TYPE
, OBJECT_ID
, NAME
, STATUS
, START_DATE
, END_DATE
, INBOUND_URL
, INBOUND_EMAIL_ID
, INBOUND_PHONE_NO
, RELATED_SOURCE_CODE
, RELATED_SOURCE_OBJECT
, RELATED_SOURCE_ID
, OBJECT_NAME
FROM APPS.AMS_P_OSO_SOURCE_CODES_V;
APPS.AMS_P_OSO_SOURCE_CODES_V is not referenced by any database object
|
|
|