VIEW: APPS.CSM_PAGE_PERZ_DELTA_V

Source

View Text - Preformatted

SELECT acc.access_id, cpp.page_perz_id, cpp.file_name, cpp.page_name, cpp.uix_page_server_version, cpp.uix_page_client_version, cpp.message_name, acc.level_id, acc.level_value, acc.delta_file_name, acc.delta_FILE_TYPE, acc.FILE_DATA, acc.delta_server_version, acc.delta_client_version, cpp.CREATED_BY, cpp.CREATION_DATE, cpp.LAST_UPDATED_BY, cpp.LAST_UPDATE_DATE from CSM_PAGE_PERZ cpp, CSM_PAGE_PERZ_DELTA_ACC acc WHERE cpp.page_perz_id = acc.page_perz_id and acc.user_id = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CPP.PAGE_PERZ_ID
, CPP.FILE_NAME
, CPP.PAGE_NAME
, CPP.UIX_PAGE_SERVER_VERSION
, CPP.UIX_PAGE_CLIENT_VERSION
, CPP.MESSAGE_NAME
, ACC.LEVEL_ID
, ACC.LEVEL_VALUE
, ACC.DELTA_FILE_NAME
, ACC.DELTA_FILE_TYPE
, ACC.FILE_DATA
, ACC.DELTA_SERVER_VERSION
, ACC.DELTA_CLIENT_VERSION
, CPP.CREATED_BY
, CPP.CREATION_DATE
, CPP.LAST_UPDATED_BY
, CPP.LAST_UPDATE_DATE
FROM CSM_PAGE_PERZ CPP
, CSM_PAGE_PERZ_DELTA_ACC ACC
WHERE CPP.PAGE_PERZ_ID = ACC.PAGE_PERZ_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID