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. Continue reading Apex Views and Usage