VIEW: OKL.OKL_SYSTEM_PARAMS_ALL#

Source

View Text - Preformatted

select ID ID, DELINK_YN DELINK_YN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORG_ID ORG_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, CATEGORY_SET_ID CATEGORY_SET_ID, REMK_ORGANIZATION_ID REMK_ORGANIZATION_ID, REMK_SUBINVENTORY REMK_SUBINVENTORY, REMK_PRICE_LIST_ID REMK_PRICE_LIST_ID, REMK_PROCESS_CODE REMK_PROCESS_CODE, REMK_ITEM_TEMPLATE_ID REMK_ITEM_TEMPLATE_ID, REMK_ITEM_INVOICED_CODE REMK_ITEM_INVOICED_CODE, LEASE_INV_ORG_YN LEASE_INV_ORG_YN, TAX_UPFRONT_YN TAX_UPFRONT_YN, TAX_INVOICE_YN TAX_INVOICE_YN, TAX_SCHEDULE_YN TAX_SCHEDULE_YN, TAX_UPFRONT_STY_ID TAX_UPFRONT_STY_ID, CANCEL_QUOTES_YN CANCEL_QUOTES_YN, VALIDATION_SET_ID VALIDATION_SET_ID, CHK_ACCRUAL_PREVIOUS_MNTH_YN CHK_ACCRUAL_PREVIOUS_MNTH_YN, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID, OWNER_TYPE_CODE OWNER_TYPE_CODE, OWNER_ID OWNER_ID, ITEM_INV_ORG_ID ITEM_INV_ORG_ID, RPT_PROD_BOOK_TYPE_CODE RPT_PROD_BOOK_TYPE_CODE, ASST_ADD_BOOK_TYPE_CODE ASST_ADD_BOOK_TYPE_CODE, CCARD_REMITTANCE_ID CCARD_REMITTANCE_ID, CORPORATE_BOOK CORPORATE_BOOK, TAX_BOOK_1 TAX_BOOK_1, TAX_BOOK_2 TAX_BOOK_2, FA_LOCATION_ID FA_LOCATION_ID, FORMULA_ID FORMULA_ID, ASSET_KEY_ID ASSET_KEY_ID, DEPRECIATE_YN DEPRECIATE_YN, PART_TRMNT_APPLY_ROUND_DIFF PART_TRMNT_APPLY_ROUND_DIFF, LSEAPP_SEQ_PREFIX_TXT LSEAPP_SEQ_PREFIX_TXT, LSEOPP_SEQ_PREFIX_TXT LSEOPP_SEQ_PREFIX_TXT, LSEQTE_SEQ_PREFIX_TXT LSEQTE_SEQ_PREFIX_TXT, QCKQTE_SEQ_PREFIX_TXT QCKQTE_SEQ_PREFIX_TXT from "OKL"."OKL_SYSTEM_PARAMS_ALL"

View Text - HTML Formatted

SELECT ID ID
, DELINK_YN DELINK_YN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORG_ID ORG_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, CATEGORY_SET_ID CATEGORY_SET_ID
, REMK_ORGANIZATION_ID REMK_ORGANIZATION_ID
, REMK_SUBINVENTORY REMK_SUBINVENTORY
, REMK_PRICE_LIST_ID REMK_PRICE_LIST_ID
, REMK_PROCESS_CODE REMK_PROCESS_CODE
, REMK_ITEM_TEMPLATE_ID REMK_ITEM_TEMPLATE_ID
, REMK_ITEM_INVOICED_CODE REMK_ITEM_INVOICED_CODE
, LEASE_INV_ORG_YN LEASE_INV_ORG_YN
, TAX_UPFRONT_YN TAX_UPFRONT_YN
, TAX_INVOICE_YN TAX_INVOICE_YN
, TAX_SCHEDULE_YN TAX_SCHEDULE_YN
, TAX_UPFRONT_STY_ID TAX_UPFRONT_STY_ID
, CANCEL_QUOTES_YN CANCEL_QUOTES_YN
, VALIDATION_SET_ID VALIDATION_SET_ID
, CHK_ACCRUAL_PREVIOUS_MNTH_YN CHK_ACCRUAL_PREVIOUS_MNTH_YN
, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID
, OWNER_TYPE_CODE OWNER_TYPE_CODE
, OWNER_ID OWNER_ID
, ITEM_INV_ORG_ID ITEM_INV_ORG_ID
, RPT_PROD_BOOK_TYPE_CODE RPT_PROD_BOOK_TYPE_CODE
, ASST_ADD_BOOK_TYPE_CODE ASST_ADD_BOOK_TYPE_CODE
, CCARD_REMITTANCE_ID CCARD_REMITTANCE_ID
, CORPORATE_BOOK CORPORATE_BOOK
, TAX_BOOK_1 TAX_BOOK_1
, TAX_BOOK_2 TAX_BOOK_2
, FA_LOCATION_ID FA_LOCATION_ID
, FORMULA_ID FORMULA_ID
, ASSET_KEY_ID ASSET_KEY_ID
, DEPRECIATE_YN DEPRECIATE_YN
, PART_TRMNT_APPLY_ROUND_DIFF PART_TRMNT_APPLY_ROUND_DIFF
, LSEAPP_SEQ_PREFIX_TXT LSEAPP_SEQ_PREFIX_TXT
, LSEOPP_SEQ_PREFIX_TXT LSEOPP_SEQ_PREFIX_TXT
, LSEQTE_SEQ_PREFIX_TXT LSEQTE_SEQ_PREFIX_TXT
, QCKQTE_SEQ_PREFIX_TXT QCKQTE_SEQ_PREFIX_TXT
FROM "OKL"."OKL_SYSTEM_PARAMS_ALL"