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

TABLE: PON.PON_AUC_DOCTYPE_RULES

Object Details
Object Name: PON_AUC_DOCTYPE_RULES
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_AUC_DOCTYPE_RULES
Subobject Name:
Status: VALID


PON_AUC_DOCTYPE_RULES is used by the Negotiations Builder to store information about the applicability of each business rule for each document type.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUC_DOCTYPES_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDOCTYPE_ID
ColumnBIZRULE_ID
Columns
Name Datatype Length Mandatory Comments
BIZRULE_ID NUMBER
Yes Identifier for business rule
DOCTYPE_ID NUMBER
Yes Identifier for document type
DISPLAY_FLAG VARCHAR2 (1)
Y or N flag to indicate if this auction document type business rule is to be displayed
REQUIRED_FLAG VARCHAR2 (1)
Y or N flag to indicate if required
FIXED_VALUE VARCHAR2 (100)
Fixed value
DEFAULT_VALUE VARCHAR2 (100)
Default value
RESTRICTED_VALUES_FLAG VARCHAR2 (1)
Y or N flag to indicate if there are restricted values
VALIDITY_FLAG VARCHAR2 (1)
Y or N flag to indicate validity
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
TEMPLATE_DISPLAY_FLAG VARCHAR2 (1)
Y or N flag to indicate if rule be displayed for a template
Query Text

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


SELECT BIZRULE_ID
,      DOCTYPE_ID
,      DISPLAY_FLAG
,      REQUIRED_FLAG
,      FIXED_VALUE
,      DEFAULT_VALUE
,      RESTRICTED_VALUES_FLAG
,      VALIDITY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TEMPLATE_DISPLAY_FLAG
FROM PON.PON_AUC_DOCTYPE_RULES;

Dependencies

[top of page]

PON.PON_AUC_DOCTYPE_RULES does not reference any database object

PON.PON_AUC_DOCTYPE_RULES is referenced by following:

SchemaAPPS
SynonymPON_AUC_DOCTYPE_RULES