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

VIEW: AP.JE_FR_DAS_010_NEW#

Object Details
Object Name: JE_FR_DAS_010_NEW#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

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# references the following:

SchemaAP
TableJE_FR_DAS_010_NEW
AP.JE_FR_DAS_010_NEW# is referenced by following:

SchemaAPPS
SynonymJE_FR_DAS_010_NEW