Table: PON_BID_HEADERS_EXT_B
| Description: | Stores the UDA attributes of header level data for a response to a negotiation |
|---|
Primary Key: PON_BID_HEADERS_EXT_B_PK
- EXTENSION_ID
Comments
For future use
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores Extension id. | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores Attribute Group Id |
| BID_NUMBER | NUMBER | Y | Stores the BID Number, 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_BID_HEADERS_EXT_B does not reference any database object
PO.PON_BID_HEADERS_EXT_B is referenced by following:
- PO
- VIEW - PON_BID_HEADERS_EXT_B#
Table: PON_BID_HEADERS_EXT_TL
| Description: | Stores the UDA attributes of header level data for a response to a negotiation |
|---|
Comments
For Future use
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | Y | Stores Extension id. | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores Attribute Group Id |
| BID_NUMBER | NUMBER | Stores the BID Number, 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_BID_HEADERS_EXT_TL does not reference any database object
PO.PON_BID_HEADERS_EXT_TL is referenced by following:
- PO
- VIEW - PON_BID_HEADERS_EXT_TL#
Table: PON_BID_ITEM_PRICES_EXT_B
| Description: | Stores the UDA data of the information regarding the responses submitted by a supplier on a negotiation. |
|---|
Comments
This table stores the data for User Defined Attributes linked to the offer Line. Corresponding to each Offer 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 bid_number, line_number and attribute_group_id will also be unique. For multi row attribute groups, the uniqueness will be on bid_number, 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 Extension id. | |
| ATTR_GROUP_ID | VARCHAR2 | (30) | Y | Stores Attribute Group Id |
| BID_NUMBER | NUMBER | Y | Stores the BID Number, Unique Identifier. | |
| LINE_NUMBER | NUMBER | Y | Stores the LINE_NUMBER of the bid. | |
| 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_BID_ITEM_PRICES_EXT_B does not reference any database object
PO.PON_BID_ITEM_PRICES_EXT_B is referenced by following:
- PO
- VIEW - PON_BID_ITEM_PRICES_EXT_B#
Table: PON_BID_ITEM_PRICES_EXT_TL
| Description: | Stores the UDA data of the information regarding the responses submitted by a supplier on a negotiation. |
|---|
Comments
This is the translation table corresponding to PON_BID_ITEM_PRICES_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 Attribute Group Id |
| BID_NUMBER | NUMBER | Stores the BID Number. | ||
| 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 for the bid. | ||
| 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_BID_ITEM_PRICES_EXT_TL does not reference any database object
