VIEW: APPS.OKX_SALES_CRED_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'