VIEW: APPS.XTR_COMPANY_LIMITS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)