View: OKS_K_HEADERS_V

Product:	OKS - Service Contracts
Description:	Service Contracts Header Attributes
Implementation/DBA Data:	APPS.OKS_K_HEADERS_V

View Text

SELECT KHR.ROWID ROW_ID
, KHR.ID ID
, KHR.CHR_ID CHR_ID
, KHR.ACCT_RULE_ID ACCT_RULE_ID
, KHR.PAYMENT_TYPE PAYMENT_TYPE
, KHR.CC_NO CC_NO
, KHR.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KHR.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KHR.CC_AUTH_CODE CC_AUTH_CODE
, KHR.COMMITMENT_ID COMMITMENT_ID
, KHR.GRACE_DURATION GRACE_DURATION
, KHR.GRACE_PERIOD GRACE_PERIOD
, KHR.EST_REV_PERCENT EST_REV_PERCENT
, KHR.EST_REV_DATE EST_REV_DATE
, KHR.TAX_AMOUNT TAX_AMOUNT
, KHR.TAX_STATUS TAX_STATUS
, KHR.TAX_CODE TAX_CODE
, KHR.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KHR.BILLING_PROFILE_ID BILLING_PROFILE_ID
, KHR.RENEWAL_STATUS RENEWAL_STATUS
, KHR.ELECTRONIC_RENEWAL_FLAG ELECTRONIC_RENEWAL_FLAG
, KHR.QUOTE_TO_CONTACT_ID QUOTE_TO_CONTACT_ID
, KHR.QUOTE_TO_SITE_ID QUOTE_TO_SITE_ID
, KHR.QUOTE_TO_EMAIL_ID QUOTE_TO_EMAIL_ID
, KHR.QUOTE_TO_PHONE_ID QUOTE_TO_PHONE_ID
, KHR.QUOTE_TO_FAX_ID QUOTE_TO_FAX_ID
, KHR.RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED
, KHR.RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, KHR.RENEWAL_PRICE_LIST RENEWAL_PRICE_LIST
, KHR.RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE
, KHR.RENEWAL_MARKUP_PERCENT RENEWAL_MARKUP_PERCENT
, KHR.RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION
, KHR.RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD
, KHR.RENEWAL_EST_REV_PERCENT RENEWAL_EST_REV_PERCENT
, KHR.RENEWAL_EST_REV_DURATION RENEWAL_EST_REV_DURATION
, KHR.RENEWAL_EST_REV_PERIOD RENEWAL_EST_REV_PERIOD
, KHR.RENEWAL_PRICE_LIST_USED RENEWAL_PRICE_LIST_USED
, KHR.RENEWAL_TYPE_USED RENEWAL_TYPE_USED
, KHR.RENEWAL_NOTIFICATION_TO RENEWAL_NOTIFICATION_TO
, KHR.RENEWAL_PO_USED RENEWAL_PO_USED
, KHR.RENEWAL_PRICING_TYPE_USED RENEWAL_PRICING_TYPE_USED
, KHR.RENEWAL_MARKUP_PERCENT_USED RENEWAL_MARKUP_PERCENT_USED
, KHR.REV_EST_PERCENT_USED REV_EST_PERCENT_USED
, KHR.REV_EST_DURATION_USED REV_EST_DURATION_USED
, KHR.REV_EST_PERIOD_USED REV_EST_PERIOD_USED
, KHR.BILLING_PROFILE_USED BILLING_PROFILE_USED
, KHR.ERN_FLAG_USED_YN ERN_FLAG_USED_YN
, KHR.EVN_THRESHOLD_AMT EVN_THRESHOLD_AMT
, KHR.EVN_THRESHOLD_CUR EVN_THRESHOLD_CUR
, KHR.ERN_THRESHOLD_AMT ERN_THRESHOLD_AMT
, KHR.ERN_THRESHOLD_CUR ERN_THRESHOLD_CUR
, KHR.RENEWAL_GRACE_DURATION_USED RENEWAL_GRACE_DURATION_USED
, KHR.RENEWAL_GRACE_PERIOD_USED RENEWAL_GRACE_PERIOD_USED
, KHR.INV_TRX_TYPE INV_TRX_TYPE
, KHR.INV_PRINT_PROFILE INV_PRINT_PROFILE
, KHR.AR_INTERFACE_YN AR_INTERFACE_YN
, KHR.HOLD_BILLING HOLD_BILLING
, KHR.SUMMARY_TRX_YN SUMMARY_TRX_YN
, KHR.SERVICE_PO_NUMBER SERVICE_PO_NUMBER
, KHR.SERVICE_PO_REQUIRED SERVICE_PO_REQUIRED
, KHR.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, KHR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KHR.SECURITY_GROUP_ID SECURITY_GROUP_ID
, KHR.REQUEST_ID REQUEST_ID
, KHR.CREATED_BY CREATED_BY
, KHR.CREATION_DATE CREATION_DATE
, KHR.LAST_UPDATED_BY LAST_UPDATED_BY
, KHR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KHR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_K_HEADERS_B KHR

Columns