VIEW: OKL.OKL_EXT_AP_HEADER_SOURCES_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, KHR_ID KHR_ID, TRY_ID TRY_ID, TRANS_NUMBER TRANS_NUMBER, CONTRACT_NUMBER CONTRACT_NUMBER, CUSTOMER_NAME CUSTOMER_NAME, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER, PRODUCT_NAME PRODUCT_NAME, BOOK_CLASSIFICATION_CODE BOOK_CLASSIFICATION_CODE, TAX_OWNER_CODE TAX_OWNER_CODE, INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE, REV_REC_METHOD_CODE REV_REC_METHOD_CODE, SCS_CODE SCS_CODE, CONVERTED_NUMBER CONVERTED_NUMBER, CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE, SALES_REP_NAME SALES_REP_NAME, PO_ORDER_NUMBER PO_ORDER_NUMBER, VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER, ASSIGNABLE_FLAG ASSIGNABLE_FLAG, CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG, ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG, KHR_ATTRIBUTE_CATEGORY KHR_ATTRIBUTE_CATEGORY, KHR_ATTRIBUTE1 KHR_ATTRIBUTE1, KHR_ATTRIBUTE2 KHR_ATTRIBUTE2, KHR_ATTRIBUTE3 KHR_ATTRIBUTE3, KHR_ATTRIBUTE4 KHR_ATTRIBUTE4, KHR_ATTRIBUTE5 KHR_ATTRIBUTE5, KHR_ATTRIBUTE6 KHR_ATTRIBUTE6, KHR_ATTRIBUTE7 KHR_ATTRIBUTE7, KHR_ATTRIBUTE8 KHR_ATTRIBUTE8, KHR_ATTRIBUTE9 KHR_ATTRIBUTE9, KHR_ATTRIBUTE10 KHR_ATTRIBUTE10, KHR_ATTRIBUTE11 KHR_ATTRIBUTE11, KHR_ATTRIBUTE12 KHR_ATTRIBUTE12, KHR_ATTRIBUTE13 KHR_ATTRIBUTE13, KHR_ATTRIBUTE14 KHR_ATTRIBUTE14, KHR_ATTRIBUTE15 KHR_ATTRIBUTE15, 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, RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME, RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE, RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER, RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME, RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE, INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER, INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM, INV_AGRMNT_PRODUCT_NAME INV_AGRMNT_PRODUCT_NAME, INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE, INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE, INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE, INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE, TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_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, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID from "OKL"."OKL_EXT_AP_HEADER_SOURCES_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
, KHR_ID KHR_ID
, TRY_ID TRY_ID
, TRANS_NUMBER TRANS_NUMBER
, CONTRACT_NUMBER CONTRACT_NUMBER
, CUSTOMER_NAME CUSTOMER_NAME
, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, PRODUCT_NAME PRODUCT_NAME
, BOOK_CLASSIFICATION_CODE BOOK_CLASSIFICATION_CODE
, TAX_OWNER_CODE TAX_OWNER_CODE
, INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE
, REV_REC_METHOD_CODE REV_REC_METHOD_CODE
, SCS_CODE SCS_CODE
, CONVERTED_NUMBER CONVERTED_NUMBER
, CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM
, CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, SALES_REP_NAME SALES_REP_NAME
, PO_ORDER_NUMBER PO_ORDER_NUMBER
, VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER
, ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG
, ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG
, KHR_ATTRIBUTE_CATEGORY KHR_ATTRIBUTE_CATEGORY
, KHR_ATTRIBUTE1 KHR_ATTRIBUTE1
, KHR_ATTRIBUTE2 KHR_ATTRIBUTE2
, KHR_ATTRIBUTE3 KHR_ATTRIBUTE3
, KHR_ATTRIBUTE4 KHR_ATTRIBUTE4
, KHR_ATTRIBUTE5 KHR_ATTRIBUTE5
, KHR_ATTRIBUTE6 KHR_ATTRIBUTE6
, KHR_ATTRIBUTE7 KHR_ATTRIBUTE7
, KHR_ATTRIBUTE8 KHR_ATTRIBUTE8
, KHR_ATTRIBUTE9 KHR_ATTRIBUTE9
, KHR_ATTRIBUTE10 KHR_ATTRIBUTE10
, KHR_ATTRIBUTE11 KHR_ATTRIBUTE11
, KHR_ATTRIBUTE12 KHR_ATTRIBUTE12
, KHR_ATTRIBUTE13 KHR_ATTRIBUTE13
, KHR_ATTRIBUTE14 KHR_ATTRIBUTE14
, KHR_ATTRIBUTE15 KHR_ATTRIBUTE15
, 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
, RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME
, RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE
, RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER
, RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME
, RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE
, INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER
, INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM
, INV_AGRMNT_PRODUCT_NAME INV_AGRMNT_PRODUCT_NAME
, INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE
, INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE
, INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER
, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE
, TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_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
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM "OKL"."OKL_EXT_AP_HEADER_SOURCES_B"