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

VIEW: OKS.OKS_K_SALES_CREDITS#

Object Details
Object Name: OKS_K_SALES_CREDITS#
Object Type: VIEW
Owner: OKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
PERCENT NUMBER
Yes
CHR_ID NUMBER
Yes
CLE_ID NUMBER

CTC_ID NUMBER
Yes
SALES_CREDIT_TYPE_ID1 VARCHAR2 (40) Yes
SALES_CREDIT_TYPE_ID2 VARCHAR2 (40) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
SECURITY_GROUP_ID NUMBER

SALES_GROUP_ID NUMBER

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# references the following:

SchemaOKS
TableOKS_K_SALES_CREDITS
OKS.OKS_K_SALES_CREDITS# is referenced by following:

SchemaAPPS
SynonymOKS_K_SALES_CREDITS