VIEW: APPS.OKS_K_HEADERS_HV

Source

View Text - Preformatted

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 ,KHH.PERIOD_TYPE PERIOD_TYPE ,KHH.PERIOD_START PERIOD_START ,KHH.PRICE_UOM PRICE_UOM ,KHH.FOLLOW_UP_ACTION FOLLOW_UP_ACTION ,KHH.FOLLOW_UP_DATE FOLLOW_UP_DATE ,KHH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID ,KHH.DATE_ACCEPTED DATE_ACCEPTED ,KHH.ACCEPTED_BY ACCEPTED_BY ,KHH.RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG ,KHH.RMNDR_SENT_FLAG RMNDR_SENT_FLAG ,KHH.QUOTE_SENT_FLAG QUOTE_SENT_FLAG ,KHH.PROCESS_REQUEST_ID PROCESS_REQUEST_ID ,KHH.WF_ITEM_KEY WF_ITEM_KEY ,KHH.PERSON_PARTY_ID PERSON_PARTY_ID ,KHH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE ,KHH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER ,KHH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE ,KHH.APPROVAL_TYPE_USED APPROVAL_TYPE_USED ,KHH.RENEWAL_COMMENT RENEWAL_COMMENT ,KHH.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS FROM OKS_K_HEADERS_BH KHH

View Text - HTML Formatted

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
, KHH.PERIOD_TYPE PERIOD_TYPE
, KHH.PERIOD_START PERIOD_START
, KHH.PRICE_UOM PRICE_UOM
, KHH.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
, KHH.FOLLOW_UP_DATE FOLLOW_UP_DATE
, KHH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, KHH.DATE_ACCEPTED DATE_ACCEPTED
, KHH.ACCEPTED_BY ACCEPTED_BY
, KHH.RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG
, KHH.RMNDR_SENT_FLAG RMNDR_SENT_FLAG
, KHH.QUOTE_SENT_FLAG QUOTE_SENT_FLAG
, KHH.PROCESS_REQUEST_ID PROCESS_REQUEST_ID
, KHH.WF_ITEM_KEY WF_ITEM_KEY
, KHH.PERSON_PARTY_ID PERSON_PARTY_ID
, KHH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, KHH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, KHH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, KHH.APPROVAL_TYPE_USED APPROVAL_TYPE_USED
, KHH.RENEWAL_COMMENT RENEWAL_COMMENT
, KHH.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS
FROM OKS_K_HEADERS_BH KHH