FND Design Data [Home] [Help]

View: JE_ES_REMITTED_RECEIPTS_V

Product: JE - European Localizations
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT CR.RECEIPT_NUMBER
, CR.CURRENCY_CODE
, CR.AMOUNT
, CR.RECEIPT_DATE
, NVL(PS.DUE_DATE
, CR.DEPOSIT_DATE)
, RM.PRINTED_NAME
, CR.EXCHANGE_RATE
, C.CUSTOMER_NAME
, C.CUSTOMER_NUMBER
, CBAB.BANK_NAME
, CBAB.BANK_BRANCH_NAME
, CBAB.BANK_NUM
, CBAB.BANK_NUMBER
, CBA.BANK_ACCOUNT_NAME
, CBA.BANK_ACCOUNT_NUM
, CBA.CHECK_DIGITS
, RBAB.BANK_NAME
, RBA.BANK_ACCOUNT_ID
, RBAB.BANK_BRANCH_NAME
, RBAB.BANK_NUM
, RBAB.BANK_NUMBER
, RBA.BANK_ACCOUNT_NAME
, RBA.BANK_ACCOUNT_NUM
, RBA.CHECK_DIGITS
, B.NAME
, B.BATCH_DATE
, LK.MEANING
, B.BATCH_ID
FROM AR_CASH_RECEIPTS CR
, AR_BATCHES B
, AR_LOOKUPS LK
, RA_CUSTOMERS C
, AR_RECEIPT_METHODS RM
, AP_BANK_ACCOUNTS CBA
, AP_BANK_BRANCHES CBAB
, AP_BANK_ACCOUNTS RBA
, AP_BANK_BRANCHES RBAB
, AR_PAYMENT_SCHEDULES PS
WHERE CR.PAY_FROM_CUSTOMER = C.CUSTOMER_ID(+)
AND CR.CUSTOMER_BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID(+)
AND CBA.BANK_BRANCH_ID = CBAB.BANK_BRANCH_ID(+)
AND CR.REMITTANCE_BANK_ACCOUNT_ID = RBA.BANK_ACCOUNT_ID
AND RBA.BANK_BRANCH_ID = RBAB.BANK_BRANCH_ID
AND CR.CASH_RECEIPT_ID = PS.CASH_RECEIPT_ID(+)
AND LK.LOOKUP_TYPE(+) = 'REMITTANCE_METHOD'
AND LK.LOOKUP_CODE(+) = B.REMIT_METHOD_CODE
AND RM.RECEIPT_METHOD_ID = CR.RECEIPT_METHOD_ID
AND (B.BATCH_ID = (SELECT DISTINCT CRH.BATCH_ID
FROM AR_CASH_RECEIPT_HISTORY CRH
WHERE CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
AND CRH.STATUS = 'REMITTED') OR CR.SELECTED_REMITTANCE_BATCH_ID = B.BATCH_ID)

Columns

Name
RECEIPT_NUMBER
RECEIPT_CURRENCY
RECEIPT_AMOUNT
RECEIPT_DATE
MATURITY_DATE
PAYMENT_METHOD
RECEIPT_EXCHANGE_RATE
CUSTOMER_NAME
CUSTOMER_NUMBER
CUSTOMER_BANK_NAME
CUSTOMER_BANK_BRANCH_NAME
CUSTOMER_BANK_BRANCH_NUM
CUSTOMER_BANK_BRANCH_NUMBER
CUSTOMER_BANK_ACCOUNT_NAME
CUSTOMER_BANK_ACCOUNT_NUMBER
CUSTOMER_BANK_CHECK_DIGITS
REMIT_BANK_NAME
REMIT_BANK_ACCOUNT_ID
REMIT_BANK_BRANCH_NAME
REMIT_BANK_BRANCH_NUM
REMIT_BANK_BRANCH_NUMBER
REMIT_BANK_ACCOUNT_NAME
REMIT_BANK_ACCOUNT_NUMBER
REMIT_BANK_CHECK_DIGITS
REMIT_BATCH_NAME
REMIT_BATCH_DATE
REMIT_BATCH_REMIT_METHOD
REMIT_BATCH_ID