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_PRODUCT_PARAMETERS_ALL_V

Object Details

Object Name:	OKL_PRODUCT_PARAMETERS_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_PRODUCT_PARAMETERS_ALL_V
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	Comments
ID	NUMBER		Primary key column
NAME	VARCHAR2	(150)	Name of the product
PRODUCT_SUBCLASS	VARCHAR2	(150)	Product classification
DEAL_TYPE	VARCHAR2	(150)	Deal type for a given product
DEAL_TYPE_MEANING	VARCHAR2	(4000)	Returns the meaning of a given Deal Type
DEAL_TYPE_DESCRIPTION	VARCHAR2	(1995)	Deal type description
TAX_OWNER	VARCHAR2	(150)	Tax owner for a given product
TAX_OWNER_MEANING	VARCHAR2	(4000)	Returns the meaning of a given Tax Owner
TAX_OWNER_DESCRIPTION	VARCHAR2	(1995)	Tax owner description for a given product
REPORTING_PDT_ID	NUMBER		Reporting Product Identifier
REPORTING_PRODUCT	VARCHAR2	(150)	Reporting product name
PTL_ID	NUMBER		Foreign key to table OKL_PDT_TEMPLATES
VERSION	VARCHAR2	(24)	Version of a local product
DESCRIPTION	VARCHAR2	(1995)	Description of a product
FROM_DATE	DATE		From Date for a local product
TO_DATE	DATE		To Date for a local product
AES_ID	NUMBER		Foreign key to table OKL_AE_TMPT_SETS
AES_NAME	VARCHAR2	(150)	Accounting Template Set Name
AES_ORG_ID	NUMBER	(15)	Accounting Template Set operating unit
OBJECT_VERSION_NUMBER	NUMBER	(9)	Object Version Number
LEGACY_PRODUCT_YN	VARCHAR2	(3)	Flag to indicate if the product is legacy product or not
PRODUCT_STATUS_CODE	VARCHAR2	(30)	Product status code, that says if the product is valid or not.
PRODUCT_STATUS_MEANING	VARCHAR2	(4000)	Product status meaning
REVENUE_RECOGNITION_METHOD	VARCHAR2	(150)	Revenue Recognition Method
REVENUE_RECOGNITION_MEANING	VARCHAR2	(4000)	Revenue Recognition Meaning
INTEREST_CALCULATION_BASIS	VARCHAR2	(150)	Interest Calculation Basis
INTEREST_CALCULATION_MEANING	VARCHAR2	(4000)	Interest Calculation Meaning

Query Text

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


SELECT ID
,      NAME
,      PRODUCT_SUBCLASS
,      DEAL_TYPE
,      DEAL_TYPE_MEANING
,      DEAL_TYPE_DESCRIPTION
,      TAX_OWNER
,      TAX_OWNER_MEANING
,      TAX_OWNER_DESCRIPTION
,      REPORTING_PDT_ID
,      REPORTING_PRODUCT
,      PTL_ID
,      VERSION
,      DESCRIPTION
,      FROM_DATE
,      TO_DATE
,      AES_ID
,      AES_NAME
,      AES_ORG_ID
,      OBJECT_VERSION_NUMBER
,      LEGACY_PRODUCT_YN
,      PRODUCT_STATUS_CODE
,      PRODUCT_STATUS_MEANING
,      REVENUE_RECOGNITION_METHOD
,      REVENUE_RECOGNITION_MEANING
,      INTEREST_CALCULATION_BASIS
,      INTEREST_CALCULATION_MEANING
FROM APPS.OKL_PRODUCT_PARAMETERS_ALL_V;

Dependencies

[top of page]

APPS.OKL_PRODUCT_PARAMETERS_ALL_V references the following:

APPS: OKL_ACCOUNTING_UTIL - show dependent code; OKL_AE_TMPT_SETS_ALL; OKL_PDT_PQY_VALS; OKL_PDT_QUALITYS; OKL_PQY_VALUES; OKL_PQY_VALUES_V; OKL_PRODUCTS

APPS.OKL_PRODUCT_PARAMETERS_ALL_V is not referenced by any database object