VIEW: APPS.XTR_REVIEW_JOURNALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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