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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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

This view contains Stored transaction subtypes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER		Yes	The Unique Access Identifier
SUB_TYPE_ID	NUMBER		Yes	Sub Type Identifier
CS_TRANSACTION_TYPE_ID	NUMBER			Service Transaction Type Identifier
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction Type Identifier
SRC_REFERENCE_REQD	VARCHAR2	(1)		Flag if a Source Instance Referred needs to be required
SRC_CHANGE_OWNER	VARCHAR2	(1)		Flag if an Ownership needs to be change when performing the transaction
SRC_CHANGE_OWNER_TO_CODE	VARCHAR2	(1)		Code indicating if ownership change is required
SRC_STATUS_ID	NUMBER			Status Identifier that needs to be stamped on the Instance after processing the transaction
SRC_REVISION_REQD	VARCHAR2	(1)		Flag indicating if the Source Instance revision needs to be required
PARENT_REFERENCE_REQD	VARCHAR2	(1)		Flag indicating if the parent instance reference is required to process the transaction
UPDATE_IB_FLAG	VARCHAR2	(1)		Update Installed Base Flag
SRC_RETURN_REQD	VARCHAR2	(1)

Query Text

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


SELECT ACCESS_ID
,      SUB_TYPE_ID
,      CS_TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE_ID
,      SRC_REFERENCE_REQD
,      SRC_CHANGE_OWNER
,      SRC_CHANGE_OWNER_TO_CODE
,      SRC_STATUS_ID
,      SRC_REVISION_REQD
,      PARENT_REFERENCE_REQD
,      UPDATE_IB_FLAG
,      SRC_RETURN_REQD
FROM APPS.CSF_M_TXN_SUB_TYPES_V;

Dependencies

[top of page]

APPS.CSF_M_TXN_SUB_TYPES_V references the following:

APPS: CSI_IB_TXN_TYPES; CSI_INSTANCE_STATUSES; CSI_SOURCE_IB_TYPES; CSI_TXN_TYPES; CSM_IB_TXN_TYPES_ACC; CS_TRANSACTION_TYPES_B

APPS.CSF_M_TXN_SUB_TYPES_V is not referenced by any database object