[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_K_SALES_CREDITS_H

Object Details

Object Name:	OKC_K_SALES_CREDITS_H
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_K_SALES_CREDITS_H
Subobject Name:
Status:	VALID

This is a mirror image of base table OKC_K_SALES_CREDITS, please refer to the base table for detailed column level information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_K_SALES_CREDITS_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKC_K_SALES_CREDITS_H_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID CLE_ID
OKC_K_SALES_CREDITS_H_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALESREP_ID1 SALESREP_ID2

Columns

Query Text

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

SELECT ID
,      DNZ_CHR_ID
,      MAJOR_VERSION
,      PERCENT
,      CHR_ID
,      CLE_ID
,      SALESREP_ID1
,      SALESREP_ID2
,      SALES_CREDIT_TYPE_ID1
,      SALES_CREDIT_TYPE_ID2
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM OKC.OKC_K_SALES_CREDITS_H;

Dependencies

[top of page]

OKC.OKC_K_SALES_CREDITS_H does not reference any database object

OKC.OKC_K_SALES_CREDITS_H is referenced by following:

APPS

OKC_K_SALES_CREDITS_H