VIEW: OKS.OKS_INT_HEADER_STG_TEMP#

Source

View Text - Preformatted

select HEADER_INTERFACE_ID HEADER_INTERFACE_ID, HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, INTERFACE_STATUS INTERFACE_STATUS, CATEGORY CATEGORY, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, KNOWN_AS KNOWN_AS, DESCRIPTION DESCRIPTION, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, OPERATING_UNIT_ID OPERATING_UNIT_ID, BILL_TO_SITE_USAGE_ID BILL_TO_SITE_USAGE_ID, SHIP_TO_SITE_USAGE_ID SHIP_TO_SITE_USAGE_ID, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, PRICE_LIST_ID PRICE_LIST_ID, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION, PO_REQUIRED PO_REQUIRED, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS, INVOICING_RULE_ID INVOICING_RULE_ID, SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ, RENEWAL_PROCESS RENEWAL_PROCESS, APPROVAL_REQUIRED APPROVAL_REQUIRED, RENEW_UP_TO RENEW_UP_TO, DATE_APPROVED DATE_APPROVED, DATE_SIGNED DATE_SIGNED, DATE_CANCELED DATE_CANCELED, CANCELLATION_REASON CANCELLATION_REASON, QA_CHECKLIST QA_CHECKLIST, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, COMMITMENT_ID COMMITMENT_ID, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, BILL_SERVICES BILL_SERVICES, BILLING_TRANSACTION_TYPE_ID BILLING_TRANSACTION_TYPE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, HOLD_CREDITS HOLD_CREDITS, SUMMARY_PRINT SUMMARY_PRINT, SUMMARY_TRANSACTIONS SUMMARY_TRANSACTIONS, SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED, SERVICE_CHARGES_PO_NUMBER SERVICE_CHARGES_PO_NUMBER, PRICING_METHOD PRICING_METHOD, RENEWAL_PRICE_LIST_ID RENEWAL_PRICE_LIST_ID, RENEWAL_MARKUP RENEWAL_MARKUP, RENEWAL_BILLING_PROFILE_ID RENEWAL_BILLING_PROFILE_ID, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER, RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED, RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION, RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD, RENEWAL_ESTIMATED_PERCENT RENEWAL_ESTIMATED_PERCENT, RENEWAL_ESTIMATED_DURATION RENEWAL_ESTIMATED_DURATION, RENEWAL_ESTIMATED_PERIOD RENEWAL_ESTIMATED_PERIOD, QUOTE_TO_PARTY_SITE QUOTE_TO_PARTY_SITE, QUOTE_TO_CONTACT QUOTE_TO_CONTACT, QUOTE_TO_PHONE QUOTE_TO_PHONE, QUOTE_TO_FAX QUOTE_TO_FAX, QUOTE_TO_EMAIL QUOTE_TO_EMAIL, GRACE_DURATION GRACE_DURATION, GRACE_PERIOD GRACE_PERIOD, ESTIMATION_PERCENT ESTIMATION_PERCENT, ESTIMATION_DATE ESTIMATION_DATE, FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE, FOLLOW_UP_ACTION FOLLOW_UP_ACTION, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID, THIRD_PARTY_ID THIRD_PARTY_ID, CONTRACT_GROUP_ID CONTRACT_GROUP_ID, APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID, AGREEMENT_ID AGREEMENT_ID, SALESPERSON_ID SALESPERSON_ID, CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID, SALESGROUP_ID SALESGROUP_ID, FULLY_BILLED FULLY_BILLED, SOURCE SOURCE, DOCUMENT DOCUMENT from "OKS"."OKS_INT_HEADER_STG_TEMP"

View Text - HTML Formatted

SELECT HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, INTERFACE_STATUS INTERFACE_STATUS
, CATEGORY CATEGORY
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, KNOWN_AS KNOWN_AS
, DESCRIPTION DESCRIPTION
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, BILL_TO_SITE_USAGE_ID BILL_TO_SITE_USAGE_ID
, SHIP_TO_SITE_USAGE_ID SHIP_TO_SITE_USAGE_ID
, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, PRICE_LIST_ID PRICE_LIST_ID
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION
, PO_REQUIRED PO_REQUIRED
, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
, INVOICING_RULE_ID INVOICING_RULE_ID
, SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ
, RENEWAL_PROCESS RENEWAL_PROCESS
, APPROVAL_REQUIRED APPROVAL_REQUIRED
, RENEW_UP_TO RENEW_UP_TO
, DATE_APPROVED DATE_APPROVED
, DATE_SIGNED DATE_SIGNED
, DATE_CANCELED DATE_CANCELED
, CANCELLATION_REASON CANCELLATION_REASON
, QA_CHECKLIST QA_CHECKLIST
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, COMMITMENT_ID COMMITMENT_ID
, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, BILL_SERVICES BILL_SERVICES
, BILLING_TRANSACTION_TYPE_ID BILLING_TRANSACTION_TYPE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, HOLD_CREDITS HOLD_CREDITS
, SUMMARY_PRINT SUMMARY_PRINT
, SUMMARY_TRANSACTIONS SUMMARY_TRANSACTIONS
, SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED
, SERVICE_CHARGES_PO_NUMBER SERVICE_CHARGES_PO_NUMBER
, PRICING_METHOD PRICING_METHOD
, RENEWAL_PRICE_LIST_ID RENEWAL_PRICE_LIST_ID
, RENEWAL_MARKUP RENEWAL_MARKUP
, RENEWAL_BILLING_PROFILE_ID RENEWAL_BILLING_PROFILE_ID
, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED
, RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION
, RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD
, RENEWAL_ESTIMATED_PERCENT RENEWAL_ESTIMATED_PERCENT
, RENEWAL_ESTIMATED_DURATION RENEWAL_ESTIMATED_DURATION
, RENEWAL_ESTIMATED_PERIOD RENEWAL_ESTIMATED_PERIOD
, QUOTE_TO_PARTY_SITE QUOTE_TO_PARTY_SITE
, QUOTE_TO_CONTACT QUOTE_TO_CONTACT
, QUOTE_TO_PHONE QUOTE_TO_PHONE
, QUOTE_TO_FAX QUOTE_TO_FAX
, QUOTE_TO_EMAIL QUOTE_TO_EMAIL
, GRACE_DURATION GRACE_DURATION
, GRACE_PERIOD GRACE_PERIOD
, ESTIMATION_PERCENT ESTIMATION_PERCENT
, ESTIMATION_DATE ESTIMATION_DATE
, FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE
, FOLLOW_UP_ACTION FOLLOW_UP_ACTION
, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID
, THIRD_PARTY_ID THIRD_PARTY_ID
, CONTRACT_GROUP_ID CONTRACT_GROUP_ID
, APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID
, AGREEMENT_ID AGREEMENT_ID
, SALESPERSON_ID SALESPERSON_ID
, CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID
, SALESGROUP_ID SALESGROUP_ID
, FULLY_BILLED FULLY_BILLED
, SOURCE SOURCE
, DOCUMENT DOCUMENT
FROM "OKS"."OKS_INT_HEADER_STG_TEMP"