Apex Views and Usage

apex_application_page_items

To find / get detailed information about the page items and their properties  by using apex_application_page_items apex view.

Example:  for example i need below column information

item_name,  page_name, region, region_id, item_default

SELECT
item_name,
page_name,
region,
region_id,
item_default
FROM
apex_application_page_items
WHERE
application_id = 1127
AND item_name LIKE ‘%DEPARTMENT_NAME%’
AND item_source_type != ‘Database Column’
ORDER BY
2

Execute above query and get exact result.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s