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


TABLE: AR.HZ_PARTY_SITES_EXT_B

Object Details
Object Name: HZ_PARTY_SITES_EXT_B
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_PARTY_SITES_EXT_B
Subobject Name:
Status: VALID


Stores extensible attributes for party sites.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_PARTY_SITES_EXT_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTENSION_ID
HZ_PARTY_SITES_EXT_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_SITE_ID
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER (15) Yes Unique system-generated identifier of extension row
PARTY_SITE_ID NUMBER (15) Yes Identifier of party site that extensible attribute values are entered for
ATTR_GROUP_ID NUMBER (15) Yes Attribute group identifier
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
C_EXT_ATTR1 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR2 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR3 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR4 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR5 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR6 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR7 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR8 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR9 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR10 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR11 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR12 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR13 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR14 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR15 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR16 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR17 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR18 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR19 VARCHAR2 (150)
Character based extensible attribute column
C_EXT_ATTR20 VARCHAR2 (150)
Character based extensible attribute column
N_EXT_ATTR1 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR2 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR3 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR4 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR5 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR6 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR7 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR8 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR9 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR10 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR11 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR12 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR13 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR14 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR15 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR16 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR17 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR18 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR19 NUMBER (22)
Number based extensible attribute column
N_EXT_ATTR20 NUMBER (22)
Number based extensible attribute column
D_EXT_ATTR1 DATE

Date based extensible attribute column
D_EXT_ATTR2 DATE

Date based extensible attribute column
D_EXT_ATTR3 DATE

Date based extensible attribute column
D_EXT_ATTR4 DATE

Date based extensible attribute column
D_EXT_ATTR5 DATE

Date based extensible attribute column
D_EXT_ATTR6 DATE

Date based extensible attribute column
D_EXT_ATTR7 DATE

Date based extensible attribute column
D_EXT_ATTR8 DATE

Date based extensible attribute column
D_EXT_ATTR9 DATE

Date based extensible attribute column
D_EXT_ATTR10 DATE

Date based extensible attribute column
Query Text

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


SELECT EXTENSION_ID
,      PARTY_SITE_ID
,      ATTR_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      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
,      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
,      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
FROM AR.HZ_PARTY_SITES_EXT_B;

Dependencies

[top of page]

AR.HZ_PARTY_SITES_EXT_B does not reference any database object

AR.HZ_PARTY_SITES_EXT_B is referenced by following:

SchemaAPPS
SynonymHZ_PARTY_SITES_EXT_B