[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

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_B

AMS_USER_STATUSES_TL

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

BIM_EDW_CMPSTATS_M_SIZE - show dependent code

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