View: XTR_TY_SUB_PRD_COMBIN_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_TY_SUB_PRD_COMBIN_V

View Text

SELECT DISTINCT A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE FROM XTR_AUTH_TYPE_SUBTYPE_PROD A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.AUTHORISED = 'Y' AND A.USER_NAME IN (SELECT B.DEALER_CODE
FROM XTR_DEALER_CODES B WHERE B.USER_ID = FND_GLOBAL.USER_ID) AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)

Columns