VIEW: APPS.XTR_GAIN_LOSS_DNM_V

Source

View Text - Preformatted

SELECT xgl.GAIN_LOSS_DNM_ID, xgl.CREATED_BY, xgl.CREATION_DATE, xgl.LAST_UPDATED_BY, xgl.LAST_UPDATE_DATE, xgl.LAST_UPDATE_LOGIN, xgl.BATCH_ID, xgl.COMPANY_CODE, xgl.DEAL_NUMBER, xgl.TRANSACTION_NUMBER, xgl.DATE_TYPE, xgl.AMOUNT, xgl.AMOUNT_TYPE, xgl.ACTION, xgl.CURRENCY, xgl.JOURNAL_DATE, xgl.REVAL_EFF_FLAG from XTR_GAIN_LOSS_DNM xgl WHERE xgl.COMPANY_CODE IN ( select xca.PARTY_CODE from XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc where xgl.COMPANY_CODE = xca.PARTY_CODE and xca.DEALER_CODE = xdc.dealer_code and xca.COMPANY_AUTHORISED_FOR_INPUT = 'Y' and xdc.USER_ID = FND_GLOBAL.USER_ID)

View Text - HTML Formatted

SELECT XGL.GAIN_LOSS_DNM_ID
, XGL.CREATED_BY
, XGL.CREATION_DATE
, XGL.LAST_UPDATED_BY
, XGL.LAST_UPDATE_DATE
, XGL.LAST_UPDATE_LOGIN
, XGL.BATCH_ID
, XGL.COMPANY_CODE
, XGL.DEAL_NUMBER
, XGL.TRANSACTION_NUMBER
, XGL.DATE_TYPE
, XGL.AMOUNT
, XGL.AMOUNT_TYPE
, XGL.ACTION
, XGL.CURRENCY
, XGL.JOURNAL_DATE
, XGL.REVAL_EFF_FLAG
FROM XTR_GAIN_LOSS_DNM XGL
WHERE XGL.COMPANY_CODE IN ( SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
WHERE XGL.COMPANY_CODE = XCA.PARTY_CODE
AND XCA.DEALER_CODE = XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID = FND_GLOBAL.USER_ID)