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, 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

View Text - HTML Formatted

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