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
, ( CASE WHEN CT.COST_COL_FLAG = 'Y' THEN 'Y' WHEN CT.SUPP_COST_REG_FLAG = 'Y' THEN 'Y' WHEN CT.DIR_COST_REG_FLAG = 'Y' THEN 'Y' ELSE 'N' END ) COST_IMPACT_FLAG
, ( CASE WHEN CT.REV_COL_FLAG = 'Y' THEN 'Y' WHEN CT.DIR_REG_REV_COL_FLAG = 'Y' THEN 'Y' ELSE 'N' END ) REVENUE_IMPACT_FLAG
FROM PA_CI_TYPES_V CT
WHERE SYSDATE BETWEEN CT.START_DATE_ACTIVE
AND NVL(CT.END_DATE_ACTIVE
, SYSDATE)
AND CT.IMPACT_BUDGET_TYPE_CODE IN ('EDIT_PLANNED_AMOUNTS'
, 'DIRECT_COST_ENTRY')

Columns