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]

VIEW: APPS.OKI_HCREDIT_DTL_V

Object Details

Object Name:	OKI_HCREDIT_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view contains sales credit information for Contract Headers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHR_ID	NUMBER		Yes	Contract Header Internal Identifier. Used as a join column
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number of the Contract Header
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier , user wants to add
COMPLETE_K_NUMBER	VARCHAR2	(241)		Complete contract number, formed by concatenating contract number and contract number modifier
RESOURCE_ID	NUMBER			Resource unique identification number
CREDIT_TYPE	VARCHAR2	(240)		User given name for sales credit type. Pulled from Order entry table OE_SALES_CREDIT_TYPES
SALES_CREDIT_PERCENT	NUMBER			The percentage of the sales credit the sales rep is to receive. Pulled from Contracts Service
RESOURCE_GROUP_ID	NUMBER			Sales group unique identifier

Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      RESOURCE_ID
,      CREDIT_TYPE
,      SALES_CREDIT_PERCENT
,      RESOURCE_GROUP_ID
FROM APPS.OKI_HCREDIT_DTL_V;

Dependencies

[top of page]

APPS.OKI_HCREDIT_DTL_V references the following:

APPS: BIS_COMMON_PARAMETERS - show dependent code; JTF_RS_SALESREPS; OE_SALES_CREDIT_TYPES; OKC_UTIL - show dependent code; OKI_SRM_006_V; OKS_K_SALES_CREDITS

APPS.OKI_HCREDIT_DTL_V is not referenced by any database object