Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_LIMIT_EXCESS_LOG_DETAILS_V |
SELECT LEL.AMOUNT_DATE
, LEL.AUTHORISED_BY
, LEL.COMPANY_CODE
, P.COUNTRY_CODE
, D.CURRENCY
, LEL.DEAL_NUMBER
, LEL.DEALER_CODE
, LEL.DUAL_AUTHORISED_BY
, LEL.DUAL_AUTHORISED_ON
, LEL.EXCEEDED_BY_AMOUNT
, LEL.EXCEEDED_ON_DATE
, LEL.EXCEPTION_TYPE
, LEL.HCE_AMOUNT
, LEL.LIMITING_AMOUNT
, LEL.LIMIT_CHECK_TYPE
, LEL.LIMIT_CODE
, CL.LIMIT_TYPE
, LT.FX_INVEST_FUND_TYPE
, LEL.LIMIT_PARTY
, LEL.LOG_ID
, LEL.TRANSACTION_NUMBER
FROM XTR_LIMIT_EXCESS_LOG LEL
, XTR_MIRROR_DDA_LIMIT_ROW D
, XTR_PARTY_INFO P
, XTR_COMPANY_LIMITS CL
, XTR_LIMIT_TYPES LT
WHERE LEL.DEAL_NUMBER = D.DEAL_NUMBER (+)
AND LEL.TRANSACTION_NUMBER = D.TRANSACTION_NUMBER (+)
AND LEL.LIMIT_PARTY = P.PARTY_CODE (+)
AND LEL.COMPANY_CODE = CL.COMPANY_CODE (+)
AND LEL.LIMIT_CODE = CL.LIMIT_CODE (+)
AND CL.LIMIT_TYPE = LT.LIMIT_TYPE (+)