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_UV

Object Details

Object Name:	OKL_SUBSIDY_CRITERIA_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SUBSIDY_CRITERIA_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 criteria
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
DISPLAY_SEQUENCE	NUMBER	(4)		display sequence number
SUBSIDY_ID	NUMBER		Yes	Unique identifier for subsidy
SUBSIDY_NAME	VARCHAR2	(30)	Yes	Subsidy name
SUBSIDY_SHORT_DESCRIPTION	VARCHAR2	(150)		Subsidy short description
INVENTORY_ITEM_ID	NUMBER			Invnetory item identifier for which the subsidy is applicable
INVENTORY_ORG_ID	NUMBER			Inventory organization identifier for which the subsidy is applicable
INVENTORY_ITEM_NAME	VARCHAR2	(240)		Invnetory item name
INVENTORY_ITEM_CODE	VARCHAR2	(40)		Inventory item code
INVENTORY_ORG_NAME	VARCHAR2	(240)		Inventory organization name
INVENTORY_ORG_CODE	VARCHAR2	(3)		Inventory organization code
CREDIT_CLASSIFICATION_CODE	VARCHAR2	(30)		Credit classification code
CREDIT_CLASS_MEANING	VARCHAR2	(80)		Credit classification meaning
SALES_TERRITORY_ID	NUMBER			Sales territory identifier
TERRITORY_CONCAT_SEGMENTS	VARCHAR2	(519)		Sales territory concatenated segments
TERRITORY_NAME	VARCHAR2	(40)		Sales territory name
TERRITORY_DESCRIPTION	VARCHAR2	(240)		Sales territory description
PRODUCT_ID	NUMBER			Product identifier
PRODUCT_NAME	VARCHAR2	(150)		Product name
PRODUCT_DESCRIPTION	VARCHAR2	(1995)		Product description
INDUSTRY_CODE_TYPE	VARCHAR2	(30)		Industry code type
IND_CODE_TYPE_MEANING	VARCHAR2	(80)		Industry code type meaning
INDUSTRY_CODE	VARCHAR2	(30)		Industry code
INDUSTRY_CODE_MEANING	VARCHAR2	(80)		Industry code meaning
CURRENCY_CODE	VARCHAR2	(15)		Subsidy currency code

Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      DISPLAY_SEQUENCE
,      SUBSIDY_ID
,      SUBSIDY_NAME
,      SUBSIDY_SHORT_DESCRIPTION
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_CODE
,      INVENTORY_ORG_NAME
,      INVENTORY_ORG_CODE
,      CREDIT_CLASSIFICATION_CODE
,      CREDIT_CLASS_MEANING
,      SALES_TERRITORY_ID
,      TERRITORY_CONCAT_SEGMENTS
,      TERRITORY_NAME
,      TERRITORY_DESCRIPTION
,      PRODUCT_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      INDUSTRY_CODE_TYPE
,      IND_CODE_TYPE_MEANING
,      INDUSTRY_CODE
,      INDUSTRY_CODE_MEANING
,      CURRENCY_CODE
FROM APPS.OKL_SUBSIDY_CRITERIA_UV;

Dependencies

[top of page]

APPS.OKL_SUBSIDY_CRITERIA_UV references the following:

APPS: AR_LOOKUPS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_B_KFV; OKL_PRODUCTS; OKL_SUBSIDIES_B; OKL_SUBSIDIES_TL; OKL_SUBSIDY_CRITERIA; ORG_ORGANIZATION_DEFINITIONS; RA_TERRITORIES

APPS.OKL_SUBSIDY_CRITERIA_UV is not referenced by any database object