[Home] [Help]
View: FND_SIF_DEFINITIONS_VL
View Text
SELECT B.ROWID ROW_ID
,
B.DEFINITION_NAME
,
T.DISPLAY_NAME
,
T.DESCRIPTION
,
B.APPLICATION_ID
,
B.ARTIFACTS_FILE_ID
,
B.STATUS
,
B.SERVICE
,
B.PORT
,
B.OPERATION
,
B.WSDL_TNS
,
B.INTERACTION_TYPE
,
B.ATTR1
,
B.ATTR2
,
B.ATTR3
,
B.ATTR4
,
B.ATTR5
,
B.CREATION_DATE
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
,
B.LAST_UPDATED_BY
,
B.CREATED_BY
FROM FND_SIF_DEFINITIONS B
,
FND_SIF_DEFINITIONS_TL T
WHERE B.DEFINITION_NAME = T.DEFINITION_NAME
AND T.LANGUAGE = USERENV('LANG')