View: PA_PROGRESS_REPORT_SETUP_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROGRESS_REPORT_SETUP_V

View Text

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(+)

Columns