[Home] [Help]
View: OKS_RESOURCE_GROUPS_V
Product: | OKS - Service Contracts |
Description: | View for Resource Groups for Service Contracts Coverages |
Implementation/DBA Data: |
APPS.OKS_RESOURCE_GROUPS_V
|
View Text
SELECT RSC.GROUP_ID ID1
, '#' ID2
, RSC.GROUP_NUMBER RESOURCE_NUMBER
, 'RS_GROUP' RESOURCE_TYPE
, RSC.GROUP_NAME NAME
, RSC.GROUP_DESC DESCRIPTION
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(RSC.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(RSC.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, RSC.EMAIL_ADDRESS
FROM JTF_RS_GROUPS_VL RSC
Columns
Name |
ID1 |
ID2 |
RESOURCE_NUMBER |
RESOURCE_TYPE |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
EMAIL_ADDRESS |