[Home] [Help]
View: OKX_SALES_CRED_TYPES_V
Product: | OKX - Contracts Integration |
Description: | Information about sales credit types |
Implementation/DBA Data: |
APPS.OKX_SALES_CRED_TYPES_V
|
View Text
SELECT SCT.SALES_CREDIT_TYPE_ID ID1
, '#' ID2
, SCT.NAME NAME
, SCT.DESCRIPTION DESCRIPTION
, DECODE(SCT.ENABLED_FLAG
, 'Y'
, 'A'
, 'I') STATUS
, SCT.QUOTA_FLAG QUOTA_FLAG
, SCT.ENABLED_FLAG
, SYSDATE START_DATE_ACTIVE
, DECODE(SCT.ENABLED_FLAG
, 'N'
, SYSDATE) END_DATE_ACTIVE
FROM OE_SALES_CREDIT_TYPES SCT
WHERE ENABLED_FLAG = 'Y'
Columns
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
STATUS |
QUOTA_FLAG |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |