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


TABLE: HXC.HXC_RETRIEVAL_RULE_COMPS

Object Details
Object Name: HXC_RETRIEVAL_RULE_COMPS
Object Type: TABLE
Owner: HXC
FND Design Data: TableHXC.HXC_RETRIEVAL_RULE_COMPS
Subobject Name:
Status: VALID


HXC_RETRIEVAL_RULE_COMPS holds the individual Rule Components which make up a defined set of Rules. Each Rule Component describes the status that is required of Recipient Application data in order for it to be retrieved via the associated Retrieval Process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXC_RETRIEVAL_RULE_COMPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRETRIEVAL_RULE_COMP_ID
HXC_RETRIEVAL_RULE_COMPS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRETRIEVAL_RULE_ID
HXC_RETRIEVAL_RULE_COMPS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_RULE_COMP_ID NUMBER (15) Yes Primary Key from sequence
RETRIEVAL_RULE_ID NUMBER (15) Yes Foreign Key to HXC_RETRIEVAL_RULES.
STATUS VARCHAR2 (30) Yes Status of Time Information to which Rule Component applies.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TIME_RECIPIENT_ID NUMBER (15) Yes Foreign Key to HXC_TIME_RECIPIENTS.
Query Text

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


SELECT RETRIEVAL_RULE_COMP_ID
,      RETRIEVAL_RULE_ID
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TIME_RECIPIENT_ID
FROM HXC.HXC_RETRIEVAL_RULE_COMPS;

Dependencies

[top of page]

HXC.HXC_RETRIEVAL_RULE_COMPS does not reference any database object

HXC.HXC_RETRIEVAL_RULE_COMPS is referenced by following:

SchemaAPPS
SynonymHXC_RETRIEVAL_RULE_COMPS
TriggerHXC_RETRIEVAL_RULE_COMPS_WHO