Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_COMPANY_LIMITS_V |
SELECT CL.COMPANY_CODE
, CL.LIMIT_CODE
, CL.LIMIT_TYPE
, CL.NAME
, CL.CREATED_BY
, CL.CREATED_ON
, CL.LIMIT_AMOUNT
, CL.UPDATED_BY
, CL.UPDATED_ON
, CL.AUTHORISED
, CL.AUDIT_INDICATOR
, CL.UTILISED_AMOUNT
, CL.ATTRIBUTE_CATEGORY
, CL.ATTRIBUTE1
, CL.ATTRIBUTE2
, CL.ATTRIBUTE3
, CL.ATTRIBUTE4
, CL.ATTRIBUTE5
, CL.ATTRIBUTE6
, CL.ATTRIBUTE7
, CL.ATTRIBUTE8
, CL.ATTRIBUTE9
, CL.ATTRIBUTE10
, CL.ATTRIBUTE11
, CL.ATTRIBUTE12
, CL.ATTRIBUTE13
, CL.ATTRIBUTE14
, CL.ATTRIBUTE15
FROM XTR_COMPANY_LIMITS CL
WHERE CL.COMPANY_CODE IN (SELECT CA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES CA
, XTR_DEALER_CODES DC
WHERE CL.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)