VIEW: APPS.CE_JE_MAPPINGS_V

Source

View Text - Preformatted

SELECT JEM.ROWID ROW_ID, BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BA.CURRENCY_CODE CURRENCY_CODE, BB.BANK_BRANCH_NAME BANK_BRANCH_NAME, BB.BANK_NAME BANK_NAME, TC.TRX_CODE TRX_CODE, JEM.SEARCH_STRING_TXT SEARCH_STRING_TXT, JEM.GL_ACCOUNT_CCID GL_ACCOUNT_CCID, JEM.REFERENCE_TXT REFERENCE_TXT, TC.START_DATE START_DATE, TC.END_DATE END_DATE, BA.BANK_ACCOUNT_ID BANK_ACCOUNT_ID, JEM.TRX_CODE_ID TRX_CODE_ID, JEM.JE_MAPPING_ID JE_MAPPING_ID, JEM.TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID, SUB.TRANSACTION_SUB_TYPE_NAME TRANSACTION_SUB_TYPE_NAME, JEM.LAST_UPDATED_BY LAST_UPDATED_BY, JEM.LAST_UPDATE_DATE LAST_UPDATE_DATE, JEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, JEM.CREATED_BY CREATED_BY, JEM.CREATION_DATE CREATION_DATE FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB, CE_TRANSACTION_CODES TC, CE_JE_MAPPINGS JEM, CE_TRXNS_SUBTYPE_CODES SUB WHERE BA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID AND BA.BANK_ACCOUNT_ID = JEM.BANK_ACCOUNT_ID AND JEM.TRX_CODE_ID = TC.TRANSACTION_CODE_ID AND JEM.TRXN_SUBTYPE_CODE_ID = SUB.TRXN_SUBTYPE_CODE_ID(+) AND nvl(SUB.TRXN_SUBTYPE_STATUS(+), 'A') = 'A'

View Text - HTML Formatted

SELECT JEM.ROWID ROW_ID
, BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BA.CURRENCY_CODE CURRENCY_CODE
, BB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, BB.BANK_NAME BANK_NAME
, TC.TRX_CODE TRX_CODE
, JEM.SEARCH_STRING_TXT SEARCH_STRING_TXT
, JEM.GL_ACCOUNT_CCID GL_ACCOUNT_CCID
, JEM.REFERENCE_TXT REFERENCE_TXT
, TC.START_DATE START_DATE
, TC.END_DATE END_DATE
, BA.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, JEM.TRX_CODE_ID TRX_CODE_ID
, JEM.JE_MAPPING_ID JE_MAPPING_ID
, JEM.TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID
, SUB.TRANSACTION_SUB_TYPE_NAME TRANSACTION_SUB_TYPE_NAME
, JEM.LAST_UPDATED_BY LAST_UPDATED_BY
, JEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JEM.CREATED_BY CREATED_BY
, JEM.CREATION_DATE CREATION_DATE
FROM CE_BANK_ACCOUNTS BA
, CE_BANK_BRANCHES_V BB
, CE_TRANSACTION_CODES TC
, CE_JE_MAPPINGS JEM
, CE_TRXNS_SUBTYPE_CODES SUB
WHERE BA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID
AND BA.BANK_ACCOUNT_ID = JEM.BANK_ACCOUNT_ID
AND JEM.TRX_CODE_ID = TC.TRANSACTION_CODE_ID
AND JEM.TRXN_SUBTYPE_CODE_ID = SUB.TRXN_SUBTYPE_CODE_ID(+)
AND NVL(SUB.TRXN_SUBTYPE_STATUS(+)
, 'A') = 'A'