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_SUBSIDY_CRITERIA_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view stores applicability criteria for a subsidy.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Internal unique identifier for the record
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	Subsidy identifier. Foreign key to OKL_SUBSIDIES_B
DISPLAY_SEQUENCE	NUMBER	(4)		Display sequence
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier for which the subsidy is applicable
ORGANIZATION_ID	NUMBER			Inventory organization identifier for which the subsidy is applicable
CREDIT_CLASSIFICATION_CODE	VARCHAR2	(30)		Customer credit classification code for which the subsidy is applicable
SALES_TERRITORY_CODE	VARCHAR2	(2)		Sales territory code for which the subsidy is applicable
PRODUCT_ID	NUMBER			Financial product identifier for which the subsidy is applicable
INDUSTRY_CODE_TYPE	VARCHAR2	(30)		Industry code type
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)		Descriptive Flexfield category
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield attribute
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield attribute
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

Query Text

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


SELECT ROW_ID
,      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 APPS.OKL_SUBSIDY_CRITERIA_V;

Dependencies

[top of page]

APPS.OKL_SUBSIDY_CRITERIA_V references the following:

APPS: OKL_SUBSIDY_CRITERIA

APPS.OKL_SUBSIDY_CRITERIA_V is referenced by following:

APPS: OKL_SUC_PVT - show dependent code; OKL_SUC_PVT - show dependent code