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

TABLE: PON.PON_NEGOTIATION_STYLES

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


PON_NEGOTIATION_STYLES stores negotiation style related information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_NEGOTIATION_STYLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTYLE_ID
Columns
Name Datatype Length Mandatory Comments
STYLE_ID NUMBER
Yes Style id
STATUS VARCHAR2 (30) Yes Style status: ACTIVE or INACTIVE
SYSTEM_FLAG VARCHAR2 (1)
Y/N flag to indicate if the style is created by user or seeded.
LINE_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if the attribute is enabled.
LINE_MAS_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if MAS is enabled.
PRICE_ELEMENT_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if price element is enabled.
RFI_LINE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if line is enabled, applicable to RFI.
LOT_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if lot is enabled.
GROUP_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if group is enabled.
LARGE_NEG_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if large negotiation is enabled.
HDR_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if header attribute is enabled.
NEG_TEAM_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if collaboration team is enabled.
PROXY_BIDDING_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if proxy bidding is enabled.
POWER_BIDDING_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if power bidding is enabled.
AUTO_EXTEND_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if auto-extension is enabled.
TEAM_SCORING_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if team scoring is enabled.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
QTY_PRICE_TIERS_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if quantity based price tiers is enabled.
Query Text

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


SELECT STYLE_ID
,      STATUS
,      SYSTEM_FLAG
,      LINE_ATTRIBUTE_ENABLED_FLAG
,      LINE_MAS_ENABLED_FLAG
,      PRICE_ELEMENT_ENABLED_FLAG
,      RFI_LINE_ENABLED_FLAG
,      LOT_ENABLED_FLAG
,      GROUP_ENABLED_FLAG
,      LARGE_NEG_ENABLED_FLAG
,      HDR_ATTRIBUTE_ENABLED_FLAG
,      NEG_TEAM_ENABLED_FLAG
,      PROXY_BIDDING_ENABLED_FLAG
,      POWER_BIDDING_ENABLED_FLAG
,      AUTO_EXTEND_ENABLED_FLAG
,      TEAM_SCORING_ENABLED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      QTY_PRICE_TIERS_ENABLED_FLAG
FROM PON.PON_NEGOTIATION_STYLES;

Dependencies

[top of page]

PON.PON_NEGOTIATION_STYLES does not reference any database object

PON.PON_NEGOTIATION_STYLES is referenced by following:

SchemaAPPS
SynonymPON_NEGOTIATION_STYLES