DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_USER_STATUSES_V

Object Details
Object Name: AHL_USER_STATUSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_USER_STATUSES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_STATUS_ID NUMBER
Yes Primary Key, Unique identifier for user status
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
SYSTEM_STATUS_TYPE VARCHAR2 (30) Yes Identifier for system status type, Foreign key to FND_LOOKUPS
SYSTEM_STATUS_CODE VARCHAR2 (30)
Identifier for system status code, Foreign key to FND_LOOKUP_VALUES
ACTIVE_FLAG VARCHAR2 (1)
Identifier for active flag
DEFAULT_FLAG VARCHAR2 (1) Yes Identifier for default flag
SEEDED_FLAG VARCHAR2 (1)
Identifier for seeded flag
START_DATE_ACTIVE DATE

Identifier for active start date
END_DATE_ACTIVE DATE

Identifier for active end date
NAME VARCHAR2 (120)
User defined name for system status
DESCRIPTION VARCHAR2 (2000)
Identifier for description
MEANING VARCHAR2 (80) Yes Identifier for status type meaning, defined in FND_LOOKUPS
CODE_MEANING VARCHAR2 (80) Yes Identifier for staus code meaning, defined in FND_LOOKUP_VALUES
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_STATUS_ID
,      OBJECT_VERSION_NUMBER
,      SYSTEM_STATUS_TYPE
,      SYSTEM_STATUS_CODE
,      ACTIVE_FLAG
,      DEFAULT_FLAG
,      SEEDED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      NAME
,      DESCRIPTION
,      MEANING
,      CODE_MEANING
FROM APPS.AHL_USER_STATUSES_V;

Dependencies

[top of page]

APPS.AHL_USER_STATUSES_V references the following:

SchemaAPPS
ViewAHL_USER_STATUSES_VL
ViewFND_LOOKUP_TYPES_VL
ViewFND_LOOKUP_VALUES_VL

APPS.AHL_USER_STATUSES_V is not referenced by any database object