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.

VIEW: OKS.OKS_K_ORDER_DETAILS#

Source

View Text - Preformatted


select ID ID, COD_TYPE COD_TYPE, LINK_ORDER_HEADER_ID LINK_ORDER_HEADER_ID, ORDER_LINE_ID1 ORDER_LINE_ID1, ORDER_LINE_ID2 ORDER_LINE_ID2, APPLY_ALL_YN APPLY_ALL_YN, RENEWAL_TYPE RENEWAL_TYPE, LINE_RENEWAL_TYPE LINE_RENEWAL_TYPE, END_DATE END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, PO_REQUIRED_YN PO_REQUIRED_YN, RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE, MARKUP_PERCENT MARKUP_PERCENT, PRICE_LIST_ID1 PRICE_LIST_ID1, PRICE_LIST_ID2 PRICE_LIST_ID2, LINK_ORD_LINE_ID1 LINK_ORD_LINE_ID1, LINK_ORD_LINE_ID2 LINK_ORD_LINE_ID2, LINK_CHR_ID LINK_CHR_ID, LINK_CLE_ID LINK_CLE_ID, CHR_ID CHR_ID, CLE_ID CLE_ID, COD_ID COD_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CONTACT_ID CONTACT_ID, SITE_ID SITE_ID, EMAIL_ID EMAIL_ID, PHONE_ID PHONE_ID, FAX_ID FAX_ID, BILLING_PROFILE_ID BILLING_PROFILE_ID, RENEWAL_APPROVAL_FLAG RENEWAL_APPROVAL_FLAG from "OKS"."OKS_K_ORDER_DETAILS"

View Text - HTML Formatted

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