[Home] [Help] [Dependency Information]
Object Name: | AMS_IBA_PL_SITES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_IBA_PL_SITES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view lists all sites
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique Identifier | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
SECURITY_GROUP_ID | NUMBER | (15) | Security Group Id | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
SITE_ID | NUMBER | Yes | Site Unique Identifier | |
SITE_REF_CODE | VARCHAR2 | (30) | Yes | Site Programmatic Access Code |
SITE_CATEGORY_TYPE | VARCHAR2 | (30) | Yes | Category of Site |
SITE_CATEGORY_OBJECT_ID | NUMBER | Id of an instance of the Site Category | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | Status Code |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
NAME | VARCHAR2 | (240) | Yes | Site Name |
DESCRIPTION | VARCHAR2 | (4000) | Site Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, SITE_ID
, SITE_REF_CODE
, SITE_CATEGORY_TYPE
, SITE_CATEGORY_OBJECT_ID
, STATUS_CODE
, CREATED_BY
, NAME
, DESCRIPTION
FROM APPS.AMS_IBA_PL_SITES_VL;
|
|
|