eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.JE_FR_DAS_310_NEW

Object Details

Object Name:	JE_FR_DAS_310_NEW
Object Type:	TABLE
Owner:	AP
FND Design Data:	JE.JE_FR_DAS_310_NEW
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
SIREN_ENT	NUMBER	(9)
Z0	VARCHAR2	(12)
TYPE_ENREG	VARCHAR2	(3)
NBRE_ETAB	NUMBER	(5)
NBRE_200	NUMBER	(6)
NBRE_210	NUMBER	(6)
Z1	VARCHAR2	(36)
BASE_BRUTE_FISC	NUMBER	(12)
REMUNERATIONS_NET	NUMBER	(12)
AVANTAGES_NAT	NUMBER	(12)
FRAIS_PROF	NUMBER	(12)
CHEQUE_VAC	NUMBER	(12)
TOTAL_IMPOS	NUMBER	(12)
TOTAL_BASE_IMPOS1	NUMBER	(12)
TOTAL_BASE_IMPOS2	NUMBER	(12)
TOTAL_RET	NUMBER	(12)
DHON_H	NUMBER	(12)
DCOM_C	NUMBER	(12)
DCO_CO	NUMBER	(12)
DRIS_R	NUMBER	(12)
DJE_JP	NUMBER	(12)
DDA_DA	NUMBER	(12)
DDI_I	NUMBER	(12)
DAU_AR	NUMBER	(12)
INDE	NUMBER	(12)
AVAN	NUMBER	(12)
RETE	NUMBER	(12)
Z2	VARCHAR2	(12)
TAXE_SAL	NUMBER	(12)
Z3	VARCHAR2	(12)
EFFECTIF_ENT	NUMBER	(6)
Z4	VARCHAR2	(313)
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
,      SIREN_ENT
,      Z0
,      TYPE_ENREG
,      NBRE_ETAB
,      NBRE_200
,      NBRE_210
,      Z1
,      BASE_BRUTE_FISC
,      REMUNERATIONS_NET
,      AVANTAGES_NAT
,      FRAIS_PROF
,      CHEQUE_VAC
,      TOTAL_IMPOS
,      TOTAL_BASE_IMPOS1
,      TOTAL_BASE_IMPOS2
,      TOTAL_RET
,      DHON_H
,      DCOM_C
,      DCO_CO
,      DRIS_R
,      DJE_JP
,      DDA_DA
,      DDI_I
,      DAU_AR
,      INDE
,      AVAN
,      RETE
,      Z2
,      TAXE_SAL
,      Z3
,      EFFECTIF_ENT
,      Z4
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM AP.JE_FR_DAS_310_NEW;

Dependencies

[top of page]

AP.JE_FR_DAS_310_NEW does not reference any database object

AP.JE_FR_DAS_310_NEW is referenced by following:

AP: JE_FR_DAS_310_NEW#