FND Design Data [Home] [Help]

View: PA_TM_PAGE_LAYOUTS_V

Product: PA - Projects
Description: This view is created as this will be used as the database_object_name in fnd_objects table for seeding an object of type TEAM_MEMBER_HOME. The view is a select of all the columns of pa_page_layouts table, selecting page layouts correspondin
Implementation/DBA Data: ViewAPPS.PA_TM_PAGE_LAYOUTS_V
View Text

SELECT PAGE_ID
, PAGE_NAME
, PAGE_TYPE_CODE
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, RECORD_VERSION_NUMBER
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SHORTCUT_MENU_ID
, PERS_FUNCTION_NAME FROM PA_PAGE_LAYOUTS
WHERE PAGE_TYPE_CODE = 'TM'

Columns

Name
PAGE_ID
PAGE_NAME
PAGE_TYPE_CODE
DESCRIPTION
START_DATE_ACTIVE
END_DATE_ACTIVE
RECORD_VERSION_NUMBER
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SHORTCUT_MENU_ID
PERS_FUNCTION_NAME