Product: | JE - European Localizations |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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)