[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 |
APPS.XTR_GROUP_LIMITS_V