Skip to content

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

TABLE: AZ.AZ_FILES

Object Details
Object Name: AZ_FILES
Object Type: TABLE
Owner: AZ
FND Design Data: TableAZ.AZ_FILES
Subobject Name:
Status: VALID


This table stores runtime files for iSetups.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_FILES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_HDR_ID
ColumnCONFIG_REV_NBR
SYS_IL0000192707C00009$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
CONFIG_HDR_ID NUMBER (9) Yes Config id of the configuration of which this file belongs to
CONFIG_REV_NBR NUMBER (9) Yes The revision number of the configuration
NAME VARCHAR2 (255)
Name of the file
DESCRIPTION VARCHAR2 (4000)
Description of the file
DISPLAYNAME VARCHAR2 (255)
Display name of the file
MISC1 VARCHAR2 (4000)
Reserved for future use deprecated
MISC2 VARCHAR2 (4000)
Reserved for future use deprecated
MISC3 VARCHAR2 (4000)
Reserved for future use deprecated
CONTENT BLOB (4000)
Content of the file
CREATED_BY NUMBER (15) Yes Standard who/date columns
CREATION_DATE DATE
Yes Standard who/date columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who/date columns
LAST_UPDATE_DATE DATE
Yes Standard who/date columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard who/date columns
Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      NAME
,      DESCRIPTION
,      DISPLAYNAME
,      MISC1
,      MISC2
,      MISC3
,      CONTENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AZ.AZ_FILES;

Dependencies

[top of page]

AZ.AZ_FILES does not reference any database object

AZ.AZ_FILES is referenced by following:

SchemaAZ
ViewAZ_FILES#