VIEW: APPS.PA_CI_TYPES_W_FINPLAN_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')