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: APPS.OKS_K_ORDER_DETAILS_V

Source

View Text - Preformatted


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, RENEWAL_APPROVAL_FLAG FROM OKS_K_ORDER_DETAILS COD

View Text - HTML Formatted

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
, RENEWAL_APPROVAL_FLAG
FROM OKS_K_ORDER_DETAILS COD