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

Object Details

Object Name:	XTR_TY_SUB_PRD_PORT_COMBIN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_TY_SUB_PRD_PORT_COMBIN_V
Subobject Name:
Status:	VALID

View Type

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

XTR_TY_SUB_PRD_PORT_COMBIN_V shows all permutations of authorized deal type, deal subtype, product type and portfolio. This view is used in setting up XTR_JOURNAL_ENTRY_ACTIONS.
This view corresponds to the single-row block of the Journal Structures tab on the Journal Entry Actions window.

[View Source]

Columns

Name	Datatype	Length	Comments
DEAL_TYPE	VARCHAR2	(7)	Code for high level deals
USER_DEAL_TYPE	VARCHAR2	(7)	User-defined deal type code
DEAL_SUBTYPE	VARCHAR2	(7)	Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE	VARCHAR2	(7)	User-defined deal subtype code
PRODUCT_TYPE	VARCHAR2	(10)	Code for user defined product type
COMPANY_CODE	VARCHAR2	(7)	Company code
PORTFOLIO	VARCHAR2	(7)	Code for grouping deals under a single portfolio

Query Text

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


SELECT DEAL_TYPE
,      USER_DEAL_TYPE
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT_TYPE
,      COMPANY_CODE
,      PORTFOLIO
FROM APPS.XTR_TY_SUB_PRD_PORT_COMBIN_V;

Dependencies

[top of page]

APPS.XTR_TY_SUB_PRD_PORT_COMBIN_V references the following:

APPS: XTR_AUTH_TYPE_SUBTYPE_PROD; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_PORTFOLIOS

APPS.XTR_TY_SUB_PRD_PORT_COMBIN_V is not referenced by any database object