APPS.OKS_K_HEADERS_HV
[Home] [Help]
| Product: | OKS - Service Contracts |
|---|---|
| Description: | Service Contracts Header Attributes History |
| Implementation/DBA Data: |
APPS.OKS_K_HEADERS_HV
|
SELECT KHH.ROWID ROW_ID
, KHH.ID ID
, KHH.MAJOR_VERSION MAJOR_VERSION
, KHH.CHR_ID CHR_ID
, KHH.ACCT_RULE_ID ACCT_RULE_ID
, KHH.PAYMENT_TYPE PAYMENT_TYPE
, KHH.CC_NO CC_NO
, KHH.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KHH.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KHH.CC_AUTH_CODE CC_AUTH_CODE
, KHH.COMMITMENT_ID COMMITMENT_ID
, KHH.GRACE_DURATION GRACE_DURATION
, KHH.GRACE_PERIOD GRACE_PERIOD
, KHH.EST_REV_PERCENT EST_REV_PERCENT
, KHH.EST_REV_DATE EST_REV_DATE
, KHH.TAX_AMOUNT TAX_AMOUNT
, KHH.TAX_STATUS TAX_STATUS
, KHH.TAX_CODE TAX_CODE
, KHH.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KHH.BILLING_PROFILE_ID BILLING_PROFILE_ID
, KHH.RENEWAL_STATUS RENEWAL_STATUS
, KHH.ELECTRONIC_RENEWAL_FLAG ELECTRONIC_RENEWAL_FLAG
, KHH.QUOTE_TO_CONTACT_ID QUOTE_TO_CONTACT_ID
, KHH.QUOTE_TO_SITE_ID QUOTE_TO_SITE_ID
, KHH.QUOTE_TO_EMAIL_ID QUOTE_TO_EMAIL_ID
, KHH.QUOTE_TO_PHONE_ID QUOTE_TO_PHONE_ID
, KHH.QUOTE_TO_FAX_ID QUOTE_TO_FAX_ID
, KHH.RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED
, KHH.RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, KHH.RENEWAL_PRICE_LIST RENEWAL_PRICE_LIST
, KHH.RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE
, KHH.RENEWAL_MARKUP_PERCENT RENEWAL_MARKUP_PERCENT
, KHH.RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION
, KHH.RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD
, KHH.RENEWAL_EST_REV_PERCENT RENEWAL_EST_REV_PERCENT
, KHH.RENEWAL_EST_REV_DURATION RENEWAL_EST_REV_DURATION
, KHH.RENEWAL_EST_REV_PERIOD RENEWAL_EST_REV_PERIOD
, KHH.RENEWAL_PRICE_LIST_USED RENEWAL_PRICE_LIST_USED
, KHH.RENEWAL_TYPE_USED RENEWAL_TYPE_USED
, KHH.RENEWAL_NOTIFICATION_TO RENEWAL_NOTIFICATION_TO
, KHH.RENEWAL_PO_USED RENEWAL_PO_USED
, KHH.RENEWAL_PRICING_TYPE_USED RENEWAL_PRICING_TYPE_USED
, KHH.RENEWAL_MARKUP_PERCENT_USED RENEWAL_MARKUP_PERCENT_USED
, KHH.REV_EST_PERCENT_USED REV_EST_PERCENT_USED
, KHH.REV_EST_DURATION_USED REV_EST_DURATION_USED
, KHH.REV_EST_PERIOD_USED REV_EST_PERIOD_USED
, KHH.BILLING_PROFILE_USED BILLING_PROFILE_USED
, KHH.ERN_FLAG_USED_YN ERN_FLAG_USED_YN
, KHH.EVN_THRESHOLD_AMT EVN_THRESHOLD_AMT
, KHH.EVN_THRESHOLD_CUR EVN_THRESHOLD_CUR
, KHH.ERN_THRESHOLD_AMT ERN_THRESHOLD_AMT
, KHH.ERN_THRESHOLD_CUR ERN_THRESHOLD_CUR
, KHH.RENEWAL_GRACE_DURATION_USED RENEWAL_GRACE_DURATION_USED
, KHH.RENEWAL_GRACE_PERIOD_USED RENEWAL_GRACE_PERIOD_USED
, KHH.INV_PRINT_PROFILE INV_PRINT_PROFILE
, KHH.INV_TRX_TYPE INV_TRX_TYPE
, KHH.AR_INTERFACE_YN AR_INTERFACE_YN
, KHH.HOLD_BILLING HOLD_BILLING
, KHH.SUMMARY_TRX_YN SUMMARY_TRX_YN
, KHH.SERVICE_PO_NUMBER SERVICE_PO_NUMBER
, KHH.SERVICE_PO_REQUIRED SERVICE_PO_REQUIRED
, KHH.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, KHH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KHH.SECURITY_GROUP_ID SECURITY_GROUP_ID
, KHH.REQUEST_ID REQUEST_ID
, KHH.CREATED_BY CREATED_BY
, KHH.CREATION_DATE CREATION_DATE
, KHH.LAST_UPDATED_BY LAST_UPDATED_BY
, KHH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KHH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_K_HEADERS_BH KHH