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


TABLE: PON.PON_AUC_BIZRULE_VALUES

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


PON_AUC_BIZRULE_VALUES is used by the Negotiation Builder to store the restricted set of values for a business rule.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUC_BIZRULE_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDOCTYPE_ID
ColumnBIZRULE_ID
ColumnLOOKUP_CODE
Columns
Name Datatype Length Mandatory Comments
BIZRULE_ID NUMBER
Yes Identifier for business rule
DOCTYPE_ID NUMBER
Yes Identifier to document type
LOOKUP_CODE VARCHAR2 (100) Yes Lookup code associated with this business rule specific to the document.
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
ORDER_BY NUMBER

Order By for the lookup type values
Query Text

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


SELECT BIZRULE_ID
,      DOCTYPE_ID
,      LOOKUP_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ORDER_BY
FROM PON.PON_AUC_BIZRULE_VALUES;

Dependencies

[top of page]

PON.PON_AUC_BIZRULE_VALUES does not reference any database object

PON.PON_AUC_BIZRULE_VALUES is referenced by following:

SchemaAPPS
SynonymPON_AUC_BIZRULE_VALUES