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

TABLE: APPLSYS.AD_PA_CRITERIA_PROD_FAMS

Object Details
Object Name: AD_PA_CRITERIA_PROD_FAMS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_PA_CRITERIA_PROD_FAMS
Subobject Name:
Status: VALID


Stores criteria for Patch Advisor used when determining what types of patches should be applied for given products


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_PA_CRITERIA_PROD_FAMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADVISOR_CRITERIA_ID
ColumnPRODUCT_FAMILY_ABBREVIATION
Columns
Name Datatype Length Mandatory Comments
ADVISOR_CRITERIA_ID VARCHAR2 (80) Yes User defined Patch filter name
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (30) Yes Product family abbreviation
RECOMMENDED_PATCH_FLAG VARCHAR2 (4) Yes Flag to mark selection of Recommend Patches for a particular Product family
NEW_CODE_LEVEL_FLAG VARCHAR2 (4) Yes Flag to mark selection of New Code level for a particular Product family
LICENSED_FLAG VARCHAR2 (4) Yes Flag to mark the Licensed Products
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
Query Text

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


SELECT ADVISOR_CRITERIA_ID
,      PRODUCT_FAMILY_ABBREVIATION
,      RECOMMENDED_PATCH_FLAG
,      NEW_CODE_LEVEL_FLAG
,      LICENSED_FLAG
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
FROM APPLSYS.AD_PA_CRITERIA_PROD_FAMS;

Dependencies

[top of page]

APPLSYS.AD_PA_CRITERIA_PROD_FAMS does not reference any database object

APPLSYS.AD_PA_CRITERIA_PROD_FAMS is referenced by following:

SchemaAPPLSYS
ViewAD_PA_CRITERIA_PROD_FAMS#