[Home] [Help] [Dependency Information]
Object Name: | OKL_SYSTEM_PARAMS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SYSTEM_PARAMS_ALL |
Subobject Name: | |
Status: | VALID |
Table for storing the parameters used by the system.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SYSTEM_PARAMS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORG_ID |
OKL_SYSTEM_PARAMS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary Key Column. | |
DELINK_YN | VARCHAR2 | (3) | Delink Yes/No | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
CATEGORY_SET_ID | NUMBER | Category set identifier | ||
REMK_ORGANIZATION_ID | NUMBER | Remarketing Organization Identifier | ||
REMK_SUBINVENTORY | VARCHAR2 | (10) | Remarketing Subinventory | |
REMK_PRICE_LIST_ID | NUMBER | Remarketing Price List Identifier | ||
REMK_PROCESS_CODE | VARCHAR2 | (15) | Remarketing Process Code | |
REMK_ITEM_TEMPLATE_ID | NUMBER | Remarketing Item Template Identifier | ||
REMK_ITEM_INVOICED_CODE | VARCHAR2 | (15) | Remarketing Item Invoiced Code | |
LEASE_INV_ORG_YN | VARCHAR2 | (3) | Lease Invoice Org Yes/No | |
TAX_UPFRONT_YN | VARCHAR2 | (1) | Tax Upfront value Yes/No. | |
TAX_INVOICE_YN | VARCHAR2 | (1) | Tax Invoice Yes/No. | |
TAX_SCHEDULE_YN | VARCHAR2 | (1) | Tax Schedule Yes/No. | |
TAX_UPFRONT_STY_ID | NUMBER | Tax Upfront Stream Type Identifier. | ||
CANCEL_QUOTES_YN | VARCHAR2 | (3) | Cancel Quotes Yes/No. | |
VALIDATION_SET_ID | NUMBER | Validation Set Identifier | ||
CHK_ACCRUAL_PREVIOUS_MNTH_YN | VARCHAR2 | (3) | Check Accruals for previous Month Yes/No. | |
TASK_TEMPLATE_GROUP_ID | NUMBER | Is used in Third Party Insurance Setup | ||
OWNER_TYPE_CODE | VARCHAR2 | (30) | Owner Type Code. | |
OWNER_ID | NUMBER | Owner Identifier. | ||
ITEM_INV_ORG_ID | NUMBER | Item Inventory Org Id | ||
RPT_PROD_BOOK_TYPE_CODE | VARCHAR2 | (15) | Reporting Product Asset Book Code | |
ASST_ADD_BOOK_TYPE_CODE | VARCHAR2 | (15) | Asset Addition Corporate Book Code | |
CCARD_REMITTANCE_ID | NUMBER | AR Payment Method for Credit Card | ||
CORPORATE_BOOK | VARCHAR2 | (70) | Corporate Book | |
TAX_BOOK_1 | VARCHAR2 | (15) | Tax Book 1 | |
TAX_BOOK_2 | VARCHAR2 | (15) | Tax Book 2 | |
FA_LOCATION_ID | NUMBER | Fixed Asset Location Identifier | ||
FORMULA_ID | NUMBER | Formula Identifier | ||
ASSET_KEY_ID | NUMBER | Asset Key Identifier | ||
DEPRECIATE_YN | VARCHAR2 | (3) | Depreciate Yes/No | |
PART_TRMNT_APPLY_ROUND_DIFF | VARCHAR2 | (30) | Stores the rounding rule for Partial Termination transactions | |
LSEAPP_SEQ_PREFIX_TXT | VARCHAR2 | (140) | Lease Application Sequence Prefix | |
LSEOPP_SEQ_PREFIX_TXT | VARCHAR2 | (140) | Lease Opportunity Sequence Prefix | |
LSEQTE_SEQ_PREFIX_TXT | VARCHAR2 | (140) | Lease Quote Sequence Prefix | |
QCKQTE_SEQ_PREFIX_TXT | VARCHAR2 | (140) | Quick Quote Sequence Prefix |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, DELINK_YN
, OBJECT_VERSION_NUMBER
, ORG_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CATEGORY_SET_ID
, REMK_ORGANIZATION_ID
, REMK_SUBINVENTORY
, REMK_PRICE_LIST_ID
, REMK_PROCESS_CODE
, REMK_ITEM_TEMPLATE_ID
, REMK_ITEM_INVOICED_CODE
, LEASE_INV_ORG_YN
, TAX_UPFRONT_YN
, TAX_INVOICE_YN
, TAX_SCHEDULE_YN
, TAX_UPFRONT_STY_ID
, CANCEL_QUOTES_YN
, VALIDATION_SET_ID
, CHK_ACCRUAL_PREVIOUS_MNTH_YN
, TASK_TEMPLATE_GROUP_ID
, OWNER_TYPE_CODE
, OWNER_ID
, ITEM_INV_ORG_ID
, RPT_PROD_BOOK_TYPE_CODE
, ASST_ADD_BOOK_TYPE_CODE
, CCARD_REMITTANCE_ID
, CORPORATE_BOOK
, TAX_BOOK_1
, TAX_BOOK_2
, FA_LOCATION_ID
, FORMULA_ID
, ASSET_KEY_ID
, DEPRECIATE_YN
, PART_TRMNT_APPLY_ROUND_DIFF
, LSEAPP_SEQ_PREFIX_TXT
, LSEOPP_SEQ_PREFIX_TXT
, LSEQTE_SEQ_PREFIX_TXT
, QCKQTE_SEQ_PREFIX_TXT
FROM OKL.OKL_SYSTEM_PARAMS_ALL;
OKL.OKL_SYSTEM_PARAMS_ALL does not reference any database object
OKL.OKL_SYSTEM_PARAMS_ALL is referenced by following:
|
|
|