VIEW: APPS.XTR_DISC_JOURNALS_V

Source

View Text - Preformatted

SELECT j.BATCH_ID, j.COMPANY_CODE, j.JOURNAL_DATE, j.DEAL_NUMBER, j.TRANSACTION_NUMBER, dt.USER_DEAL_TYPE, st.USER_DEAL_SUBTYPE, j.AMOUNT_TYPE, at.USER_AMOUNT_TYPE, j.DEBIT_AMOUNT, j.CREDIT_AMOUNT, cc.concatenated_segments, gr.treasury_reference, j.COMMENTS, j.JNL_REVERSAL_IND, j.CANCELLED_IN_GL, j.CREATED_BY, j.CREATED_ON, j.UPDATED_BY, j.UPDATED_ON, j.PRODUCT_TYPE, j.PORTFOLIO_CODE, j.AUDIT_INDICATOR, j.CURRENCY, j.TRANSFER_TO_EXTERNAL_GL, sob.NAME, j.SUSPENSE_GL, j.ACCOUNTED_DR, j.ACCOUNTED_CR, j.GL_SL_LINK_ID, j.SETTLEMENT_NUMBER, j.ORIG_JOURNAL_DATE, j.ALT_JOURNAL_DATE, j.DATE_TYPE, dat.USER_DATE_TYPE, j.ACTION_CODE, a.FULL_NAME, dt.NAME, st.NAME, at.AMOUNT_NAME, p.PRODUCT_DESC, dat.DATE_NAME FROM XTR_JOURNALS j, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st, XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc, XTR_AMOUNT_TYPES at, XTR_PARTY_INFO a, XTR_DATE_TYPES dat, XTR_PRODUCT_TYPES p, gl_sets_of_books sob, gl_code_combinations_kfv cc, xtr_gl_references gr WHERE dt.DEAL_TYPE = j.DEAL_TYPE and j.COMPANY_CODE = a.PARTY_CODE and (st.DEAL_TYPE = j.DEAL_TYPE and st.DEAL_SUBTYPE = j.DEAL_SUBTYPE) and (at.DEAL_TYPE(+) = j.DEAL_TYPE and at.AMOUNT_TYPE(+) = j.AMOUNT_TYPE) AND (P.DEAL_TYPE(+) = j.DEAL_TYPE and P.PRODUCT_TYPE(+) = j.PRODUCT_TYPE) AND (dat.DEAL_TYPE(+) = j.DEAL_TYPE and dat.DATE_TYPE(+) = j.DATE_TYPE) AND j.SET_OF_BOOKS_ID = sob.set_of_books_id AND cc.code_combination_id=j.code_combination_id AND gr.code_combination_id(+)=j.code_combination_id AND j.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 J.BATCH_ID
, J.COMPANY_CODE
, J.JOURNAL_DATE
, J.DEAL_NUMBER
, J.TRANSACTION_NUMBER
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE
, J.AMOUNT_TYPE
, AT.USER_AMOUNT_TYPE
, J.DEBIT_AMOUNT
, J.CREDIT_AMOUNT
, CC.CONCATENATED_SEGMENTS
, GR.TREASURY_REFERENCE
, J.COMMENTS
, J.JNL_REVERSAL_IND
, J.CANCELLED_IN_GL
, J.CREATED_BY
, J.CREATED_ON
, J.UPDATED_BY
, J.UPDATED_ON
, J.PRODUCT_TYPE
, J.PORTFOLIO_CODE
, J.AUDIT_INDICATOR
, J.CURRENCY
, J.TRANSFER_TO_EXTERNAL_GL
, SOB.NAME
, J.SUSPENSE_GL
, J.ACCOUNTED_DR
, J.ACCOUNTED_CR
, J.GL_SL_LINK_ID
, J.SETTLEMENT_NUMBER
, J.ORIG_JOURNAL_DATE
, J.ALT_JOURNAL_DATE
, J.DATE_TYPE
, DAT.USER_DATE_TYPE
, J.ACTION_CODE
, A.FULL_NAME
, DT.NAME
, ST.NAME
, AT.AMOUNT_NAME
, P.PRODUCT_DESC
, DAT.DATE_NAME
FROM XTR_JOURNALS J
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_AMOUNT_TYPES AT
, XTR_PARTY_INFO A
, XTR_DATE_TYPES DAT
, XTR_PRODUCT_TYPES P
, GL_SETS_OF_BOOKS SOB
, GL_CODE_COMBINATIONS_KFV CC
, XTR_GL_REFERENCES GR
WHERE DT.DEAL_TYPE = J.DEAL_TYPE
AND J.COMPANY_CODE = A.PARTY_CODE
AND (ST.DEAL_TYPE = J.DEAL_TYPE
AND ST.DEAL_SUBTYPE = J.DEAL_SUBTYPE)
AND (AT.DEAL_TYPE(+) = J.DEAL_TYPE
AND AT.AMOUNT_TYPE(+) = J.AMOUNT_TYPE)
AND (P.DEAL_TYPE(+) = J.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = J.PRODUCT_TYPE)
AND (DAT.DEAL_TYPE(+) = J.DEAL_TYPE
AND DAT.DATE_TYPE(+) = J.DATE_TYPE)
AND J.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND CC.CODE_COMBINATION_ID=J.CODE_COMBINATION_ID
AND GR.CODE_COMBINATION_ID(+)=J.CODE_COMBINATION_ID
AND J.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