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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKS.OKS_K_SALES_CREDITS

Object Details

Object Name:	OKS_K_SALES_CREDITS
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_K_SALES_CREDITS
Subobject Name:
Status:	VALID

This stores the sales credit information associated with the contract header or contract lines. The sales credit can be of Revenue or non-Revenue type. The percentages of the revenue sales credit must sum up to 100. Records are created through Sales Credit form. 'Service Contracts Main Billing' concurrent program reads the sales credit information from this table and populates RA_INTERFACE_SALESCREDITS_ALL table through feeder program OKS_ARFEEDER_PUB.INSERT_RA_INTERFACE. The 'Allow Sales Credit' parameter in transaction batch source will determine whether user must enter sales credit information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_K_SALES_CREDITS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_K_SALES_CREDITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID CLE_ID
OKS_K_SALES_CREDITS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CTC_ID
OKS_K_SALES_CREDITS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers
PERCENT	NUMBER		Yes	The percentage of the sales credit the sales rep is to receive.
CHR_ID	NUMBER		Yes	Contract header id. References OKC_K_HEADERS_B.ID
CLE_ID	NUMBER			Contract line id. References OKC_K_LINES_B.ID
CTC_ID	NUMBER		Yes	Stores the sales person id. References JTF_RS_SALESREPS.ID1.
SALES_CREDIT_TYPE_ID1	VARCHAR2	(40)	Yes	Stores sales credit type id. References OE_SALES_CREDIT_TYPES. SALES_CREDIT_TYPE_ID
SALES_CREDIT_TYPE_ID2	VARCHAR2	(40)	Yes	Not used.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
SALES_GROUP_ID	NUMBER			Sales group id to which the sales person is associated. References JTF_RS_GROUPS_B. GROUP_ID.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      PERCENT
,      CHR_ID
,      CLE_ID
,      CTC_ID
,      SALES_CREDIT_TYPE_ID1
,      SALES_CREDIT_TYPE_ID2
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      SALES_GROUP_ID
FROM OKS.OKS_K_SALES_CREDITS;

Dependencies

[top of page]

OKS.OKS_K_SALES_CREDITS does not reference any database object

OKS.OKS_K_SALES_CREDITS is referenced by following:

APPS: OKS_K_SALES_CREDITS