DBA Data[Home] [Help]

VIEW: APPS.FRM_DELIVERY_OPTIONS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID,
B.DELIVERY_ID,
B.CONFIGURATION_ID,
B.DELIVERY_TYPE,
B.START_DATE,
B.END_DATE,
B.OBJECT_VERSION_NUMBER,
T.USER_NAME,
B.CREATED_BY, 
B.CREATION_DATE, 
B.LAST_UPDATED_BY, 
B.LAST_UPDATE_LOGIN, 
B.LAST_UPDATE_DATE
FROM FRM_DELIVERY_OPTIONS_B B,
FRM_DELIVERY_OPTIONS_TL T
WHERE 
B.DELIVERY_ID = T.DELIVERY_ID 
AND T.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.DELIVERY_ID
, B.CONFIGURATION_ID
, B.DELIVERY_TYPE
, B.START_DATE
, B.END_DATE
, B.OBJECT_VERSION_NUMBER
, T.USER_NAME
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE FROM FRM_DELIVERY_OPTIONS_B B
, FRM_DELIVERY_OPTIONS_TL T WHERE B.DELIVERY_ID = T.DELIVERY_ID AND T.LANGUAGE=USERENV('LANG')