VIEW: OKS.OKS_INT_LINE_STG_TEMP#

Source

View Text - Preformatted

select LINE_INTERFACE_ID LINE_INTERFACE_ID, HEADER_INTERFACE_ID HEADER_INTERFACE_ID, HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID, LINE_INTERFACE_ROWID LINE_INTERFACE_ROWID, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, LSE_ID LSE_ID, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID, ITEM_ID ITEM_ID, REFERENCE_TEMPLATE_ID REFERENCE_TEMPLATE_ID, LINE_REFERENCE LINE_REFERENCE, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, BILL_TO_SITE_USAGE_ID BILL_TO_SITE_USAGE_ID, SHIP_TO_SITE_USAGE_ID SHIP_TO_SITE_USAGE_ID, CUSTOMER_BILLING_CONTACT_ID CUSTOMER_BILLING_CONTACT_ID, CUSTOMER_SHIPPING_CONTACT_ID CUSTOMER_SHIPPING_CONTACT_ID, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE, CANCELLATION_DATE CANCELLATION_DATE, CANCELLATION_REASON CANCELLATION_REASON, PRICE_LIST_ID PRICE_LIST_ID, INVOICE_TEXT INVOICE_TEXT, PRINT_INVOICE PRINT_INVOICE, SUBTOTAL SUBTOTAL, TAX_AMOUNT TAX_AMOUNT, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION, PO_REQUIRED PO_REQUIRED, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, COMMITMENT_ID COMMITMENT_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION, BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD, FIRST_BILL_UPTO_DATE FIRST_BILL_UPTO_DATE, RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES, SUBSCRIPTION_QUANTITY SUBSCRIPTION_QUANTITY, QUANTITY_UOM QUANTITY_UOM, PRICE_UOM PRICE_UOM, UNIT_PRICE UNIT_PRICE, FIRST_BILLED_AMOUNT FIRST_BILLED_AMOUNT, LAST_BILLED_AMOUNT LAST_BILLED_AMOUNT, USAGE_TYPE USAGE_TYPE, USAGE_PERIOD USAGE_PERIOD, AVERAGING_INTERVAL AVERAGING_INTERVAL, SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL, USAGE_TERMINATION_METHOD USAGE_TERMINATION_METHOD, LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE from "OKS"."OKS_INT_LINE_STG_TEMP"

View Text - HTML Formatted

SELECT LINE_INTERFACE_ID LINE_INTERFACE_ID
, HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
, LINE_INTERFACE_ROWID LINE_INTERFACE_ROWID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, LSE_ID LSE_ID
, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID
, ITEM_ID ITEM_ID
, REFERENCE_TEMPLATE_ID REFERENCE_TEMPLATE_ID
, LINE_REFERENCE LINE_REFERENCE
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, BILL_TO_SITE_USAGE_ID BILL_TO_SITE_USAGE_ID
, SHIP_TO_SITE_USAGE_ID SHIP_TO_SITE_USAGE_ID
, CUSTOMER_BILLING_CONTACT_ID CUSTOMER_BILLING_CONTACT_ID
, CUSTOMER_SHIPPING_CONTACT_ID CUSTOMER_SHIPPING_CONTACT_ID
, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE
, CANCELLATION_DATE CANCELLATION_DATE
, CANCELLATION_REASON CANCELLATION_REASON
, PRICE_LIST_ID PRICE_LIST_ID
, INVOICE_TEXT INVOICE_TEXT
, PRINT_INVOICE PRINT_INVOICE
, SUBTOTAL SUBTOTAL
, TAX_AMOUNT TAX_AMOUNT
, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION
, PO_REQUIRED PO_REQUIRED
, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, COMMITMENT_ID COMMITMENT_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
, BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
, FIRST_BILL_UPTO_DATE FIRST_BILL_UPTO_DATE
, RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES
, SUBSCRIPTION_QUANTITY SUBSCRIPTION_QUANTITY
, QUANTITY_UOM QUANTITY_UOM
, PRICE_UOM PRICE_UOM
, UNIT_PRICE UNIT_PRICE
, FIRST_BILLED_AMOUNT FIRST_BILLED_AMOUNT
, LAST_BILLED_AMOUNT LAST_BILLED_AMOUNT
, USAGE_TYPE USAGE_TYPE
, USAGE_PERIOD USAGE_PERIOD
, AVERAGING_INTERVAL AVERAGING_INTERVAL
, SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL
, USAGE_TERMINATION_METHOD USAGE_TERMINATION_METHOD
, LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
FROM "OKS"."OKS_INT_LINE_STG_TEMP"