[Home] [Help]
View: OKX_LIST_HEADERS_V
Product: | OKX - Contracts Integration |
Description: | Header information for all types of lists |
Implementation/DBA Data: |
APPS.OKX_LIST_HEADERS_V
|
View Text
SELECT B.LIST_HEADER_ID ID1
, '#' ID2
, B.LIST_TYPE_CODE LIST_TYPE_CODE
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.AUTOMATIC_FLAG AUTOMATIC_FLAG
, B.CURRENCY_CODE CURRENCY_CODE
, B.DISCOUNT_LINES_FLAG DISCOUNT_LINES_FLAG
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.ACTIVE_FLAG B_STATUS
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
FROM QP_LIST_HEADERS_B B
, QP_LIST_HEADERS_TL T
WHERE B.LIST_HEADER_ID = T.LIST_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ID1 |
ID2 |
LIST_TYPE_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
AUTOMATIC_FLAG |
CURRENCY_CODE |
DISCOUNT_LINES_FLAG |
NAME |
DESCRIPTION |
B_STATUS |
STATUS |