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

TABLE: QA.QA_SKIPLOT_PROCESS_PLAN_RULES

Object Details
Object Name: QA_SKIPLOT_PROCESS_PLAN_RULES
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_SKIPLOT_PROCESS_PLAN_RULES
Subobject Name:
Status: VALID


Unique index on process plan ID


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_SKIPLOT_PROCESS_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_PLAN_RULE_ID
QA_SKIPLOT_PROCESS_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_PLAN_RULE_ID NUMBER
Yes primary key
PROCESS_PLAN_ID NUMBER
Yes foreign key to Skip Lot Process Plan
RULE_SEQ NUMBER
Yes Rule sequence
FREQUENCY_NUM NUMBER
Yes Skipping Frequency (Numerator)
FREQUENCY_DENOM NUMBER
Yes Skipping frequency (denominator)
ROUNDS NUMBER

No. of rounds before reducing frequency
DAYS_SPAN NUMBER

No. of days spanned before aborting
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
Query Text

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


SELECT PROCESS_PLAN_RULE_ID
,      PROCESS_PLAN_ID
,      RULE_SEQ
,      FREQUENCY_NUM
,      FREQUENCY_DENOM
,      ROUNDS
,      DAYS_SPAN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_SKIPLOT_PROCESS_PLAN_RULES;

Dependencies

[top of page]

QA.QA_SKIPLOT_PROCESS_PLAN_RULES does not reference any database object

QA.QA_SKIPLOT_PROCESS_PLAN_RULES is referenced by following:

SchemaAPPS
SynonymQA_SKIPLOT_PROCESS_PLAN_RULES