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_K_ORDER_DETAILS_V

Object Details

Object Name:	OKS_K_ORDER_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_K_ORDER_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		row id
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers
COD_ID	NUMBER			Surrogate key used for primary unique identifiers
APPLY_ALL_YN	VARCHAR2	(3)	Yes	Yes or No
LINE_RENEWAL_TYPE	VARCHAR2	(3)	Yes	line renewal type
RENEWAL_TYPE	VARCHAR2	(3)		renewal type
PO_REQUIRED_YN	VARCHAR2	(3)		Yes or No
RENEWAL_PRICING_TYPE	VARCHAR2	(3)		renewal pricing type
MARKUP_PERCENT	NUMBER			percent markup
LINK_ORDER_HEADER_ID	NUMBER			order header
END_DATE	DATE			service end date
COD_TYPE	VARCHAR2	(3)	Yes	cod type
ORDER_LINE_ID1	VARCHAR2	(40)	Yes	order line id
ORDER_LINE_ID2	VARCHAR2	(40)	Yes	order line id2
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.
LINK_ORD_LINE_ID1	VARCHAR2	(40)		link to order line id
LINK_ORD_LINE_ID2	VARCHAR2	(40)		link to order line id2
LINK_CHR_ID	NUMBER			link to k hdr
LINK_CLE_ID	NUMBER			link to k line
PRICE_LIST_ID1	VARCHAR2	(40)		price list
PRICE_LIST_ID2	VARCHAR2	(40)		price list
CHR_ID	NUMBER			Unique Identifier for Contract Header
CLE_ID	NUMBER			Unique Identifier for Contract Line.
CONTACT_ID	NUMBER			Customer COntact Id
SITE_ID	NUMBER			Contact Address Id
EMAIL_ID	NUMBER			Contact Email Id
PHONE_ID	NUMBER			Contact Phone Id
FAX_ID	NUMBER			Contact Fax Id
BILLING_PROFILE_ID	NUMBER
RENEWAL_APPROVAL_FLAG	VARCHAR2	(30)

Query Text

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


SELECT ROW_ID
,      ID
,      COD_ID
,      APPLY_ALL_YN
,      LINE_RENEWAL_TYPE
,      RENEWAL_TYPE
,      PO_REQUIRED_YN
,      RENEWAL_PRICING_TYPE
,      MARKUP_PERCENT
,      LINK_ORDER_HEADER_ID
,      END_DATE
,      COD_TYPE
,      ORDER_LINE_ID1
,      ORDER_LINE_ID2
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LINK_ORD_LINE_ID1
,      LINK_ORD_LINE_ID2
,      LINK_CHR_ID
,      LINK_CLE_ID
,      PRICE_LIST_ID1
,      PRICE_LIST_ID2
,      CHR_ID
,      CLE_ID
,      CONTACT_ID
,      SITE_ID
,      EMAIL_ID
,      PHONE_ID
,      FAX_ID
,      BILLING_PROFILE_ID
,      RENEWAL_APPROVAL_FLAG
FROM APPS.OKS_K_ORDER_DETAILS_V;

Dependencies

[top of page]

APPS.OKS_K_ORDER_DETAILS_V references the following:

APPS: OKS_K_ORDER_DETAILS

APPS.OKS_K_ORDER_DETAILS_V is referenced by following:

APPS: OKS_COC_PVT - show dependent code; OKS_COD_PVT - show dependent code; OKS_COD_PVT - show dependent code; OKS_COVERAGES_PVT - show dependent code; OKS_EXTWAR_UTIL_PVT - show dependent code; OKS_IBINT_PUB - show dependent code; OKS_K_DETAIL_V; OKS_OCINT_PUB - show dependent code