View: XTR_REVIEW_JOURNALS_V

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

View Text

SELECT JNL.ROWID AS ROW_ID
, JNL.BATCH_ID
, JNL.COMPANY_CODE
, JNL.JOURNAL_DATE
, JNL.DEAL_NUMBER
, JNL.TRANSACTION_NUMBER
, JNL.DEAL_TYPE
, JNL.DEAL_SUBTYPE
, JNL.AMOUNT_TYPE
, JNL.DEBIT_AMOUNT
, JNL.CREDIT_AMOUNT
, JNL.CODE_COMBINATION_ID
, JNL.COMMENTS
, JNL.JNL_REVERSAL_IND
, JNL.CANCELLED_IN_GL
, JNL.CREATED_BY
, JNL.CREATED_ON
, JNL.UPDATED_BY
, JNL.UPDATED_ON
, JNL.PRODUCT_TYPE
, JNL.PORTFOLIO_CODE
, JNL.AUDIT_INDICATOR
, JNL.CURRENCY
, JNL.TRANSFER_TO_EXTERNAL_GL
, JNL.SET_OF_BOOKS_ID
, JNL.SUSPENSE_GL
, JNL.ACCOUNTED_DR
, JNL.ACCOUNTED_CR
, JNL.GL_SL_LINK_ID
, JNL.SETTLEMENT_NUMBER
, JNL.ORIG_JOURNAL_DATE
, JNL.ALT_JOURNAL_DATE
, JNL.DATE_TYPE
, DT.USER_DATE_TYPE
, JNL.ACTION_CODE
, AA.USER_ACTION_CODE
, AT.USER_AMOUNT_TYPE
, BA.BATCH_TYPE
FROM XTR_JOURNALS JNL
, XTR_DATE_TYPES DT
, XTR_AMOUNT_TYPES AT
, XTR_AMOUNT_ACTIONS AA
, XTR_BATCHES BA
WHERE JNL.DEAL_TYPE = DT.DEAL_TYPE (+)
AND JNL.DATE_TYPE = DT.DATE_TYPE (+)
AND JNL.DEAL_TYPE = AT.DEAL_TYPE (+)
AND JNL.AMOUNT_TYPE = AT.AMOUNT_TYPE (+)
AND JNL.DEAL_TYPE = AA.DEAL_TYPE (+)
AND JNL.AMOUNT_TYPE = AA.AMOUNT_TYPE (+)
AND JNL.ACTION_CODE = AA.ACTION_CODE (+)
AND JNL.BATCH_ID = BA.BATCH_ID

Columns