Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_EXPOSURE_TYPES_V |
SELECT ET.COMPANY_CODE
, ET.EXPOSURE_TYPE
, ET.NAME
, ET.FREQUENCY
, ET.CODE_COMBINATION_ID
, ET.TAX_BROKERAGE_TYPE
, ET.TAX_OR_BROKERAGE
, ET.UPDATED_BY
, ET.UPDATED_ON
, ET.AUDIT_INDICATOR
, ET.LAST_DOWNLOAD_DATE
, ET.BALANCE_SHEET_EXPOSURE
, ET.CREATED_BY
, ET.CREATED_ON FROM XTR_EXPOSURE_TYPES ET WHERE ET.COMPANY_CODE IN (SELECT CA.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES CA
, XTR_DEALER_CODES DC WHERE ET.COMPANY_CODE = CA.PARTY_CODE AND CA.DEALER_CODE = DC.DEALER_CODE AND CA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' AND DC.USER_ID = FND_GLOBAL.USER_ID)