View: XTR_ONE_STEP_SETTLE_CODES_V

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

View Text

SELECT ONE_STEP_ID
, COMPANY_CODE
, SCHEDULE
, SETTLEMENT_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM XTR_ONE_STEP_SETTLE_CODES
WHERE COMPANY_CODE IN (SELECT CA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES CA
, XTR_DEALER_CODES DC
WHERE 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