Table: PON_AUCTION_HEADERS_EXT_B
| Description: |
|---|
Comments
This table stores the data for User Defined Attributes linked to the Solicitation Header. Corresponding to each solicitation header record, there will be one record per attribute group associated for single row Attribute groups. For multi row attribute groups (such as addresses) there will be one record per row of the multi row attribute group. Extension_id (sequence generated) is the primary key for the table. For single row attribute groups, the combination of auction_header_id and attribute_group_id will also be unique. For multi row attribute groups, the uniqueness will be on auction_header_id, attribute_group_id + the database columns which map to the attributes which are part of the unique key for that attribute group.
Primary Key: PON_AUC_HEADERS_EXT_B_PK
- EXTENSION_ID
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PON_AUC_HEADERS_EXT_B_PK | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores the EXTENSION_ID | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores the Stores the ATTR_GROUP_ID of the attribute group of the attribute group |
| AUCTION_HEADER_ID | NUMBER | Y | Stores Auction Header ID, Unique Identifier | |
| DATA_LEVEL_ID | NUMBER | Stores Data Level ID. | ||
| PK1_VALUE | NUMBER | PK1_VALUE | ||
| PK2_VALUE | NUMBER | PK2_VALUE | ||
| PK3_VALUE | NUMBER | PK3_VALUE | ||
| PK4_VALUE | NUMBER | PK4_VALUE | ||
| PK5_VALUE | NUMBER | PK5_VALUE | ||
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| C_EXT_ATTR1 | VARCHAR2 | (4000) | C_EXT_ATTR1 | |
| C_EXT_ATTR2 | VARCHAR2 | (4000) | C_EXT_ATTR2 | |
| C_EXT_ATTR3 | VARCHAR2 | (4000) | C_EXT_ATTR3 | |
| C_EXT_ATTR4 | VARCHAR2 | (4000) | C_EXT_ATTR4 | |
| C_EXT_ATTR5 | VARCHAR2 | (4000) | C_EXT_ATTR5 | |
| C_EXT_ATTR6 | VARCHAR2 | (4000) | C_EXT_ATTR6 | |
| C_EXT_ATTR7 | VARCHAR2 | (4000) | C_EXT_ATTR7 | |
| C_EXT_ATTR8 | VARCHAR2 | (4000) | C_EXT_ATTR8 | |
| C_EXT_ATTR9 | VARCHAR2 | (4000) | C_EXT_ATTR9 | |
| C_EXT_ATTR10 | VARCHAR2 | (4000) | C_EXT_ATTR10 | |
| C_EXT_ATTR11 | VARCHAR2 | (4000) | C_EXT_ATTR11 | |
| C_EXT_ATTR12 | VARCHAR2 | (4000) | C_EXT_ATTR12 | |
| C_EXT_ATTR13 | VARCHAR2 | (4000) | C_EXT_ATTR13 | |
| C_EXT_ATTR14 | VARCHAR2 | (4000) | C_EXT_ATTR14 | |
| C_EXT_ATTR15 | VARCHAR2 | (4000) | C_EXT_ATTR15 | |
| C_EXT_ATTR16 | VARCHAR2 | (4000) | C_EXT_ATTR16 | |
| C_EXT_ATTR17 | VARCHAR2 | (4000) | C_EXT_ATTR17 | |
| C_EXT_ATTR18 | VARCHAR2 | (4000) | C_EXT_ATTR18 | |
| C_EXT_ATTR19 | VARCHAR2 | (4000) | C_EXT_ATTR19 | |
| C_EXT_ATTR20 | VARCHAR2 | (4000) | C_EXT_ATTR20 | |
| C_EXT_ATTR21 | VARCHAR2 | (4000) | C_EXT_ATTR21 | |
| C_EXT_ATTR22 | VARCHAR2 | (4000) | C_EXT_ATTR22 | |
| C_EXT_ATTR23 | VARCHAR2 | (4000) | C_EXT_ATTR23 | |
| C_EXT_ATTR24 | VARCHAR2 | (4000) | C_EXT_ATTR24 | |
| C_EXT_ATTR25 | VARCHAR2 | (4000) | C_EXT_ATTR25 | |
| C_EXT_ATTR26 | VARCHAR2 | (4000) | C_EXT_ATTR26 | |
| C_EXT_ATTR27 | VARCHAR2 | (4000) | C_EXT_ATTR27 | |
| C_EXT_ATTR28 | VARCHAR2 | (4000) | C_EXT_ATTR28 | |
| C_EXT_ATTR29 | VARCHAR2 | (4000) | C_EXT_ATTR29 | |
| C_EXT_ATTR30 | VARCHAR2 | (4000) | C_EXT_ATTR30 | |
| C_EXT_ATTR31 | VARCHAR2 | (4000) | C_EXT_ATTR31 | |
| C_EXT_ATTR32 | VARCHAR2 | (4000) | C_EXT_ATTR32 | |
| C_EXT_ATTR33 | VARCHAR2 | (4000) | C_EXT_ATTR33 | |
| C_EXT_ATTR34 | VARCHAR2 | (4000) | C_EXT_ATTR34 | |
| C_EXT_ATTR35 | VARCHAR2 | (4000) | C_EXT_ATTR35 | |
| C_EXT_ATTR36 | VARCHAR2 | (4000) | C_EXT_ATTR36 | |
| C_EXT_ATTR37 | VARCHAR2 | (4000) | C_EXT_ATTR37 | |
| C_EXT_ATTR38 | VARCHAR2 | (4000) | C_EXT_ATTR38 | |
| C_EXT_ATTR39 | VARCHAR2 | (4000) | C_EXT_ATTR39 | |
| C_EXT_ATTR40 | VARCHAR2 | (4000) | C_EXT_ATTR40 | |
| N_EXT_ATTR1 | NUMBER | N_EXT_ATTR1 | ||
| N_EXT_ATTR2 | NUMBER | N_EXT_ATTR2 | ||
| N_EXT_ATTR3 | NUMBER | N_EXT_ATTR3 | ||
| N_EXT_ATTR4 | NUMBER | N_EXT_ATTR4 | ||
| N_EXT_ATTR5 | NUMBER | N_EXT_ATTR5 | ||
| N_EXT_ATTR6 | NUMBER | N_EXT_ATTR6 | ||
| N_EXT_ATTR7 | NUMBER | N_EXT_ATTR7 | ||
| N_EXT_ATTR8 | NUMBER | N_EXT_ATTR8 | ||
| N_EXT_ATTR9 | NUMBER | N_EXT_ATTR9 | ||
| N_EXT_ATTR10 | NUMBER | N_EXT_ATTR10 | ||
| N_EXT_ATTR11 | NUMBER | N_EXT_ATTR11 | ||
| N_EXT_ATTR12 | NUMBER | N_EXT_ATTR12 | ||
| N_EXT_ATTR13 | NUMBER | N_EXT_ATTR13 | ||
| N_EXT_ATTR14 | NUMBER | N_EXT_ATTR14 | ||
| N_EXT_ATTR15 | NUMBER | N_EXT_ATTR15 | ||
| N_EXT_ATTR16 | NUMBER | N_EXT_ATTR16 | ||
| N_EXT_ATTR17 | NUMBER | N_EXT_ATTR17 | ||
| N_EXT_ATTR18 | NUMBER | N_EXT_ATTR18 | ||
| N_EXT_ATTR19 | NUMBER | N_EXT_ATTR19 | ||
| N_EXT_ATTR20 | NUMBER | N_EXT_ATTR20 | ||
| UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM_EXT_ATTR1 | |
| UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM_EXT_ATTR2 | |
| UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM_EXT_ATTR3 | |
| UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM_EXT_ATTR4 | |
| UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM_EXT_ATTR5 | |
| UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM_EXT_ATTR6 | |
| UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM_EXT_ATTR7 | |
| UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM_EXT_ATTR8 | |
| UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM_EXT_ATTR9 | |
| UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM_EXT_ATTR10 | |
| UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM_EXT_ATTR11 | |
| UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM_EXT_ATTR12 | |
| UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM_EXT_ATTR13 | |
| UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM_EXT_ATTR14 | |
| UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM_EXT_ATTR15 | |
| UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM_EXT_ATTR16 | |
| UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM_EXT_ATTR17 | |
| UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM_EXT_ATTR18 | |
| UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM_EXT_ATTR19 | |
| UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM_EXT_ATTR20 | |
| D_EXT_ATTR1 | DATE | D_EXT_ATTR1 | ||
| D_EXT_ATTR2 | DATE | D_EXT_ATTR2 | ||
| D_EXT_ATTR3 | DATE | D_EXT_ATTR3 | ||
| D_EXT_ATTR4 | DATE | D_EXT_ATTR4 | ||
| D_EXT_ATTR5 | DATE | D_EXT_ATTR5 | ||
| D_EXT_ATTR6 | DATE | D_EXT_ATTR6 | ||
| D_EXT_ATTR7 | DATE | D_EXT_ATTR7 | ||
| D_EXT_ATTR8 | DATE | D_EXT_ATTR8 | ||
| D_EXT_ATTR9 | DATE | D_EXT_ATTR9 | ||
| D_EXT_ATTR10 | DATE | D_EXT_ATTR10 | ||
| UDA_TEMPLATE_ID | NUMBER | UDA_TEMPLATE_ID |
PO.PON_AUCTION_HEADERS_EXT_B does not reference any database object
PO.PON_AUCTION_HEADERS_EXT_B is referenced by following:
- PO
- VIEW - PON_AUCTION_HEADERS_EXT_B#
Table: PON_AUCTION_HEADERS_EXT_TL
| Description: | Stores the UDA Attributes of the negotiations header level details. |
|---|
Comments
This is the translation table corresponding to PON_AUCTION_HEADERS_EXT_B. This stores the data for translatable user defined attributes.
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores extension_id | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores the Attribute Group ID. |
| AUCTION_HEADER_ID | NUMBER | Stores Auction_header_id , Unique Identifier. | ||
| DATA_LEVEL_ID | NUMBER | Stores Data level ID. | ||
| PK1_VALUE | NUMBER | PK1_VALUE | ||
| PK2_VALUE | NUMBER | PK2_VALUE | ||
| PK3_VALUE | NUMBER | PK3_VALUE | ||
| PK4_VALUE | NUMBER | PK4_VALUE | ||
| PK5_VALUE | NUMBER | PK5_VALUE | ||
| SOURCE_LANG | VARCHAR2 | (30) | Y | Stores the identifier of the Source language |
| LANGUAGE | VARCHAR2 | (30) | Y | Stores the language |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| TL_EXT_ATTR1 | VARCHAR2 | (4000) | TL_EXT_ATTR1 | |
| TL_EXT_ATTR2 | VARCHAR2 | (4000) | TL_EXT_ATTR2 | |
| TL_EXT_ATTR3 | VARCHAR2 | (4000) | TL_EXT_ATTR3 | |
| TL_EXT_ATTR4 | VARCHAR2 | (4000) | TL_EXT_ATTR4 | |
| TL_EXT_ATTR5 | VARCHAR2 | (4000) | TL_EXT_ATTR5 | |
| TL_EXT_ATTR6 | VARCHAR2 | (4000) | TL_EXT_ATTR6 | |
| TL_EXT_ATTR7 | VARCHAR2 | (4000) | TL_EXT_ATTR7 | |
| TL_EXT_ATTR8 | VARCHAR2 | (4000) | TL_EXT_ATTR8 | |
| TL_EXT_ATTR9 | VARCHAR2 | (4000) | TL_EXT_ATTR9 | |
| TL_EXT_ATTR10 | VARCHAR2 | (4000) | TL_EXT_ATTR10 | |
| TL_EXT_ATTR11 | VARCHAR2 | (4000) | TL_EXT_ATTR11 | |
| TL_EXT_ATTR12 | VARCHAR2 | (4000) | TL_EXT_ATTR12 | |
| TL_EXT_ATTR13 | VARCHAR2 | (4000) | TL_EXT_ATTR13 | |
| TL_EXT_ATTR14 | VARCHAR2 | (4000) | TL_EXT_ATTR14 | |
| TL_EXT_ATTR15 | VARCHAR2 | (4000) | TL_EXT_ATTR15 | |
| TL_EXT_ATTR16 | VARCHAR2 | (4000) | TL_EXT_ATTR16 | |
| TL_EXT_ATTR17 | VARCHAR2 | (4000) | TL_EXT_ATTR17 | |
| TL_EXT_ATTR18 | VARCHAR2 | (4000) | TL_EXT_ATTR18 | |
| TL_EXT_ATTR19 | VARCHAR2 | (4000) | TL_EXT_ATTR19 | |
| TL_EXT_ATTR20 | VARCHAR2 | (4000) | TL_EXT_ATTR20 | |
| TL_EXT_ATTR21 | VARCHAR2 | (4000) | TL_EXT_ATTR21 | |
| TL_EXT_ATTR22 | VARCHAR2 | (4000) | TL_EXT_ATTR22 | |
| TL_EXT_ATTR23 | VARCHAR2 | (4000) | TL_EXT_ATTR23 | |
| TL_EXT_ATTR24 | VARCHAR2 | (4000) | TL_EXT_ATTR24 | |
| TL_EXT_ATTR25 | VARCHAR2 | (4000) | TL_EXT_ATTR25 | |
| TL_EXT_ATTR26 | VARCHAR2 | (4000) | TL_EXT_ATTR26 | |
| TL_EXT_ATTR27 | VARCHAR2 | (4000) | TL_EXT_ATTR27 | |
| TL_EXT_ATTR28 | VARCHAR2 | (4000) | TL_EXT_ATTR28 | |
| TL_EXT_ATTR29 | VARCHAR2 | (4000) | TL_EXT_ATTR29 | |
| TL_EXT_ATTR30 | VARCHAR2 | (4000) | TL_EXT_ATTR30 | |
| TL_EXT_ATTR31 | VARCHAR2 | (4000) | TL_EXT_ATTR31 | |
| TL_EXT_ATTR32 | VARCHAR2 | (4000) | TL_EXT_ATTR32 | |
| TL_EXT_ATTR33 | VARCHAR2 | (4000) | TL_EXT_ATTR33 | |
| TL_EXT_ATTR34 | VARCHAR2 | (4000) | TL_EXT_ATTR34 | |
| TL_EXT_ATTR35 | VARCHAR2 | (4000) | TL_EXT_ATTR35 | |
| TL_EXT_ATTR36 | VARCHAR2 | (4000) | TL_EXT_ATTR36 | |
| TL_EXT_ATTR37 | VARCHAR2 | (4000) | TL_EXT_ATTR37 | |
| TL_EXT_ATTR38 | VARCHAR2 | (4000) | TL_EXT_ATTR38 | |
| TL_EXT_ATTR39 | VARCHAR2 | (4000) | TL_EXT_ATTR39 | |
| TL_EXT_ATTR40 | VARCHAR2 | (4000) | TL_EXT_ATTR40 | |
| UDA_TEMPLATE_ID | NUMBER | UDA_TEMPLATE_ID |
PO.PON_AUCTION_HEADERS_EXT_TL does not reference any database object
PO.PON_AUCTION_HEADERS_EXT_TL is referenced by following:
- PO
- VIEW - PON_AUCTION_HEADERS_EXT_TL#
Table: PON_AUCTION_ITEM_PRICES_EXT_B
| Description: | Stores the UDA attibutes of negotiation item details including price |
|---|
Comments
This table stores the data for User Defined Attributes linked to the Solicitation line. Corresponding to each solicitation line record, there will be one record per attribute group associated for single row Attribute groups. For multi row attribute groups (such as addresses) there will be one record per row of the multi row attribute group. Extension_id (sequence generated) is the primary key for the table. For single row attribute groups, the combination of auction_header_id, line_number and attribute_group_id will also be unique. For multi row attribute groups, the uniqueness will be on auction_header_id, line_number, attribute_group_id + the database columns which map to the attributes which are part of the unique key for that attribute group.
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores the extension_id | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores the Attribute Group ID |
| AUCTION_HEADER_ID | NUMBER | Y | Stores the auction header id references PON_AUCTION_HEADERS_EXT | |
| LINE_NUMBER | NUMBER | Y | Stores the Line number , Unique Identifier | |
| DATA_LEVEL_ID | NUMBER | Stores the data level ID | ||
| PK1_VALUE | NUMBER | PK1_VALUE | ||
| PK2_VALUE | NUMBER | PK2_VALUE | ||
| PK3_VALUE | NUMBER | PK3_VALUE | ||
| PK4_VALUE | NUMBER | PK4_VALUE | ||
| PK5_VALUE | NUMBER | PK5_VALUE | ||
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| C_EXT_ATTR1 | VARCHAR2 | (4000) | C_EXT_ATTR1 | |
| C_EXT_ATTR2 | VARCHAR2 | (4000) | C_EXT_ATTR2 | |
| C_EXT_ATTR3 | VARCHAR2 | (4000) | C_EXT_ATTR3 | |
| C_EXT_ATTR4 | VARCHAR2 | (4000) | C_EXT_ATTR4 | |
| C_EXT_ATTR5 | VARCHAR2 | (4000) | C_EXT_ATTR5 | |
| C_EXT_ATTR6 | VARCHAR2 | (4000) | C_EXT_ATTR6 | |
| C_EXT_ATTR7 | VARCHAR2 | (4000) | C_EXT_ATTR7 | |
| C_EXT_ATTR8 | VARCHAR2 | (4000) | C_EXT_ATTR8 | |
| C_EXT_ATTR9 | VARCHAR2 | (4000) | C_EXT_ATTR9 | |
| C_EXT_ATTR10 | VARCHAR2 | (4000) | C_EXT_ATTR10 | |
| C_EXT_ATTR11 | VARCHAR2 | (4000) | C_EXT_ATTR11 | |
| C_EXT_ATTR12 | VARCHAR2 | (4000) | C_EXT_ATTR12 | |
| C_EXT_ATTR13 | VARCHAR2 | (4000) | C_EXT_ATTR13 | |
| C_EXT_ATTR14 | VARCHAR2 | (4000) | C_EXT_ATTR14 | |
| C_EXT_ATTR15 | VARCHAR2 | (4000) | C_EXT_ATTR15 | |
| C_EXT_ATTR16 | VARCHAR2 | (4000) | C_EXT_ATTR16 | |
| C_EXT_ATTR17 | VARCHAR2 | (4000) | C_EXT_ATTR17 | |
| C_EXT_ATTR18 | VARCHAR2 | (4000) | C_EXT_ATTR18 | |
| C_EXT_ATTR19 | VARCHAR2 | (4000) | C_EXT_ATTR19 | |
| C_EXT_ATTR20 | VARCHAR2 | (4000) | C_EXT_ATTR20 | |
| C_EXT_ATTR21 | VARCHAR2 | (4000) | C_EXT_ATTR21 | |
| C_EXT_ATTR22 | VARCHAR2 | (4000) | C_EXT_ATTR22 | |
| C_EXT_ATTR23 | VARCHAR2 | (4000) | C_EXT_ATTR23 | |
| C_EXT_ATTR24 | VARCHAR2 | (4000) | C_EXT_ATTR24 | |
| C_EXT_ATTR25 | VARCHAR2 | (4000) | C_EXT_ATTR25 | |
| C_EXT_ATTR26 | VARCHAR2 | (4000) | C_EXT_ATTR26 | |
| C_EXT_ATTR27 | VARCHAR2 | (4000) | C_EXT_ATTR27 | |
| C_EXT_ATTR28 | VARCHAR2 | (4000) | C_EXT_ATTR28 | |
| C_EXT_ATTR29 | VARCHAR2 | (4000) | C_EXT_ATTR29 | |
| C_EXT_ATTR30 | VARCHAR2 | (4000) | C_EXT_ATTR30 | |
| C_EXT_ATTR31 | VARCHAR2 | (4000) | C_EXT_ATTR31 | |
| C_EXT_ATTR32 | VARCHAR2 | (4000) | C_EXT_ATTR32 | |
| C_EXT_ATTR33 | VARCHAR2 | (4000) | C_EXT_ATTR33 | |
| C_EXT_ATTR34 | VARCHAR2 | (4000) | C_EXT_ATTR34 | |
| C_EXT_ATTR35 | VARCHAR2 | (4000) | C_EXT_ATTR35 | |
| C_EXT_ATTR36 | VARCHAR2 | (4000) | C_EXT_ATTR36 | |
| C_EXT_ATTR37 | VARCHAR2 | (4000) | C_EXT_ATTR37 | |
| C_EXT_ATTR38 | VARCHAR2 | (4000) | C_EXT_ATTR38 | |
| C_EXT_ATTR39 | VARCHAR2 | (4000) | C_EXT_ATTR39 | |
| C_EXT_ATTR40 | VARCHAR2 | (4000) | C_EXT_ATTR40 | |
| N_EXT_ATTR1 | NUMBER | N_EXT_ATTR1 | ||
| N_EXT_ATTR2 | NUMBER | N_EXT_ATTR2 | ||
| N_EXT_ATTR3 | NUMBER | N_EXT_ATTR3 | ||
| N_EXT_ATTR4 | NUMBER | N_EXT_ATTR4 | ||
| N_EXT_ATTR5 | NUMBER | N_EXT_ATTR5 | ||
| N_EXT_ATTR6 | NUMBER | N_EXT_ATTR6 | ||
| N_EXT_ATTR7 | NUMBER | N_EXT_ATTR7 | ||
| N_EXT_ATTR8 | NUMBER | N_EXT_ATTR8 | ||
| N_EXT_ATTR9 | NUMBER | N_EXT_ATTR9 | ||
| N_EXT_ATTR10 | NUMBER | N_EXT_ATTR10 | ||
| N_EXT_ATTR11 | NUMBER | N_EXT_ATTR11 | ||
| N_EXT_ATTR12 | NUMBER | N_EXT_ATTR12 | ||
| N_EXT_ATTR13 | NUMBER | N_EXT_ATTR13 | ||
| N_EXT_ATTR14 | NUMBER | N_EXT_ATTR14 | ||
| N_EXT_ATTR15 | NUMBER | N_EXT_ATTR15 | ||
| N_EXT_ATTR16 | NUMBER | N_EXT_ATTR16 | ||
| N_EXT_ATTR17 | NUMBER | N_EXT_ATTR17 | ||
| N_EXT_ATTR18 | NUMBER | N_EXT_ATTR18 | ||
| N_EXT_ATTR19 | NUMBER | N_EXT_ATTR19 | ||
| N_EXT_ATTR20 | NUMBER | N_EXT_ATTR20 | ||
| UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM_EXT_ATTR1 | |
| UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM_EXT_ATTR2 | |
| UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM_EXT_ATTR3 | |
| UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM_EXT_ATTR4 | |
| UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM_EXT_ATTR5 | |
| UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM_EXT_ATTR6 | |
| UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM_EXT_ATTR7 | |
| UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM_EXT_ATTR8 | |
| UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM_EXT_ATTR9 | |
| UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM_EXT_ATTR10 | |
| UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM_EXT_ATTR11 | |
| UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM_EXT_ATTR12 | |
| UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM_EXT_ATTR13 | |
| UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM_EXT_ATTR14 | |
| UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM_EXT_ATTR15 | |
| UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM_EXT_ATTR16 | |
| UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM_EXT_ATTR17 | |
| UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM_EXT_ATTR18 | |
| UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM_EXT_ATTR19 | |
| UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM_EXT_ATTR20 | |
| D_EXT_ATTR1 | DATE | D_EXT_ATTR1 | ||
| D_EXT_ATTR2 | DATE | D_EXT_ATTR2 | ||
| D_EXT_ATTR3 | DATE | D_EXT_ATTR3 | ||
| D_EXT_ATTR4 | DATE | D_EXT_ATTR4 | ||
| D_EXT_ATTR5 | DATE | D_EXT_ATTR5 | ||
| D_EXT_ATTR6 | DATE | D_EXT_ATTR6 | ||
| D_EXT_ATTR7 | DATE | D_EXT_ATTR7 | ||
| D_EXT_ATTR8 | DATE | D_EXT_ATTR8 | ||
| D_EXT_ATTR9 | DATE | D_EXT_ATTR9 | ||
| D_EXT_ATTR10 | DATE | D_EXT_ATTR10 | ||
| UDA_TEMPLATE_ID | NUMBER | UDA_TEMPLATE_ID |
PO.PON_AUCTION_ITEM_PRICES_EXT_B does not reference any database object
PO.PON_AUCTION_ITEM_PRICES_EXT_B is referenced by following:
- PO
- VIEW - PON_AUCTION_ITEM_PRICES_EXT_B#
Table: PON_AUCTION_ITEM_PRICES_EXT_TL
| Description: | Stores the UDA attibutes of negotiation item details including price |
|---|
Comments
This is the translation table corresponding to PON_AUCTION_ITEM_PRICES_EXT_B. This stores the data for translatable user defined attributes.
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores the EXTENSION_ID | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores the ATTR_GROUP_ID of the attribute group |
| AUCTION_HEADER_ID | NUMBER | Stores auction_header_id, unique identifier | ||
| DATA_LEVEL_ID | NUMBER | Stores Data Level ID. | ||
| PK1_VALUE | NUMBER | PK1_VALUE | ||
| PK2_VALUE | NUMBER | PK2_VALUE | ||
| PK3_VALUE | NUMBER | PK3_VALUE | ||
| PK4_VALUE | NUMBER | PK4_VALUE | ||
| PK5_VALUE | NUMBER | PK5_VALUE | ||
| LINE_NUMBER | NUMBER | Stores the line_number. | ||
| SOURCE_LANG | VARCHAR2 | (30) | Y | Stores the identifier of the Source language |
| LANGUAGE | VARCHAR2 | (30) | Y | Stores the language |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
| TL_EXT_ATTR1 | VARCHAR2 | (4000) | TL_EXT_ATTR1 | |
| TL_EXT_ATTR2 | VARCHAR2 | (4000) | TL_EXT_ATTR2 | |
| TL_EXT_ATTR3 | VARCHAR2 | (4000) | TL_EXT_ATTR3 | |
| TL_EXT_ATTR4 | VARCHAR2 | (4000) | TL_EXT_ATTR4 | |
| TL_EXT_ATTR5 | VARCHAR2 | (4000) | TL_EXT_ATTR5 | |
| TL_EXT_ATTR6 | VARCHAR2 | (4000) | TL_EXT_ATTR6 | |
| TL_EXT_ATTR7 | VARCHAR2 | (4000) | TL_EXT_ATTR7 | |
| TL_EXT_ATTR8 | VARCHAR2 | (4000) | TL_EXT_ATTR8 | |
| TL_EXT_ATTR9 | VARCHAR2 | (4000) | TL_EXT_ATTR9 | |
| TL_EXT_ATTR10 | VARCHAR2 | (4000) | TL_EXT_ATTR10 | |
| TL_EXT_ATTR11 | VARCHAR2 | (4000) | TL_EXT_ATTR11 | |
| TL_EXT_ATTR12 | VARCHAR2 | (4000) | TL_EXT_ATTR12 | |
| TL_EXT_ATTR13 | VARCHAR2 | (4000) | TL_EXT_ATTR13 | |
| TL_EXT_ATTR14 | VARCHAR2 | (4000) | TL_EXT_ATTR14 | |
| TL_EXT_ATTR15 | VARCHAR2 | (4000) | TL_EXT_ATTR15 | |
| TL_EXT_ATTR16 | VARCHAR2 | (4000) | TL_EXT_ATTR16 | |
| TL_EXT_ATTR17 | VARCHAR2 | (4000) | TL_EXT_ATTR17 | |
| TL_EXT_ATTR18 | VARCHAR2 | (4000) | TL_EXT_ATTR18 | |
| TL_EXT_ATTR19 | VARCHAR2 | (4000) | TL_EXT_ATTR19 | |
| TL_EXT_ATTR20 | VARCHAR2 | (4000) | TL_EXT_ATTR20 | |
| TL_EXT_ATTR21 | VARCHAR2 | (4000) | TL_EXT_ATTR21 | |
| TL_EXT_ATTR22 | VARCHAR2 | (4000) | TL_EXT_ATTR22 | |
| TL_EXT_ATTR23 | VARCHAR2 | (4000) | TL_EXT_ATTR23 | |
| TL_EXT_ATTR24 | VARCHAR2 | (4000) | TL_EXT_ATTR24 | |
| TL_EXT_ATTR25 | VARCHAR2 | (4000) | TL_EXT_ATTR25 | |
| TL_EXT_ATTR26 | VARCHAR2 | (4000) | TL_EXT_ATTR26 | |
| TL_EXT_ATTR27 | VARCHAR2 | (4000) | TL_EXT_ATTR27 | |
| TL_EXT_ATTR28 | VARCHAR2 | (4000) | TL_EXT_ATTR28 | |
| TL_EXT_ATTR29 | VARCHAR2 | (4000) | TL_EXT_ATTR29 | |
| TL_EXT_ATTR30 | VARCHAR2 | (4000) | TL_EXT_ATTR30 | |
| TL_EXT_ATTR31 | VARCHAR2 | (4000) | TL_EXT_ATTR31 | |
| TL_EXT_ATTR32 | VARCHAR2 | (4000) | TL_EXT_ATTR32 | |
| TL_EXT_ATTR33 | VARCHAR2 | (4000) | TL_EXT_ATTR33 | |
| TL_EXT_ATTR34 | VARCHAR2 | (4000) | TL_EXT_ATTR34 | |
| TL_EXT_ATTR35 | VARCHAR2 | (4000) | TL_EXT_ATTR35 | |
| TL_EXT_ATTR36 | VARCHAR2 | (4000) | TL_EXT_ATTR36 | |
| TL_EXT_ATTR37 | VARCHAR2 | (4000) | TL_EXT_ATTR37 | |
| TL_EXT_ATTR38 | VARCHAR2 | (4000) | TL_EXT_ATTR38 | |
| TL_EXT_ATTR39 | VARCHAR2 | (4000) | TL_EXT_ATTR39 | |
| TL_EXT_ATTR40 | VARCHAR2 | (4000) | TL_EXT_ATTR40 | |
| UDA_TEMPLATE_ID | NUMBER | UDA_TEMPLATE_ID |
PO.PON_AUCTION_ITEM_PRICES_EXT_TL does not reference any database object
