DBA Data[Home] [Help] [Dependency Information]

TABLE: OKL.OKL_SUBSIDIES_ALL_B

Object Details
Object Name: OKL_SUBSIDIES_ALL_B
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_SUBSIDIES_ALL_B
Subobject Name:
Status: VALID


This table stores subsidy setups.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_SUBSIDIES_ALL_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKL_SUBSIDIES_ALL_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnORG_ID
OKL_SUBSIDIES_ALL_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSIDY_POOL_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Unique identifier for subsidy
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
ORG_ID NUMBER
Yes Operating unit identifier
NAME VARCHAR2 (30) Yes User defined subsidy name
EFFECTIVE_FROM_DATE DATE
Yes Subsidy effective from date
EFFECTIVE_TO_DATE DATE

Subsidy effective to date
EXPIRE_AFTER_DAYS NUMBER (4)
If days between contract activation date and subsidy effective date are less than expire after days, then subsidy will not apply to that contract
CURRENCY_CODE VARCHAR2 (15)
Currency code. Will always be functional currency of the operating unit
EXCLUSIVE_YN VARCHAR2 (3)
Determines whether this subsidy is applicable along with other subsidies
APPLICABLE_TO_RELEASE_YN VARCHAR2 (3)
Determines whether subsidy can be applied to used(released) assets
SUBSIDY_CALC_BASIS VARCHAR2 (30)
Subsidy calculation basis code. Foreign key to FND_LOOKUPS, LOOKUP_TYPE = 'OKL_SUBCALC_BASIS'
AMOUNT NUMBER

Subsidy amount. This is mandatory if calculation bases is 'FIXED'
PERCENT NUMBER (5)
Subsidy percent. This is calculated as percentage of calculation basis
FORMULA_ID NUMBER

Subsidy calculation formula identifier
RATE_POINTS NUMBER

Rate points for calculation of ubsidy amount
MAXIMUM_TERM NUMBER

Maximum term in months till which the subsidy is applicable
VENDOR_ID NUMBER

Indentifier for subsidy provider party (vendor). Foreign key to PO_VENDORS
ACCOUNTING_METHOD_CODE VARCHAR2 (30)
Accounting method code determines whether to 'Net' or 'Amortize' a subsidy for accounting purpose. Foreign key to FND_LOOKUPS, lookup type = 'OKL_SUBACCT_METHOD'
RECOURSE_YN VARCHAR2 (3)
Determines whether the subsidy provider gets refund if asset is terminated early
TERMINATION_REFUND_BASIS VARCHAR2 (30)
Determines how refund amount is calculated if recourse is applicable. Foreign key to FND_LOOKUPS, lookup type = 'OKL_SUBRFND_BASIS'
REFUND_FORMULA_ID NUMBER

Determines the amount to refund if refund calculation basis is 'Partial'
STREAM_TYPE_ID NUMBER

Stream type associated with subsidy
RECEIPT_METHOD_CODE VARCHAR2 (30)
Determines how subsidy amount is received from the subsidy provider. Whether it is 'Billed' to the provider or netted from funding. Foreign key to FND_LOOKUPS, lookup type = 'OKL_SUBRCPT_METHOD'
CUSTOMER_VISIBLE_YN VARCHAR2 (3)
Determines whether to display subsidy on customer visible UI and other components
MAXIMUM_FINANCED_AMOUNT NUMBER

If subsidy calculation basis is 'Percent' then the minimum of asset original cost and maximum financed amount will be used as the basis for subsidy calculation
MAXIMUM_SUBSIDY_AMOUNT NUMBER

Maximum subsidy amount allowed for this subsidy. If calculated subsidy amount is more than maximum subsidy amout then maximum subsidy amount will override the calculated subsidy amount
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 (90)
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 colum
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANSFER_BASIS_CODE VARCHAR2 (30)
Transfer Basis Code
SUBSIDY_POOL_ID NUMBER

Subsidy Pool identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      OBJECT_VERSION_NUMBER
,      ORG_ID
,      NAME
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      EXPIRE_AFTER_DAYS
,      CURRENCY_CODE
,      EXCLUSIVE_YN
,      APPLICABLE_TO_RELEASE_YN
,      SUBSIDY_CALC_BASIS
,      AMOUNT
,      PERCENT
,      FORMULA_ID
,      RATE_POINTS
,      MAXIMUM_TERM
,      VENDOR_ID
,      ACCOUNTING_METHOD_CODE
,      RECOURSE_YN
,      TERMINATION_REFUND_BASIS
,      REFUND_FORMULA_ID
,      STREAM_TYPE_ID
,      RECEIPT_METHOD_CODE
,      CUSTOMER_VISIBLE_YN
,      MAXIMUM_FINANCED_AMOUNT
,      MAXIMUM_SUBSIDY_AMOUNT
,      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
,      TRANSFER_BASIS_CODE
,      SUBSIDY_POOL_ID
FROM OKL.OKL_SUBSIDIES_ALL_B;

Dependencies

[top of page]

OKL.OKL_SUBSIDIES_ALL_B does not reference any database object

OKL.OKL_SUBSIDIES_ALL_B is referenced by following:

SchemaOKL
ViewOKL_SUBSIDIES_ALL_B#