View: CE_JE_MAPPINGS_V

Product:	CE - Cash Management
Description:	View on CE_JE_MAPPINGS to simply Forms coding
Implementation/DBA Data:	APPS.CE_JE_MAPPINGS_V

View Text

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'

Columns