[Home] [Help] [Dependency Information]
Object Name: | PON_AUCTION_ITEM_PRICES_EXT_B |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.PON_AUCTION_ITEM_PRICES_EXT_B |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Yes | Stores the extension_id | |
ATTR_GROUP_ID | VARCHAR2 | (30) | Yes | Stores the Attribute Group ID |
AUCTION_HEADER_ID | NUMBER | Yes | Stores the auction header id references PON_AUCTION_HEADERS_EXT | |
LINE_NUMBER | NUMBER | Yes | 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 | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | 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) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, ATTR_GROUP_ID
, AUCTION_HEADER_ID
, LINE_NUMBER
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, C_EXT_ATTR1
, C_EXT_ATTR2
, C_EXT_ATTR3
, C_EXT_ATTR4
, C_EXT_ATTR5
, C_EXT_ATTR6
, C_EXT_ATTR7
, C_EXT_ATTR8
, C_EXT_ATTR9
, C_EXT_ATTR10
, C_EXT_ATTR11
, C_EXT_ATTR12
, C_EXT_ATTR13
, C_EXT_ATTR14
, C_EXT_ATTR15
, C_EXT_ATTR16
, C_EXT_ATTR17
, C_EXT_ATTR18
, C_EXT_ATTR19
, C_EXT_ATTR20
, C_EXT_ATTR21
, C_EXT_ATTR22
, C_EXT_ATTR23
, C_EXT_ATTR24
, C_EXT_ATTR25
, C_EXT_ATTR26
, C_EXT_ATTR27
, C_EXT_ATTR28
, C_EXT_ATTR29
, C_EXT_ATTR30
, C_EXT_ATTR31
, C_EXT_ATTR32
, C_EXT_ATTR33
, C_EXT_ATTR34
, C_EXT_ATTR35
, C_EXT_ATTR36
, C_EXT_ATTR37
, C_EXT_ATTR38
, C_EXT_ATTR39
, C_EXT_ATTR40
, N_EXT_ATTR1
, N_EXT_ATTR2
, N_EXT_ATTR3
, N_EXT_ATTR4
, N_EXT_ATTR5
, N_EXT_ATTR6
, N_EXT_ATTR7
, N_EXT_ATTR8
, N_EXT_ATTR9
, N_EXT_ATTR10
, N_EXT_ATTR11
, N_EXT_ATTR12
, N_EXT_ATTR13
, N_EXT_ATTR14
, N_EXT_ATTR15
, N_EXT_ATTR16
, N_EXT_ATTR17
, N_EXT_ATTR18
, N_EXT_ATTR19
, N_EXT_ATTR20
, UOM_EXT_ATTR1
, UOM_EXT_ATTR2
, UOM_EXT_ATTR3
, UOM_EXT_ATTR4
, UOM_EXT_ATTR5
, UOM_EXT_ATTR6
, UOM_EXT_ATTR7
, UOM_EXT_ATTR8
, UOM_EXT_ATTR9
, UOM_EXT_ATTR10
, UOM_EXT_ATTR11
, UOM_EXT_ATTR12
, UOM_EXT_ATTR13
, UOM_EXT_ATTR14
, UOM_EXT_ATTR15
, UOM_EXT_ATTR16
, UOM_EXT_ATTR17
, UOM_EXT_ATTR18
, UOM_EXT_ATTR19
, UOM_EXT_ATTR20
, D_EXT_ATTR1
, D_EXT_ATTR2
, D_EXT_ATTR3
, D_EXT_ATTR4
, D_EXT_ATTR5
, D_EXT_ATTR6
, D_EXT_ATTR7
, D_EXT_ATTR8
, D_EXT_ATTR9
, D_EXT_ATTR10
, UDA_TEMPLATE_ID
FROM PO.PON_AUCTION_ITEM_PRICES_EXT_B;
PO.PON_AUCTION_ITEM_PRICES_EXT_B does not reference any database object
PO.PON_AUCTION_ITEM_PRICES_EXT_B is referenced by following:
|
|
|