VIEW: APPS.XTR_ONE_STEP_SETTLE_CODES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)