eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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