VIEW: APPS.BIS_REQUEST_SET_OBJECTS_V

Source

View Text - Preformatted

SELECT decode(f.user_request_set_name, null, b.request_set_name||'(DELETED)',f.user_request_set_name) user_request_set_name , b.request_set_name, b.set_app_id, b.object_type, b.object_name, b.object_owner, a.application_name user_object_owner, bis_impl_dev_pkg.get_user_object_name(b.object_type,b.object_name) user_object_name,
b.last_update_date,b.created_by  from fnd_request_sets_vl f, bis_request_set_objects b, fnd_application_vl a WHERE f. request_set_name(+)= b.request_set_name and a.application_short_name(+)= b.object_owner and f.application_id = 191 and b.set_app_id = 191 and f.application_id = b.set_app_id

View Text - HTML Formatted

SELECT DECODE(F.USER_REQUEST_SET_NAME
, NULL
, B.REQUEST_SET_NAME||'(DELETED)'
, F.USER_REQUEST_SET_NAME) USER_REQUEST_SET_NAME
, B.REQUEST_SET_NAME
, B.SET_APP_ID
, B.OBJECT_TYPE
, B.OBJECT_NAME
, B.OBJECT_OWNER
, A.APPLICATION_NAME USER_OBJECT_OWNER
, BIS_IMPL_DEV_PKG.GET_USER_OBJECT_NAME(B.OBJECT_TYPE
, B.OBJECT_NAME) USER_OBJECT_NAME
, B.LAST_UPDATE_DATE
, B.CREATED_BY
FROM FND_REQUEST_SETS_VL F
, BIS_REQUEST_SET_OBJECTS B
, FND_APPLICATION_VL A
WHERE F. REQUEST_SET_NAME(+)= B.REQUEST_SET_NAME
AND A.APPLICATION_SHORT_NAME(+)= B.OBJECT_OWNER
AND F.APPLICATION_ID = 191
AND B.SET_APP_ID = 191
AND F.APPLICATION_ID = B.SET_APP_ID