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

Object Details

Object Name:	CSL_CONTR_BUSS_TXN_TYPES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Mobile view on CSL_CONTR_BUSS_TXN_TYPES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			Indentifier to CSL_CONTR_BUSS_TXN_TYPES_ACC
INCIDENT_ID	NUMBER		Yes	Indentifier to CS_INCIDENTS_ALL_B
TXN_BILLING_TYPE_ID	NUMBER		Yes	The transaction billing type identifier.
BUSINESS_PROCESS_ID	NUMBER		Yes	Key to identify a transaction group
CONTRACT_SERVICE_ID	NUMBER		Yes	Indentifier to OKC_K_LINES_B.ID
UP_TO_AMOUNT	VARCHAR2	(30)		Covered up to amount
PERCENT_COVERED	VARCHAR2	(30)		Percentage covered

Query Text

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


SELECT ACCESS_ID
,      INCIDENT_ID
,      TXN_BILLING_TYPE_ID
,      BUSINESS_PROCESS_ID
,      CONTRACT_SERVICE_ID
,      UP_TO_AMOUNT
,      PERCENT_COVERED
FROM APPS.CSL_CONTR_BUSS_TXN_TYPES_V;

Dependencies

[top of page]

APPS.CSL_CONTR_BUSS_TXN_TYPES_V references the following:

APPS: ASG_BASE - show dependent code; CSL_CONTR_BUSS_TXN_TYPES; CSL_CONTR_BUSS_TXN_TYPES_ACC

APPS.CSL_CONTR_BUSS_TXN_TYPES_V is not referenced by any database object