DBA Data[Home] [Help]

VIEW: APPS.IBY_BANK_INSTRUCTIONS_VL

Source

View Text - Preformatted

SELECT B.BANK_INSTRUCTION_CODE,B.FORMAT_VALUE,B.INACTIVE_DATE,B.TERRITORY_CODE,B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,B.OBJECT_VERSION_NUMBER,T.MEANING,T.DESCRIPTION,B.SEEDED_FLAG FROM IBY_BANK_INSTRUCTIONS_TL T,IBY_BANK_INSTRUCTIONS_B B WHERE B.BANK_INSTRUCTION_CODE = T.BANK_INSTRUCTION_CODE AND T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.BANK_INSTRUCTION_CODE
, B.FORMAT_VALUE
, B.INACTIVE_DATE
, B.TERRITORY_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, T.MEANING
, T.DESCRIPTION
, B.SEEDED_FLAG
FROM IBY_BANK_INSTRUCTIONS_TL T
, IBY_BANK_INSTRUCTIONS_B B
WHERE B.BANK_INSTRUCTION_CODE = T.BANK_INSTRUCTION_CODE
AND T.LANGUAGE = USERENV('LANG')