VIEW: APPS.OKS_K_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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