View: XTR_COUNTERPARTY_LIMITS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_COUNTERPARTY_LIMITS_V

View Text

SELECT CL.COMPANY_CODE
, CL.LIMIT_CODE
, CL.CPARTY_CODE
, CL.CREATED_BY
, CL.CREATED_ON
, CL.LIMIT_AMOUNT
, CL.SEQUENCE_NUMBER
, CL.INITIAL_FEE_DATE
, CL.EXPIRY_DATE
, CL.UTILISATION_FEE_PERCENT
, CL.COMMITMENT_FEE_PERCENT
, CL.FREQUENCY
, CL.UPDATED_BY
, CL.UPDATED_ON
, CL.AUTHORISED
, CL.AUDIT_INDICATOR
, CL.LIMIT_TYPE
, CL.CROSS_ALLOCATION_GROUP_CODE
, CL.UTILISED_AMOUNT
, CL.UTILIZATION_STRUCTURE_BASIS
, CL.UTILISATION_CALC_BASIS
, CL.BENCHMARK_REF
, 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_COUNTERPARTY_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)

Columns