[Home] [Help]
View: OKX_SPECS_V
Product: | OKX - Contracts Integration |
Description: | Quality specifications |
Implementation/DBA Data: |
APPS.OKX_SPECS_V
|
View Text
SELECT S.SPEC_ID ID1
, '#' ID2
, S.ORGANIZATION_ID ORGANIZATION_ID
, S.SPEC_NAME NAME
, S.EFFECTIVE_FROM START_DATE_ACTIVE
, S.EFFECTIVE_TO END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(S.EFFECTIVE_FROM
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(S.EFFECTIVE_TO
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, S.SPEC_ELEMENT_VALUE DESCRIPTION
FROM QA_SPECS S
Columns
Name |
ID1 |
ID2 |
ORGANIZATION_ID |
NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
DESCRIPTION |