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


TABLE: AP.JE_FR_DAS_010_NEW

Object Details
Object Name: JE_FR_DAS_010_NEW
Object Type: TABLE
Owner: AP
FND Design Data: TableJE.JE_FR_DAS_010_NEW
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_FR_DAS_010_NEW_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnTYPE_ENREG
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
TYPE_ENREG VARCHAR2 (3) Yes
SIRET_ENTR NUMBER (9)
Z01 VARCHAR2 (12)
Z0_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (4)
Z0_94_2 VARCHAR2 (5)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
Z5 VARCHAR2 (8)
TYPE_FICHIER VARCHAR2 (1)
SIRET_ETAB NUMBER (14)
Z6 VARCHAR2 (5)
ADR_COMPL_ET VARCHAR2 (32)
Z7 VARCHAR2 (1)
ADR_CONCAT_ET VARCHAR2 (64)
ADR_INSEE_ET VARCHAR2 (5)
Z9 VARCHAR2 (1)
ADR_COMMUNE_ET VARCHAR2 (26)
ADR_CPOSTAL_ET VARCHAR2 (5)
Z10 VARCHAR2 (1)
ADR_BUR_DIST_ET VARCHAR2 (26)
Z11 VARCHAR2 (288)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      TYPE_ENREG
,      SIRET_ENTR
,      Z01
,      Z0_94_1
,      CODE_APE
,      Z0_94_2
,      RAISON_SOCIALE
,      ADR_COMPL
,      Z1
,      ADR_CONCAT
,      ADR_INSEE
,      Z3
,      ADR_COMMUNE
,      ADR_CPOSTAL
,      Z4
,      ADR_BUR_DIST
,      Z5
,      TYPE_FICHIER
,      SIRET_ETAB
,      Z6
,      ADR_COMPL_ET
,      Z7
,      ADR_CONCAT_ET
,      ADR_INSEE_ET
,      Z9
,      ADR_COMMUNE_ET
,      ADR_CPOSTAL_ET
,      Z10
,      ADR_BUR_DIST_ET
,      Z11
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM AP.JE_FR_DAS_010_NEW;

Dependencies

[top of page]

AP.JE_FR_DAS_010_NEW does not reference any database object

AP.JE_FR_DAS_010_NEW is referenced by following:

SchemaAP
ViewJE_FR_DAS_010_NEW#