View: CE_TRANSACTION_CODES_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_TRANSACTION_CODES_V

View Text

SELECT ABA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, ABA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, ABA.CURRENCY_CODE BANK_ACCOUNT_CURRENCY_CODE
, ABB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, ABB.BANK_NAME BANK_NAME
, TC.ROWID ROW_ID
, TC.TRANSACTION_CODE_ID TRANSACTION_CODE_ID
, TC.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, TC.TRX_TYPE TYPE
, L1.MEANING TYPE_DSP
, TC.TRX_CODE TRX_CODE
, TC.DESCRIPTION DESCRIPTION
, TC.CREATE_MISC_TRX_FLAG CREATE_MISC_TRX_FLAG
, TC.RECONCILE_FLAG RECONCILE_FLAG
, TC.FLOAT_DAYS FLOAT_DAYS
, L2.MEANING CREATE_MISC_TRX_FLAG_DSP
, TC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TC.ATTRIBUTE1 ATTRIBUTE1
, TC.ATTRIBUTE2 ATTRIBUTE2
, TC.ATTRIBUTE3 ATTRIBUTE3
, TC.ATTRIBUTE4 ATTRIBUTE4
, TC.ATTRIBUTE5 ATTRIBUTE5
, TC.ATTRIBUTE6 ATTRIBUTE6
, TC.ATTRIBUTE7 ATTRIBUTE7
, TC.ATTRIBUTE8 ATTRIBUTE8
, TC.ATTRIBUTE9 ATTRIBUTE9
, TC.ATTRIBUTE10 ATTRIBUTE10
, TC.ATTRIBUTE11 ATTRIBUTE11
, TC.ATTRIBUTE12 ATTRIBUTE12
, TC.ATTRIBUTE13 ATTRIBUTE13
, TC.ATTRIBUTE14 ATTRIBUTE14
, TC.ATTRIBUTE15 ATTRIBUTE15
, TC.LAST_UPDATED_BY LAST_UPDATED_BY
, TC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TC.CREATED_BY CREATED_BY
, TC.CREATION_DATE CREATION_DATE
, ART.NAME RECEIVABLES_ACTIVITY
, TC.RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, RM.NAME PAYMENT_METHOD
, RM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, TC.MATCHING_AGAINST MATCHING_AGAINST
, TC.CORRECTION_METHOD CORRECTION_METHOD
, TC.START_DATE START_DATE
, TC.END_DATE END_DATE
, L3.MEANING RECONCILE_FLAG_DSP
, TC.PAYROLL_PAYMENT_FORMAT_ID PAYROLL_PAYMENT_FORMAT_ID
, PPTT.PAYMENT_TYPE_NAME PAYROLL_PAYMENT_FORMAT_DSP
, L4.MEANING PAYROLL_MATCHING_ODER
, TC.RECONCILIATION_SEQUENCE
FROM CE_BANK_BRANCHES_V ABB
, CE_BANK_ACCOUNTS_V ABA
, AR_RECEIVABLES_TRX_ALL ART
, AR_RECEIPT_METHODS RM
, FND_LOOKUPS L2
, CE_LOOKUPS L1
, CE_LOOKUPS L3
, HR_LOOKUPS L4
, PAY_PAYMENT_TYPES PPT
, PAY_PAYMENT_TYPES_TL PPTT
, CE_TRANSACTION_CODES TC
WHERE ABB.BRANCH_PARTY_ID = ABA.BANK_BRANCH_ID AND ABA.BANK_ACCOUNT_ID = TC.BANK_ACCOUNT_ID AND RM.RECEIPT_METHOD_ID(+) = TC.RECEIPT_METHOD_ID AND ART.RECEIVABLES_TRX_ID(+) = TC.RECEIVABLES_TRX_ID AND L1.LOOKUP_TYPE = 'BANK_TRX_TYPE' AND L1.LOOKUP_CODE = TC.TRX_TYPE AND L2.LOOKUP_TYPE = 'YES_NO' AND L2.LOOKUP_CODE = NVL(TC.CREATE_MISC_TRX_FLAG
, 'N')
AND L3.LOOKUP_TYPE(+) = 'TRX_CODE_RECON_FLAG' AND L3.LOOKUP_CODE(+) = TC.RECONCILE_FLAG AND PPT.PAYMENT_TYPE_ID (+) = TC.PAYROLL_PAYMENT_FORMAT_ID
AND PPT.PAYMENT_TYPE_ID = PPTT.PAYMENT_TYPE_ID (+)
AND PPTT.LANGUAGE (+) = USERENV('LANG') AND PPT.PAYMENT_TYPE_NAME = L4.LOOKUP_CODE (+)
AND L4.LOOKUP_TYPE(+) = 'PAYMENT_TRX_CONC_IDENTS' ORDER BY L1.MEANING
, TC.TRX_CODE
, L3.MEANING
, TC.RECONCILIATION_SEQUENCE

Columns