DBA Data[Home] [Help]

VIEW: APPS.OKC_OPERATIONS_V

Source

View Text - Preformatted

SELECT OPNB.rowid ROW_ID, OPNB.CODE CODE, OPNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OPNT.SFWT_FLAG SFWT_FLAG, OPNT.MEANING MEANING, OPNT.DESCRIPTION DESCRIPTION, OPNB.OPN_TYPE OPN_TYPE, OPNB.PURPOSE, OPNB.CREATED_BY CREATED_BY, OPNB.CREATION_DATE CREATION_DATE, OPNB.LAST_UPDATED_BY LAST_UPDATED_BY, OPNB.LAST_UPDATE_DATE LAST_UPDATE_DATE, OPNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_OPERATIONS_B OPNB,OKC_OPERATIONS_TL OPNT WHERE OPNB.CODE = OPNT.CODE and OPNT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT OPNB.ROWID ROW_ID
, OPNB.CODE CODE
, OPNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OPNT.SFWT_FLAG SFWT_FLAG
, OPNT.MEANING MEANING
, OPNT.DESCRIPTION DESCRIPTION
, OPNB.OPN_TYPE OPN_TYPE
, OPNB.PURPOSE
, OPNB.CREATED_BY CREATED_BY
, OPNB.CREATION_DATE CREATION_DATE
, OPNB.LAST_UPDATED_BY LAST_UPDATED_BY
, OPNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OPNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_OPERATIONS_B OPNB
, OKC_OPERATIONS_TL OPNT
WHERE OPNB.CODE = OPNT.CODE
AND OPNT.LANGUAGE = USERENV('LANG')