[Home] [Help] [Dependency Information]
Object Name: | OKL_SUBSIDY_CRITERIA |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SUBSIDY_CRITERIA |
Subobject Name: | |
Status: | VALID |
This table stores applicability criterion for a subsidy. Multiple applicability criterion can be defined for a subsidy based on which it will be either applicable to an asset on a contract or not. Data in this table, in addition to the basic applicability attributes in table OKL_SUBSIDIES_B determines whether a subsidy can be applied to an asset or not. Applicability attributes in this table are
1. Inventory organization
2. Inventory item
3. Lease financial product
4. Customer credit class
5. Industry (SIC) code
6. Sales territory
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SUBSIDY_CRITERIA_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_SUBSIDY_CRITERIA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUBSIDY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique identifier for subsidy criteria | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SUBSIDY_ID | NUMBER | Yes | Foreign key to OKL_SUBSIDIES_B | |
DISPLAY_SEQUENCE | NUMBER | (4) | Generated number used for user interface | |
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier for which subsidy is applicable | ||
ORGANIZATION_ID | NUMBER | Inventory organization identifier for which the subsidy is applicable | ||
CREDIT_CLASSIFICATION_CODE | VARCHAR2 | (30) | Credit classification code for which the subsidy is applicable | |
SALES_TERRITORY_CODE | VARCHAR2 | (2) | Not used | |
PRODUCT_ID | NUMBER | Financial product identifier for which the subsidy is applicable | ||
INDUSTRY_CODE_TYPE | VARCHAR2 | (30) | Industry code type of the customer for which this subsidy is applicable | |
INDUSTRY_CODE | VARCHAR2 | (30) | Industry code for which te subsidy is applicable | |
MAXIMUM_FINANCED_AMOUNT | NUMBER | Not used at present | ||
SALES_TERRITORY_ID | NUMBER | Unique identifier for slaes territory. Foreign key to RA_TERRITORIES.TERRITORY_ID | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Attribute category | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, SUBSIDY_ID
, DISPLAY_SEQUENCE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CREDIT_CLASSIFICATION_CODE
, SALES_TERRITORY_CODE
, PRODUCT_ID
, INDUSTRY_CODE_TYPE
, INDUSTRY_CODE
, MAXIMUM_FINANCED_AMOUNT
, SALES_TERRITORY_ID
, 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
FROM OKL.OKL_SUBSIDY_CRITERIA;
OKL.OKL_SUBSIDY_CRITERIA does not reference any database object
OKL.OKL_SUBSIDY_CRITERIA is referenced by following:
|
|
|