View: JG_ZZ_SYS_FORMATS_VL

View Text

SELECT B.ROWID
, B.JGZZ_COUNTRY_CODE
, B.JGZZ_EFT_TYPE
, T.JGZZ_DESCRIPTION
, B.JGZZ_ATTRIBUTE_CATEGORY
, B.JGZZ_SYSTEM_INFO1
, B.JGZZ_SYSTEM_INFO2
, B.JGZZ_SYSTEM_INFO3
, B.JGZZ_SYSTEM_INFO4
, B.JGZZ_SYSTEM_INFO5
, B.JGZZ_SYSTEM_INFO6
, B.JGZZ_SYSTEM_INFO7
, B.JGZZ_SYSTEM_INFO8
, B.JGZZ_SYSTEM_INFO9
, B.JGZZ_SYSTEM_INFO10
, B.JGZZ_SYSTEM_INFO11
, B.JGZZ_SYSTEM_INFO12
, B.JGZZ_SYSTEM_INFO13
, B.JGZZ_SYSTEM_INFO14
, B.JGZZ_SYSTEM_INFO15
, B.JGZZ_SYSTEM_INFO16
, B.JGZZ_SYSTEM_INFO17
, B.JGZZ_SYSTEM_INFO18
, B.JGZZ_SYSTEM_INFO19
, B.JGZZ_SYSTEM_INFO20
, B.JGZZ_SYSTEM_INFO21
, B.JGZZ_SYSTEM_INFO22
, B.JGZZ_SYSTEM_INFO23
, B.JGZZ_SYSTEM_INFO24
, B.JGZZ_SYSTEM_INFO25
, B.JGZZ_SYSTEM_INFO26
, B.JGZZ_SYSTEM_INFO27
, B.JGZZ_SYSTEM_INFO28
, B.JGZZ_SYSTEM_INFO29
, B.JGZZ_SYSTEM_INFO30
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.ORG_ID
FROM JG_ZZ_SYS_FORMATS_ALL_TL T
, JG_ZZ_SYS_FORMATS_ALL_B B
WHERE B.JGZZ_COUNTRY_CODE = T.JGZZ_COUNTRY_CODE
AND B.JGZZ_EFT_TYPE = T.JGZZ_EFT_TYPE
AND NVL(B.ORG_ID
, -99) = NVL(T.ORG_ID
, -99)
AND T.LANGUAGE = USERENV('LANG')
AND NVL(B.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