VIEW: APPS.PA_PROGRESS_REPORT_SETUP_V

Source

View Text - Preformatted

SELECT opl.object_page_layout_id, opl.object_id, opl.object_type, prt.report_type_id, prt.name, prt.override_page_layout, opl.effective_from, opl.effective_to, ppl.page_id, ppl.page_name, opl.page_type_code, opl.approval_required, plk.description approval_description, opl.approver_source_id, opl.approver_source_type, pa_resource_utils.get_res_name_from_type(opl.approver_source_type,opl.approver_source_id), opl.reporting_cycle_id, opl.report_offset_days, opl.next_reporting_date, pbc.billing_cycle_id, pbc.billing_cycle_name, opl.reminder_days, opl.reminder_days_type, opl.record_version_number, pa_action_set_utils.get_action_set_id('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',opl.object_page_layout_id) action_set_id, prt.generation_method from pa_report_types prt,pa_page_layouts ppl, pa_lookups plk, pa_object_page_layouts opl, pa_billing_cycles pbc WHERE opl.report_type_id = prt.report_type_id and ppl.page_id = opl.page_id and plk.lookup_type = 'PA_PROGRESS_APPRVL_TYPE' and opl.approval_required = plk.lookup_code and opl.reporting_cycle_id = pbc.billing_cycle_id(+)

View Text - HTML Formatted

SELECT OPL.OBJECT_PAGE_LAYOUT_ID
, OPL.OBJECT_ID
, OPL.OBJECT_TYPE
, PRT.REPORT_TYPE_ID
, PRT.NAME
, PRT.OVERRIDE_PAGE_LAYOUT
, OPL.EFFECTIVE_FROM
, OPL.EFFECTIVE_TO
, PPL.PAGE_ID
, PPL.PAGE_NAME
, OPL.PAGE_TYPE_CODE
, OPL.APPROVAL_REQUIRED
, PLK.DESCRIPTION APPROVAL_DESCRIPTION
, OPL.APPROVER_SOURCE_ID
, OPL.APPROVER_SOURCE_TYPE
, PA_RESOURCE_UTILS.GET_RES_NAME_FROM_TYPE(OPL.APPROVER_SOURCE_TYPE
, OPL.APPROVER_SOURCE_ID)
, OPL.REPORTING_CYCLE_ID
, OPL.REPORT_OFFSET_DAYS
, OPL.NEXT_REPORTING_DATE
, PBC.BILLING_CYCLE_ID
, PBC.BILLING_CYCLE_NAME
, OPL.REMINDER_DAYS
, OPL.REMINDER_DAYS_TYPE
, OPL.RECORD_VERSION_NUMBER
, PA_ACTION_SET_UTILS.GET_ACTION_SET_ID('PA_PROJ_STATUS_REPORT'
, 'PA_PROJ_STATUS_REPORTS'
, OPL.OBJECT_PAGE_LAYOUT_ID) ACTION_SET_ID
, PRT.GENERATION_METHOD
FROM PA_REPORT_TYPES PRT
, PA_PAGE_LAYOUTS PPL
, PA_LOOKUPS PLK
, PA_OBJECT_PAGE_LAYOUTS OPL
, PA_BILLING_CYCLES PBC
WHERE OPL.REPORT_TYPE_ID = PRT.REPORT_TYPE_ID
AND PPL.PAGE_ID = OPL.PAGE_ID
AND PLK.LOOKUP_TYPE = 'PA_PROGRESS_APPRVL_TYPE'
AND OPL.APPROVAL_REQUIRED = PLK.LOOKUP_CODE
AND OPL.REPORTING_CYCLE_ID = PBC.BILLING_CYCLE_ID(+)