View: JE_ES_MODELO_349

Product:	JE - European Localizations
Description:
Implementation/DBA Data:	APPS.JE_ES_MODELO_349

View Text

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 JE_ES_MODELO_349_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns