eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_SUBSIDIES_UV

Object Details

Object Name:	OKL_SUBSIDIES_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SUBSIDIES_UV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique identifier for subsidy
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
ORG_ID	NUMBER		Yes	Operating unit identifier
ORGANIZATION_NAME	VARCHAR2	(240)		Operating unit name
ORGANIZATION_CODE	VARCHAR2	(240)		Operating unit code
NAME	VARCHAR2	(30)	Yes	Subsidy name
SHORT_DESCRIPTION	VARCHAR2	(150)		Subsidy short description
DESCRIPTION	VARCHAR2	(1995)		Subsidy description
EFFECTIVE_FROM_DATE	DATE		Yes	Subsidy effective from date
EFFECTIVE_TO_DATE	DATE			Subsidy effective to date
EXPIRE_AFTER_DAYS	VARCHAR2	(40)		Maximum number of days after its expiration a subsidy will be applicable if it has already been attached to a contract
CURRENCY_CODE	VARCHAR2	(15)		Subsidy currency
EXCLUSIVE_YN	VARCHAR2	(3)		Flag to determine whether subsidy is exclusive
APPLICABLE_TO_RELEASE_YN	VARCHAR2	(3)		Flag to determine whether subsidy is applicable to re-lease assets and contracts
SUBSIDY_CALC_BASIS	VARCHAR2	(30)		subsidy calculation basis code
SUBSIDY_CALC_BASIS_MEANING	VARCHAR2	(80)		Subsidy calculation basis meaning
AMOUNT	VARCHAR2	(40)		Subsidy amount
PERCENT	VARCHAR2	(40)		Subsidy percent
FORMULA_ID	NUMBER			Subsidy calculation formula identifier
CALCULATION_FORMULA_NAME	VARCHAR2	(150)		Subsidy calculation formula name
CALCULATION_FORMULA_DESCR	VARCHAR2	(1995)		Subsidy calculation formula description
RATE_POINTS	VARCHAR2	(40)		Rate points for rate point subsidy calculation
MAXIMUM_TERM	VARCHAR2	(40)		Maximum term duration in months till which subsidy is applicable
VENDOR_ID	NUMBER			Subsidy provider vendor identifier
VENDOR_NAME	VARCHAR2	(240)		Subsidy provider vendor name
ACCOUNTING_METHOD_CODE	VARCHAR2	(30)		Subsidy accounting method code
ACCOUNTING_METHOD_MEANING	VARCHAR2	(80)		subsidy accounting method meaning
RECOURSE_YN_CODE	VARCHAR2	(3)		Flag to determine whether subsidy has to be refunded after early termination od asset
RECOURSE_YN_MEANING	VARCHAR2	(80)		Recourse flag meaning
TERMINATION_REFUND_BASIS	VARCHAR2	(30)		Early termination refund calculation method code
TERM_REFUND_BASIS_MEANING	VARCHAR2	(80)		Early termination refund calculation method
REFUND_FORMULA_ID	NUMBER			Refund calculation formula identifier
REFUND_FORMULA_NAME	VARCHAR2	(150)		Refund calculation formula name
REFUND_FORMULA_DESCR	VARCHAR2	(1995)		Refund calculation formula description
STREAM_TYPE_ID	NUMBER			Subsidy transaction stream type identifier
STREAM_TYPE_CODE	VARCHAR2	(150)		Stream type code
STREAM_TYPE_DESCR	VARCHAR2	(1995)		Steam type description
RECEIPT_METHOD_CODE	VARCHAR2	(30)		Subsidy receipt method code
RECEIPT_METHOD_MEANING	VARCHAR2	(80)		Subsidy receipt method meaning
CUST_VISIBLE_YN_CODE	VARCHAR2	(3)		Flag to determine whether subsidy should be visible to customer
CUST_VISIBLE_YN_MEANING	VARCHAR2	(80)		Customer visible flag meaning
MAXIMUM_FINANCED_AMOUNT	VARCHAR2	(40)		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	VARCHAR2	(40)		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
TRANSFER_BASIS_CODE	VARCHAR2	(30)		Transfer Basis Code
SUBSIDY_POOL_NAME	VARCHAR2	(30)		Subsidy Pool Name
POOL_ID	NUMBER			Pool identifier
SUBSIDY_POOL_STATUS_MEANING	VARCHAR2	(80)		Meaning of Subsidy pool status
DECISION_STATUS_CODE	VARCHAR2	(30)		Decision status code

Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      ORG_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      NAME
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      EXPIRE_AFTER_DAYS
,      CURRENCY_CODE
,      EXCLUSIVE_YN
,      APPLICABLE_TO_RELEASE_YN
,      SUBSIDY_CALC_BASIS
,      SUBSIDY_CALC_BASIS_MEANING
,      AMOUNT
,      PERCENT
,      FORMULA_ID
,      CALCULATION_FORMULA_NAME
,      CALCULATION_FORMULA_DESCR
,      RATE_POINTS
,      MAXIMUM_TERM
,      VENDOR_ID
,      VENDOR_NAME
,      ACCOUNTING_METHOD_CODE
,      ACCOUNTING_METHOD_MEANING
,      RECOURSE_YN_CODE
,      RECOURSE_YN_MEANING
,      TERMINATION_REFUND_BASIS
,      TERM_REFUND_BASIS_MEANING
,      REFUND_FORMULA_ID
,      REFUND_FORMULA_NAME
,      REFUND_FORMULA_DESCR
,      STREAM_TYPE_ID
,      STREAM_TYPE_CODE
,      STREAM_TYPE_DESCR
,      RECEIPT_METHOD_CODE
,      RECEIPT_METHOD_MEANING
,      CUST_VISIBLE_YN_CODE
,      CUST_VISIBLE_YN_MEANING
,      MAXIMUM_FINANCED_AMOUNT
,      MAXIMUM_SUBSIDY_AMOUNT
,      TRANSFER_BASIS_CODE
,      SUBSIDY_POOL_NAME
,      POOL_ID
,      SUBSIDY_POOL_STATUS_MEANING
,      DECISION_STATUS_CODE
FROM APPS.OKL_SUBSIDIES_UV;

Dependencies

[top of page]

APPS.OKL_SUBSIDIES_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_OPERATING_UNITS; OKL_FORMULAE_B; OKL_FORMULAE_TL; OKL_STRM_TYPE_B; OKL_STRM_TYPE_TL; OKL_SUBSIDIES_B; OKL_SUBSIDIES_TL; OKL_SUBSIDY_POOLS_B; PO_VENDORS

APPS.OKL_SUBSIDIES_UV is not referenced by any database object