[Home] [Help]
View: XTR_GROUP_LIMITS_V
View Text
SELECT GL.COMPANY_CODE
, GL.LIMIT_TYPE
, GL.CPARTY_CODE
, GL.CREATED_BY
, GL.CREATED_ON
, GL.LIMIT_AMOUNT
, GL.EXPIRY_DATE
, GL.UPDATED_BY
, GL.UPDATED_ON
, GL.AUTHORISED
, GL.AUDIT_INDICATOR
, GL.UTILISED_AMOUNT
FROM XTR_GROUP_LIMITS GL WHERE GL.COMPANY_CODE IN (SELECT CA.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES CA
, XTR_DEALER_CODES DC WHERE GL.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
Name |
COMPANY_CODE |
LIMIT_TYPE |
CPARTY_CODE |
CREATED_BY |
CREATED_ON |
LIMIT_AMOUNT |
EXPIRY_DATE |
UPDATED_BY |
UPDATED_ON |
AUTHORISED |
AUDIT_INDICATOR |
UTILISED_AMOUNT |