VIEW: APPS.XTR_LIMIT_EXCESS_LOG_DETAILS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)