| index

View V_PROFILE_RT_CODE_FOR_ENRO

Columns

Name | Type | Optional | Default | Comments
PRTY_ID | NUMBER |  |  |
RT_CODE | VARCHAR2(80) |  |  |
START_DATE | DATE |  |  |
END_DATE | DATE | Y |  |
NEXT_START_DATE | DATE | Y |  |
ENQU_ID | NUMBER | Y |  |

SQL

    CREATE OR REPLACE VIEW V_PROFILE_RT_CODE_FOR_ENRO AS
    SELECT prty_id
          ,rt_code
          ,start_date
          ,end_date
          ,next_start_date
          ,enqu_id
      FROM (SELECT enro.prty_id
                  ,enro.rt_code
                  ,enro.start_date
                  ,enro.end_date
                  ,enqu_id
                  ,lead(start_date
                       ,1) over(PARTITION BY rt_code, enqu_id ORDER BY start_date) AS next_start_date
              FROM enquiry_roles enro);