View: XTR_JOURNAL_COMBINATIONS_V

Product:	XTR - Treasury
Description:	All journal entry actions, deal type, and deal subtype combinations
Implementation/DBA Data:	APPS.XTR_JOURNAL_COMBINATIONS_V

View Text

SELECT DISTINCT A.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE FROM XTR_JOURNAL_ENTRY_ACTIONS A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)

Columns