VIEW: OKL.OKL_TRX_EXTENSION_B#

Source

View Text - Preformatted

select HEADER_EXTENSION_ID HEADER_EXTENSION_ID, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONTRACT_NUMBER CONTRACT_NUMBER, INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE, INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE, CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM, INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM, CUSTOMER_NAME CUSTOMER_NAME, SALES_REP_NAME SALES_REP_NAME, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER, BILL_TO_ADDRESS_NUM BILL_TO_ADDRESS_NUM, INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE, REV_REC_METHOD_CODE REV_REC_METHOD_CODE, CONVERTED_NUMBER CONVERTED_NUMBER, ASSIGNABLE_FLAG ASSIGNABLE_FLAG, CREDIT_LINE_NUMBER CREDIT_LINE_NUMBER, MASTER_LEASE_NUMBER MASTER_LEASE_NUMBER, PO_ORDER_NUMBER PO_ORDER_NUMBER, VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER, INS_POLICY_TYPE_CODE INS_POLICY_TYPE_CODE, INS_POLICY_NUMBER INS_POLICY_NUMBER, TERM_QUOTE_ACCEPT_DATE TERM_QUOTE_ACCEPT_DATE, TERM_QUOTE_NUM TERM_QUOTE_NUM, TERM_QUOTE_TYPE_CODE TERM_QUOTE_TYPE_CODE, CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG, ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG, CUST_ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY, CUST_ATTRIBUTE1 CUST_ATTRIBUTE1, CUST_ATTRIBUTE2 CUST_ATTRIBUTE2, CUST_ATTRIBUTE3 CUST_ATTRIBUTE3, CUST_ATTRIBUTE4 CUST_ATTRIBUTE4, CUST_ATTRIBUTE5 CUST_ATTRIBUTE5, CUST_ATTRIBUTE6 CUST_ATTRIBUTE6, CUST_ATTRIBUTE7 CUST_ATTRIBUTE7, CUST_ATTRIBUTE8 CUST_ATTRIBUTE8, CUST_ATTRIBUTE9 CUST_ATTRIBUTE9, CUST_ATTRIBUTE10 CUST_ATTRIBUTE10, CUST_ATTRIBUTE11 CUST_ATTRIBUTE11, CUST_ATTRIBUTE12 CUST_ATTRIBUTE12, CUST_ATTRIBUTE13 CUST_ATTRIBUTE13, CUST_ATTRIBUTE14 CUST_ATTRIBUTE14, CUST_ATTRIBUTE15 CUST_ATTRIBUTE15, RENT_IA_CONTRACT_NUMBER RENT_IA_CONTRACT_NUMBER, RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER, INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER, RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME, RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME, RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE, RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE, INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE, INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE, TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_CODE, CHR_OPERATING_UNIT_CODE CHR_OPERATING_UNIT_CODE, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_SITE_USE_ID CUST_SITE_USE_ID from "OKL"."OKL_TRX_EXTENSION_B"

View Text - HTML Formatted

SELECT HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONTRACT_NUMBER CONTRACT_NUMBER
, INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER
, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE
, CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM
, INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM
, CUSTOMER_NAME CUSTOMER_NAME
, SALES_REP_NAME SALES_REP_NAME
, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, BILL_TO_ADDRESS_NUM BILL_TO_ADDRESS_NUM
, INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE
, REV_REC_METHOD_CODE REV_REC_METHOD_CODE
, CONVERTED_NUMBER CONVERTED_NUMBER
, ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, CREDIT_LINE_NUMBER CREDIT_LINE_NUMBER
, MASTER_LEASE_NUMBER MASTER_LEASE_NUMBER
, PO_ORDER_NUMBER PO_ORDER_NUMBER
, VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER
, INS_POLICY_TYPE_CODE INS_POLICY_TYPE_CODE
, INS_POLICY_NUMBER INS_POLICY_NUMBER
, TERM_QUOTE_ACCEPT_DATE TERM_QUOTE_ACCEPT_DATE
, TERM_QUOTE_NUM TERM_QUOTE_NUM
, TERM_QUOTE_TYPE_CODE TERM_QUOTE_TYPE_CODE
, CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG
, ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG
, CUST_ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY
, CUST_ATTRIBUTE1 CUST_ATTRIBUTE1
, CUST_ATTRIBUTE2 CUST_ATTRIBUTE2
, CUST_ATTRIBUTE3 CUST_ATTRIBUTE3
, CUST_ATTRIBUTE4 CUST_ATTRIBUTE4
, CUST_ATTRIBUTE5 CUST_ATTRIBUTE5
, CUST_ATTRIBUTE6 CUST_ATTRIBUTE6
, CUST_ATTRIBUTE7 CUST_ATTRIBUTE7
, CUST_ATTRIBUTE8 CUST_ATTRIBUTE8
, CUST_ATTRIBUTE9 CUST_ATTRIBUTE9
, CUST_ATTRIBUTE10 CUST_ATTRIBUTE10
, CUST_ATTRIBUTE11 CUST_ATTRIBUTE11
, CUST_ATTRIBUTE12 CUST_ATTRIBUTE12
, CUST_ATTRIBUTE13 CUST_ATTRIBUTE13
, CUST_ATTRIBUTE14 CUST_ATTRIBUTE14
, CUST_ATTRIBUTE15 CUST_ATTRIBUTE15
, RENT_IA_CONTRACT_NUMBER RENT_IA_CONTRACT_NUMBER
, RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER
, INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER
, RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME
, RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME
, RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE
, RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE
, INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE
, TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_CODE
, CHR_OPERATING_UNIT_CODE CHR_OPERATING_UNIT_CODE
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_SITE_USE_ID CUST_SITE_USE_ID
FROM "OKL"."OKL_TRX_EXTENSION_B"