DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_JOURNAL_COMBINATIONS_V

Object Details
Object Name: XTR_JOURNAL_COMBINATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_JOURNAL_COMBINATIONS_V
Subobject Name:
Status: VALID

View Type

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


XTR_JOURNAL_COMBINATIONS_V contains your defined journal combinations. One row contains the company, deal type, deal subtype, product type, and portfolio for a journal entry action.
This table is used to set the default values for a new journal entry action that has the same company, deal type, and deal subtype information as an existing journal entry action.
This view corresponds to the Available Journals for Copy window in the Journal Structure tabbed region of the Journal Entry Actions window.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_CODE VARCHAR2 (7) Yes Company code
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
USER_DEAL_TYPE VARCHAR2 (7) Yes User-defined deal type code
DEAL_SUBTYPE VARCHAR2 (7) Yes Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE VARCHAR2 (7) Yes User-defined deal subtype code
PRODUCT_TYPE VARCHAR2 (10)
Code for products used in a deal type
PORTFOLIO_CODE VARCHAR2 (7)
Code for grouping deals under a single portfolio
Query Text

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


SELECT COMPANY_CODE
,      DEAL_TYPE
,      USER_DEAL_TYPE
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
FROM APPS.XTR_JOURNAL_COMBINATIONS_V;

Dependencies

[top of page]

APPS.XTR_JOURNAL_COMBINATIONS_V references the following:

SchemaAPPS
SynonymXTR_DEAL_SUBTYPES
SynonymXTR_DEAL_TYPES
SynonymXTR_JOURNAL_ENTRY_ACTIONS

APPS.XTR_JOURNAL_COMBINATIONS_V is not referenced by any database object