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: APPS.JE_ES_MODELO_347

Object Details

Object Name:	JE_ES_MODELO_347
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JE.JE_ES_MODELO_347
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Multi-Org Partitioning View for JE_ES_MODELO_347_ALL:
Used for temporary storage of information prior to running JEESAPOP.

[View Source]

Columns

Name	Datatype	Length	Mandatory
TIPO	VARCHAR2	(1)	Yes
IMPORTE	NUMBER		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)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
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 TIPO
,      IMPORTE
,      NOMBRE
,      NIF
,      SIGLA
,      MUNICIPIO
,      CODIGO_POSTAL
,      FIN_IND
,      VIA_PUBLICA
,      NUMERO
,      COMENTARIO
,      SET_OF_BOOKS_ID
,      ORG_ID
,      FLAG_ARRENDA
,      ESCALERA
,      PISO
,      PUERTA
,      REF_CATASTRAL
FROM APPS.JE_ES_MODELO_347;

Dependencies

[top of page]

APPS.JE_ES_MODELO_347 references the following:

APPS: JE_ES_MODELO_347_ALL

APPS.JE_ES_MODELO_347 is not referenced by any database object