GMS_ACTIVE_FUNDING_PATTERN_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
DETERMINANT1 FP_EXISTS

Query

SQL_Statement
SELECT DISTINCT A.DETERMINANT1, DECODE(B.DETERMINANT1, null, 'N', 'Y') FP_EXISTS FROM PJC_DISTRIBUTE_PATTERNS_B A LEFT JOIN PJC_DISTRIBUTE_PATTERNS_B B ON A.DETERMINANT1 = B.DETERMINANT1 AND B.STATUS = 'ORA_GMS_FUND_PATTRN_STS_ACTIVE' AND B.BUSINESS_FUNCTION_CODE = 'AWD_DISTR' WHERE A.BUSINESS_FUNCTION_CODE = 'AWD_DISTR'