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

TABLE: AHL.AHL_STATUS_ORDER_RULES

Object Details
Object Name: AHL_STATUS_ORDER_RULES
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_STATUS_ORDER_RULES
Subobject Name:
Status: VALID


This table stores status order rules for any aso object


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
STATUS_ORDER_RULE_ID NUMBER
Yes Primary Key, Unique identifier for status order rule ID
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
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
SYSTEM_STATUS_TYPE VARCHAR2 (30) Yes Identifies system status type, Unique identifier for lookup type. Foreign key to FND_LOOKUPS
CURRENT_STATUS_CODE VARCHAR2 (30) Yes Identifies current status code, defined in FND_LOOKUP_VALUES table
NEXT_STATUS_CODE VARCHAR2 (30) Yes Identifies next allowed status value, defined in FND_LOOKUP_VALUES table
SECURITY_GROUP_ID NUMBER

Used in application hosting
Query Text

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


SELECT STATUS_ORDER_RULE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SYSTEM_STATUS_TYPE
,      CURRENT_STATUS_CODE
,      NEXT_STATUS_CODE
,      SECURITY_GROUP_ID
FROM AHL.AHL_STATUS_ORDER_RULES;

Dependencies

[top of page]

AHL.AHL_STATUS_ORDER_RULES does not reference any database object

AHL.AHL_STATUS_ORDER_RULES is referenced by following:

SchemaAPPS
SynonymAHL_STATUS_ORDER_RULES