PJF_PROJECT_OPP_ATTRS_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PROJECT_ID OBJECT_VERSION_NUMBER OPPORTUNITY_VALUE OPP_VALUE_CURRENCY_CODE PROJFUNC_OPP_VALUE PROJFUNC_OPP_RATE_TYPE PROJFUNC_OPP_RATE_DATE PROJECT_OPP_VALUE PROJECT_OPP_RATE_TYPE PROJECT_OPP_RATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PPOA.PROJECT_ID, PPOA.OBJECT_VERSION_NUMBER, PPOA.OPPORTUNITY_VALUE, PPOA.OPP_VALUE_CURRENCY_CODE, PPOA.PROJFUNC_OPP_VALUE, PPOA.PROJFUNC_OPP_RATE_TYPE, PPOA.PROJFUNC_OPP_RATE_DATE, PPOA.PROJECT_OPP_VALUE, PPOA.PROJECT_OPP_RATE_TYPE, PPOA.PROJECT_OPP_RATE_DATE, PPOA.CREATION_DATE, PPOA.CREATED_BY, PPOA.LAST_UPDATE_DATE, PPOA.LAST_UPDATED_BY, PPOA.LAST_UPDATE_LOGIN FROM PJF_PROJECT_OPP_ATTRS PPOA