View: PA_CI_TYPES_W_FINPLAN_V

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

View Text

SELECT CT.CI_TYPE_ID
, CT.CI_TYPE_CLASS_CODE
, CT.NAME
, CT.SHORT_NAME
, CT.DESCRIPTION
, MAX(DECODE(IU.IMPACT_TYPE_CODE
, 'FINPLAN_COST'
, 'Y'
, 'FINPLAN_REVENUE'
, 'N'
, 'N'))
, MAX(DECODE(IU.IMPACT_TYPE_CODE
, 'FINPLAN_REVENUE'
, 'Y'
, 'FINPLAN_COST'
, 'N'
, 'N'))
FROM PA_CI_TYPES_V CT
, PA_CI_IMPACT_TYPE_USAGE IU
WHERE SYSDATE BETWEEN CT.START_DATE_ACTIVE
AND NVL(CT.END_DATE_ACTIVE
, SYSDATE)
AND CT.CI_TYPE_ID = IU.CI_TYPE_ID
AND IU.IMPACT_TYPE_CODE IN ('FINPLAN_COST'
, 'FINPLAN_REVENUE') GROUP BY CT.CI_TYPE_ID
, CT.CI_TYPE_CLASS_CODE
, CT.NAME
, CT.SHORT_NAME
, CT.DESCRIPTION

Columns