[Home] [Help]
[Dependency Information]
VIEW: APPS.AMS_USER_STATUSES_VL
Object Details
Object Name: | AMS_USER_STATUSES_VL |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_USER_STATUSES_VL
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
This view is used to retrieve information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..)
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
Unique identifier generated by the database |
DEFAULT_FLAG |
VARCHAR2 |
(1) |
Yes |
Indicates default status |
SEEDED_FLAG |
VARCHAR2 |
(1) |
|
Flag to show if this status is seeded. |
USER_STATUS_ID |
NUMBER |
|
Yes |
Unique identifer |
LAST_UPDATE_DATE |
DATE |
|
Yes |
Standard WHO Column |
LAST_UPDATED_BY |
NUMBER |
(15) |
Yes |
Standard WHO Column |
CREATION_DATE |
DATE |
|
Yes |
Standard WHO Column |
CREATED_BY |
NUMBER |
(15) |
Yes |
Standard WHO Column |
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
Standard WHO Column |
OBJECT_VERSION_NUMBER |
NUMBER |
(9) |
|
This column is used for locking purposes |
SYSTEM_STATUS_TYPE |
VARCHAR2 |
(30) |
Yes |
Status type of the user statuses |
SYSTEM_STATUS_CODE |
VARCHAR2 |
(30) |
Yes |
Status code of the user statuses |
ENABLED_FLAG |
VARCHAR2 |
(1) |
Yes |
Flag to indicate if this user status is enabled or disabled |
START_DATE_ACTIVE |
DATE |
|
|
Date to show when the current status started |
END_DATE_ACTIVE |
DATE |
|
|
Date to show when the current status ends |
NAME |
VARCHAR2 |
(120) |
|
Name of the user status |
DESCRIPTION |
VARCHAR2 |
(4000) |
|
Description of the user statuses |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DEFAULT_FLAG
, SEEDED_FLAG
, USER_STATUS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SYSTEM_STATUS_TYPE
, SYSTEM_STATUS_CODE
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, NAME
, DESCRIPTION
FROM APPS.AMS_USER_STATUSES_VL;
Dependencies
[top of page]
APPS.AMS_USER_STATUSES_VL references the following:
-
APPS
-
AMS_USER_STATUSES_B
-
AMS_USER_STATUSES_TL
APPS.AMS_USER_STATUSES_VL is referenced by following:
-
APPS
-
AMS_ACT_LIST_PVT
- show dependent code
-
AMS_ADI_CAMP_SCHED_PVT
- show dependent code
-
AMS_APPROVAL_PVT
- show dependent code
-
AMS_CAMPAIGNS_V
-
AMS_CELL_PVT
- show dependent code
-
AMS_DELIVERABLES_INFO_V
-
AMS_DELIVERABLE_PVT
- show dependent code
-
AMS_DMMODEL_PUB
- show dependent code
-
AMS_DM_MODEL_PVT
- show dependent code
-
AMS_DM_SCORE_PVT
- show dependent code
-
AMS_DM_TARGET_PVT
- show dependent code
-
AMS_EVENT_HEADERS_AGENDA_V
-
AMS_EVENT_HEADERS_V
-
AMS_EVENT_OFFERS_AGENDA_V
-
AMS_EVENT_OFFERS_ONLY_V
-
AMS_EVENT_OFFERS_OV_V
-
AMS_EVENT_OFFERS_REG_V
-
AMS_EVENT_OFFERS_V
-
AMS_EVENT_REGISTRATIONS_V
-
AMS_EVHRULES_PVT
- show dependent code
-
AMS_EVTREGS_PVT
- show dependent code
-
AMS_IMPORTCLIENT_PVT
- show dependent code
-
AMS_IMPORT_LIST_PVT
- show dependent code
-
AMS_IMPORT_XML_PVT
- show dependent code
-
AMS_LISTGENERATION_PKG
- show dependent code
-
AMS_LISTGENERATION_UTIL_PKG
- show dependent code
-
AMS_LISTHEADER_PVT
- show dependent code
-
AMS_LISTIMPORT_PVT
- show dependent code
-
AMS_LIST_IMPORT_PUB
- show dependent code
-
AMS_LIST_PURGE_PVT
- show dependent code
-
AMS_P_DELIVERABLES_V
-
AMS_P_EVENT_REG_CONTACTS_V
-
AMS_P_EVENT_REG_ROSTER_V
-
AMS_REGISTRANTS_PUB
- show dependent code
-
AMS_SCHEDULERULES_PVT
- show dependent code
-
AMS_STATUS_PVT
- show dependent code
-
AMS_USER_STATUSES_PVT
- show dependent code
-
AMS_USER_STATUSES_V
-
AMS_UTILITY_PVT
- show dependent code
-
AMS_WFCMPAPR_PVT
- show dependent code
-
AST_LM_COLLATERAL_V
-
AST_LM_EVENTS_SRC_V
-
AST_LM_EVENTS_V
-
BIM_DIMV_SOURCE_LISTS
-
BIM_DIMV_USER_STATUSES
-
OZF_ACTBUDGETS_PVT
- show dependent code
-
OZF_AR_SETTLEMENT_PVT
- show dependent code
-
OZF_BUDGETAPPROVAL_PVT
- show dependent code
-
OZF_CLAIMS_HISTORY_V
-
OZF_CLAIMS_V
-
OZF_CLAIM_PVT
- show dependent code
-
OZF_CLAIM_SETTLEMENT_PVT
- show dependent code
-
OZF_CLAIM_SUMMARY_V
-
OZF_FUNDS_PUB
- show dependent code
-
OZF_FUNDS_PVT
- show dependent code
-
OZF_FUND_ALLOCATIONS_PVT
- show dependent code
-
OZF_FUND_DETAILS_V
-
OZF_MASS_SETTLEMENT_PVT
- show dependent code
-
OZF_OFFER_PVT
- show dependent code
-
OZF_PRICELIST_PVT
- show dependent code
-
OZF_PRICE_LIST_PVT
- show dependent code
-
OZF_PROMOTIONAL_OFFERS_PVT
- show dependent code
-
OZF_QUOTA_ALLOCATIONS_PVT
- show dependent code
-
OZF_QUOTA_PUB
- show dependent code
-
OZF_REQ_CLAIMS_V
-
OZF_SD_REQUEST_PUB
- show dependent code
-
OZF_SD_UTIL_PVT
- show dependent code
-
OZF_SETTLEMENT_DOC_PVT
- show dependent code
-
OZF_UTILITY_PVT
- show dependent code
-
PV_PARTNER_PROGRAM_PVT
- show dependent code