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

VIEW: APPS.JE_ES_MODELO_349

Object Details
Object Name: JE_ES_MODELO_349
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJE.JE_ES_MODELO_349
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.


JE_ES_MODELO_349 is a multi-org view that retrieves data for your current operating unit and ignores data in other operating units. The multi-org partitioning view for JE_ES_MODELO_349_ALL is used for temporary storage of information prior to running the Spanish Modelo 349 data extracts for Oracle Payables (JEESAPOP) and Oracle Receivables (JEESRRVC) concurrent programs.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
CLAVE_OPERACION VARCHAR2 (1) Yes
ORG_ID NUMBER (15)
NIF_COMUNITARIO VARCHAR2 (14)
NOMBRE VARCHAR2 (40)
BASE_IMPONIBLE NUMBER

OPERACION_TRIANGULAR VARCHAR2 (1)
EJERCICIO VARCHAR2 (2)
PERIODO VARCHAR2 (2)
FIN_IND VARCHAR2 (1) Yes
RUNNING_TOTAL NUMBER

FORMERLY_DECLARED_AMOUNT NUMBER

PRINT_PERIOD VARCHAR2 (2)
PRINT_YEAR VARCHAR2 (4)
PRINT_MODE VARCHAR2 (1)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      CLAVE_OPERACION
,      ORG_ID
,      NIF_COMUNITARIO
,      NOMBRE
,      BASE_IMPONIBLE
,      OPERACION_TRIANGULAR
,      EJERCICIO
,      PERIODO
,      FIN_IND
,      RUNNING_TOTAL
,      FORMERLY_DECLARED_AMOUNT
,      PRINT_PERIOD
,      PRINT_YEAR
,      PRINT_MODE
FROM APPS.JE_ES_MODELO_349;

Dependencies

[top of page]

APPS.JE_ES_MODELO_349 references the following:

SchemaAPPS
SynonymJE_ES_MODELO_349_ALL

APPS.JE_ES_MODELO_349 is not referenced by any database object