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.OKS_CONTRACT_UPD_DTLS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
CUSTOMER	VARCHAR2	(4000)
CHR_ID	NUMBER		Yes
CONTRACT_NUMBER	VARCHAR2	(241)
VERSION	VARCHAR2	(81)
KNOWN_AS	VARCHAR2	(300)
DESCRIPTION	VARCHAR2	(600)
PRICE_LIST	VARCHAR2	(240)
STATUS_CODE	VARCHAR2	(30)	Yes
STATUS_MEANING	VARCHAR2	(90)	Yes
START_DATE	DATE
END_DATE	DATE
FOLLOW_UP_DUE_DATE	DATE
FOLLOW_UP_ACTION	VARCHAR2	(30)
FOLLOWUP_ACTION_MEANING	VARCHAR2	(4000)
ESTIMATION_PERCENT	NUMBER
ESTIMATION_DATE	DATE
DURATION	VARCHAR2	(66)
SUBTOTAL	VARCHAR2	(4000)
TAX	VARCHAR2	(4000)
TOTAL_AMOUNT	VARCHAR2	(4000)
NEGOTIATION_STATUS	VARCHAR2	(80)
CATEGORY_MEANING	VARCHAR2	(90)	Yes
PRICE_AGREEMENT	VARCHAR2	(240)
CURRENCY	VARCHAR2	(15)
COMMENTS	VARCHAR2	(0)
NOTESTEXT	VARCHAR2	(0)
NEWSTATUSCODE	VARCHAR2	(0)
NEWREASONCODE	VARCHAR2	(0)
RENEWAL_COMMENT	VARCHAR2	(600)

Query Text

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


SELECT CUSTOMER
,      CHR_ID
,      CONTRACT_NUMBER
,      VERSION
,      KNOWN_AS
,      DESCRIPTION
,      PRICE_LIST
,      STATUS_CODE
,      STATUS_MEANING
,      START_DATE
,      END_DATE
,      FOLLOW_UP_DUE_DATE
,      FOLLOW_UP_ACTION
,      FOLLOWUP_ACTION_MEANING
,      ESTIMATION_PERCENT
,      ESTIMATION_DATE
,      DURATION
,      SUBTOTAL
,      TAX
,      TOTAL_AMOUNT
,      NEGOTIATION_STATUS
,      CATEGORY_MEANING
,      PRICE_AGREEMENT
,      CURRENCY
,      COMMENTS
,      NOTESTEXT
,      NEWSTATUSCODE
,      NEWREASONCODE
,      RENEWAL_COMMENT
FROM APPS.OKS_CONTRACT_UPD_DTLS_V;

Dependencies

[top of page]

APPS.OKS_CONTRACT_UPD_DTLS_V references the following:

APPS: FND_CURRENCIES_TL; HR_ALL_ORGANIZATION_UNITS_TL; MTL_UNITS_OF_MEASURE_TL; OE_AGREEMENTS_TL; OKC_GOVERNANCES; OKC_K_HEADERS_ALL_B; OKC_K_HEADERS_TL; OKC_K_VERS_NUMBERS; OKC_LOOKUPS_V; OKC_STATUSES_B; OKC_STATUSES_TL; OKC_SUBCLASSES_TL; OKC_UTIL - show dependent code; OKS_CUSTOMER_ACCEPTANCE_PVT - show dependent code; OKS_K_HEADERS_B; OKS_MISC_UTIL_WEB - show dependent code; QP_LIST_HEADERS_TL

APPS.OKS_CONTRACT_UPD_DTLS_V is not referenced by any database object