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]

VIEW: JE.JE_ES_MODELO_347_ALL#

Object Details

Object Name:	JE_ES_MODELO_347_ALL#
Object Type:	VIEW
Owner:	JE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
IMPORTE	NUMBER		Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
TIPO	VARCHAR2	(1)	Yes
NOMBRE	VARCHAR2	(60)
NIF	VARCHAR2	(9)
SIGLA	VARCHAR2	(4)
MUNICIPIO	VARCHAR2	(50)
CODIGO_POSTAL	VARCHAR2	(5)
FIN_IND	VARCHAR2	(1)
VIA_PUBLICA	VARCHAR2	(50)
NUMERO	NUMBER	(5)
COMENTARIO	VARCHAR2	(130)
FLAG_ARRENDA	VARCHAR2	(1)
ESCALERA	VARCHAR2	(2)
PISO	VARCHAR2	(2)
PUERTA	VARCHAR2	(2)
REF_CATASTRAL	VARCHAR2	(25)

Query Text

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


SELECT IMPORTE
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TIPO
,      NOMBRE
,      NIF
,      SIGLA
,      MUNICIPIO
,      CODIGO_POSTAL
,      FIN_IND
,      VIA_PUBLICA
,      NUMERO
,      COMENTARIO
,      FLAG_ARRENDA
,      ESCALERA
,      PISO
,      PUERTA
,      REF_CATASTRAL
FROM JE.JE_ES_MODELO_347_ALL#;

Dependencies

[top of page]

JE.JE_ES_MODELO_347_ALL# references the following:

JE: JE_ES_MODELO_347_ALL

JE.JE_ES_MODELO_347_ALL# is referenced by following:

APPS: JE_ES_MODELO_347_ALL