View: XTR_DISC_JOURNALS_V

Product:	XTR - Treasury
Description:	Detailed journal entry information, where user access to company information is enforced.
Implementation/DBA Data:	APPS.XTR_DISC_JOURNALS_V

View Text

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

Columns