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.PAYBV_ELEMENT_CLASSIFICATION_V

Object Details

Object Name:	PAYBV_ELEMENT_CLASSIFICATION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAYBV_ELEMENT_CLASSIFICATION_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory
CLASSIFICATION_NAME	VARCHAR2	(80)	Yes
DESCRIPTION	VARCHAR2	(80)
COSTABLE_FLAG_M	VARCHAR2	(4000)
COSTING_DEBIT_OR_CREDIT_M	VARCHAR2	(4000)
DISTRIBUTABLE_OVER_FLAG_M	VARCHAR2	(4000)
NON_PAYMENTS_FLAG_M	VARCHAR2	(4000)
CREATE_BY_DEFAULT_FLAG_M	VARCHAR2	(4000)
BALANCE_INITIALIZATION_FLAG_M	VARCHAR2	(4000)
DEFAULT_HIGH_PRIORITY	NUMBER	(9)
DEFAULT_LOW_PRIORITY	NUMBER	(9)
DEFAULT_PRIORITY	NUMBER	(9)
COSTABLE_FLAG	VARCHAR2	(30)
COSTING_DEBIT_OR_CREDIT	VARCHAR2	(30)
DISTRIBUTABLE_OVER_FLAG	VARCHAR2	(30)
NON_PAYMENTS_FLAG	VARCHAR2	(30)
CREATE_BY_DEFAULT_FLAG	VARCHAR2	(30)
BALANCE_INITIALIZATION_FLAG	VARCHAR2	(30)
FREQ_RULE_ENABLED	VARCHAR2	(30)
LEGISLATION_SUBGROUP	VARCHAR2	(30)
LEGISLATION_CODE	VARCHAR2	(30)
BUSINESS_GROUP_ID	NUMBER	(15)
CLASSIFICATION_ID	NUMBER	(9)	Yes
PARENT_CLASSIFICATION_ID	NUMBER	(9)
OBJECT_VERSION_NUMBER	NUMBER	(9)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
BG_SECURITY_FLAG_CODE	CHAR	(1)

Query Text

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


SELECT CLASSIFICATION_NAME
,      DESCRIPTION
,      COSTABLE_FLAG_M
,      COSTING_DEBIT_OR_CREDIT_M
,      DISTRIBUTABLE_OVER_FLAG_M
,      NON_PAYMENTS_FLAG_M
,      CREATE_BY_DEFAULT_FLAG_M
,      BALANCE_INITIALIZATION_FLAG_M
,      DEFAULT_HIGH_PRIORITY
,      DEFAULT_LOW_PRIORITY
,      DEFAULT_PRIORITY
,      COSTABLE_FLAG
,      COSTING_DEBIT_OR_CREDIT
,      DISTRIBUTABLE_OVER_FLAG
,      NON_PAYMENTS_FLAG
,      CREATE_BY_DEFAULT_FLAG
,      BALANCE_INITIALIZATION_FLAG
,      FREQ_RULE_ENABLED
,      LEGISLATION_SUBGROUP
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      CLASSIFICATION_ID
,      PARENT_CLASSIFICATION_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.PAYBV_ELEMENT_CLASSIFICATION_V;

Dependencies

[top of page]

APPS.PAYBV_ELEMENT_CLASSIFICATION_V references the following:

APPS: HR_BIS - show dependent code; PAY_ELEMENT_CLASSIFICATIONS_VL

APPS.PAYBV_ELEMENT_CLASSIFICATION_V is not referenced by any database object