VIEW: APPS.XTR_MIRROR_DDA_LIMIT_ROW_V

Source

View Text - Preformatted

SELECT xd.DEAL_NUMBER, xd.DEAL_TYPE, xd.TRANSACTION_NUMBER, xd.LIMIT_CODE, xd.AMOUNT, xd.HCE_AMOUNT, xd.DATE_LAST_SET, xd.PRODUCT_TYPE, xd.COMPANY_CODE, xd.LIMIT_PARTY, xd.AMOUNT_DATE, xd.DEALER_CODE, xd.COUNTRY_CODE, xd.DEAL_SUBTYPE, xd.PORTFOLIO_CODE, xd.STATUS_CODE, xd.CURRENCY, xd.UTILISED_AMOUNT, xd.HCE_UTILISED_AMOUNT, xd.CROSS_REF_TO_OTHER_PARTY, xd.LIMIT_TYPE, xd.COMMENCE_DATE, xd.CURRENCY_COMBINATION, xd.CONTRA_CCY, xd.TRANSACTION_RATE, xd.AMOUNT_INDIC, xd.ACCOUNT_NO from XTR_MIRROR_DDA_LIMIT_ROW xd where company_code in (select xca.party_code from XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc where xd.company_code = xca.party_code and xca.dealer_code = xdc.dealer_code and xca.company_authorised_for_input = 'Y' and xdc.user_id = fnd_global.user_id)

View Text - HTML Formatted

SELECT XD.DEAL_NUMBER
, XD.DEAL_TYPE
, XD.TRANSACTION_NUMBER
, XD.LIMIT_CODE
, XD.AMOUNT
, XD.HCE_AMOUNT
, XD.DATE_LAST_SET
, XD.PRODUCT_TYPE
, XD.COMPANY_CODE
, XD.LIMIT_PARTY
, XD.AMOUNT_DATE
, XD.DEALER_CODE
, XD.COUNTRY_CODE
, XD.DEAL_SUBTYPE
, XD.PORTFOLIO_CODE
, XD.STATUS_CODE
, XD.CURRENCY
, XD.UTILISED_AMOUNT
, XD.HCE_UTILISED_AMOUNT
, XD.CROSS_REF_TO_OTHER_PARTY
, XD.LIMIT_TYPE
, XD.COMMENCE_DATE
, XD.CURRENCY_COMBINATION
, XD.CONTRA_CCY
, XD.TRANSACTION_RATE
, XD.AMOUNT_INDIC
, XD.ACCOUNT_NO
FROM XTR_MIRROR_DDA_LIMIT_ROW XD
WHERE COMPANY_CODE IN (SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
WHERE XD.COMPANY_CODE = XCA.PARTY_CODE
AND XCA.DEALER_CODE = XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID = FND_GLOBAL.USER_ID)