View: XTR_TY_SUB_PRD_PORT_COMBIN_V

Product:	XTR - Treasury
Description:	All authorized deal type, deal subtype, product type, and portfolio combinations
Implementation/DBA Data:	APPS.XTR_TY_SUB_PRD_PORT_COMBIN_V

View Text

SELECT A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, B.COMPANY_CODE
, B.PORTFOLIO
FROM (SELECT DISTINCT DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
FROM XTR_AUTH_TYPE_SUBTYPE_PROD) A
, XTR_PORTFOLIOS B
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE A.DEAL_TYPE = DT.DEAL_TYPE
AND DT.DEAL_TYPE <> 'CA'
AND A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE UNION ALL SELECT DT.DEAL_TYPE
, DT.USER_DEAL_TYPE
, ST.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, 'NOT APPLIC'
, B.COMPANY_CODE
, B.PORTFOLIO
FROM XTR_PORTFOLIOS B
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE DT.DEAL_TYPE = 'CA'
AND DT.DEAL_TYPE = ST.DEAL_TYPE

Columns