FND Design Data [Home] [Help]

View: OKS_K_ORDER_DETAILS_V

Product: OKS - Service Contracts
Description: view for Contract details
Implementation/DBA Data: ViewAPPS.OKS_K_ORDER_DETAILS_V
View Text

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

Columns

Name
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