[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_FR_DAS_210_NEW_GLOBAL_TMP |
|---|---|
| Object Type: | TABLE |
| Owner: | JE |
| Subobject Name: | |
| Status: | VALID |
JE.JE_FR_DAS_210_NEW_GLOBAL_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SIREN_ETAB | NUMBER | (9) | ||
| NIC_ETAB | NUMBER | (5) | ||
| SECTION | VARCHAR2 | (2) | ||
| VALIDITE | NUMBER | (4) | ||
| TYPE_DAS | VARCHAR2 | (1) | ||
| TYPE_ENREG | VARCHAR2 | (3) | ||
| SIRET_BENEF | VARCHAR2 | (14) | ||
| NOM | VARCHAR2 | (30) | ||
| PRENOM | VARCHAR2 | (20) | ||
| RAISON_SOCIALE | VARCHAR2 | (50) | ||
| PROFESSION | VARCHAR2 | (30) | ||
| ADR_COMPL | VARCHAR2 | (32) | ||
| Z1 | VARCHAR2 | (1) | ||
| ADR_NUM | VARCHAR2 | (4) | ||
| ADR_TYPE | VARCHAR2 | (1) | ||
| Z2 | VARCHAR2 | (1) | ||
| ADR_VOIE | VARCHAR2 | (26) | ||
| ADR_INSEE | VARCHAR2 | (5) | ||
| Z3 | VARCHAR2 | (1) | ||
| ADR_COMMUNE | VARCHAR2 | (26) | ||
| ADR_CPOSTAL | VARCHAR2 | (5) | ||
| Z4 | VARCHAR2 | (1) | ||
| ADR_BUR_DIST | VARCHAR2 | (26) | ||
| DHON_H | NUMBER | (10) | ||
| DCOM_C | NUMBER | (10) | ||
| DCO_CO | NUMBER | (10) | ||
| DRIS_R | NUMBER | (10) | ||
| DJE_JP | NUMBER | (10) | ||
| DDA_DA | NUMBER | (10) | ||
| DDI_I | NUMBER | (10) | ||
| DAU_AR | NUMBER | (10) | ||
| INDE | NUMBER | (10) | ||
| AVAN | NUMBER | (10) | ||
| RETE | NUMBER | (10) | ||
| NAT_AVAN_NOUR | VARCHAR2 | (1) | ||
| NAT_AVAN_LOGE | VARCHAR2 | (1) | ||
| NAT_AVAN_VOIT | VARCHAR2 | (1) | ||
| NAT_AVAN_AUTR | VARCHAR2 | (1) | ||
| Z5 | VARCHAR2 | (1) | ||
| NAT_RETE_ALLO | VARCHAR2 | (1) | ||
| NAT_RETE_REMB | VARCHAR2 | (1) | ||
| NAT_RETE_PRIS | VARCHAR2 | (1) | ||
| NAT_TVA_REDUI | VARCHAR2 | (1) | ||
| NAT_TVA_DISPE | VARCHAR2 | (1) | ||
| TVA_NETTE | NUMBER | (10) | ||
| Z6 | VARCHAR2 | (245) | ||
| SEGMENT1 | VARCHAR2 | (30) | ||
| AGE_11 | NUMBER | (12) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | ||
| VENDOR_SITE_ID | NUMBER | |||
| CHECK_NUMBER | NUMBER | (15) | ||
| VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
| INVOICE_NUM | VARCHAR2 | (50) | ||
| VENDOR_NAME | VARCHAR2 | (80) | ||
| TAX_IDENTIFICATION_NUM | VARCHAR2 | (20) | ||
| INVOICE_AMOUNT | NUMBER | |||
| TYPE_1099 | VARCHAR2 | (10) | ||
| INVOICE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SIREN_ETAB
, NIC_ETAB
, SECTION
, VALIDITE
, TYPE_DAS
, TYPE_ENREG
, SIRET_BENEF
, NOM
, PRENOM
, RAISON_SOCIALE
, PROFESSION
, ADR_COMPL
, Z1
, ADR_NUM
, ADR_TYPE
, Z2
, ADR_VOIE
, ADR_INSEE
, Z3
, ADR_COMMUNE
, ADR_CPOSTAL
, Z4
, ADR_BUR_DIST
, DHON_H
, DCOM_C
, DCO_CO
, DRIS_R
, DJE_JP
, DDA_DA
, DDI_I
, DAU_AR
, INDE
, AVAN
, RETE
, NAT_AVAN_NOUR
, NAT_AVAN_LOGE
, NAT_AVAN_VOIT
, NAT_AVAN_AUTR
, Z5
, NAT_RETE_ALLO
, NAT_RETE_REMB
, NAT_RETE_PRIS
, NAT_TVA_REDUI
, NAT_TVA_DISPE
, TVA_NETTE
, Z6
, SEGMENT1
, AGE_11
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SET_OF_BOOKS_ID
, VENDOR_SITE_ID
, CHECK_NUMBER
, VENDOR_SITE_CODE
, INVOICE_NUM
, VENDOR_NAME
, TAX_IDENTIFICATION_NUM
, INVOICE_AMOUNT
, TYPE_1099
, INVOICE_DATE
FROM JE.JE_FR_DAS_210_NEW_GLOBAL_TMP;
JE.JE_FR_DAS_210_NEW_GLOBAL_TMP does not reference any database object
JE.JE_FR_DAS_210_NEW_GLOBAL_TMP is referenced by following:
APPS
JE_FR_DAS_210_NEW_GLOBAL_TMP
|
|
|
|