/*以下两个票据已汇款 风险解除无法变更状态为“结清”,我查了一下,不是上次汇款日期的原因,请帮忙看一下是原因,谢谢!
25199928 30533658*/
/* BEGIN
mo_global.init('M');
END;*/
SELECT selected_remittance_batch_id,
RECEIPT_METHOD_NAME,
RECEIPT_NUMBER,
OVERRIDE_FLAG,
REMIT_BANK_ACCOUNT_NUMBER,
CUSTOMER_BANK_ACCOUNT_NUMBER,
RECEIPT_DATE,
MATURITY_DATE,
REMIT_BANK_NAME,
REMIT_BANK_BRANCH_NAME,
BANK_CHARGES,
CUSTOMER_BANK_NAME,
CUSTOMER_BANK_BRANCH_NAME,
CUSTOMER_NAME,
CUSTOMER_NUMBER,
ROW_ID,
REMITTANCE_BANK_BRANCH_ID,
REMITTANCE_BANK_ACCOUNT_ID,
CUSTOMER_BANK_ACCOUNT_ID,
CUSTOMER_BANK_BRANCH_ID,
BATCH_BANK_ACCOUNT_ID,
RECEIPT_METHOD_ID,
AMOUNT,
BATCH_ID,
REMIT_METHOD_CODE,
SELECTION_TYPE,
CURRENCY_CODE,
SELECTED_REMITTANCE_BATCH_ID,
PAY_FROM_CUSTOMER,
CUSTOMER_SITE_USE_ID,
CASH_RECEIPT_ID,
CASH_RECEIPT_HISTORY_ID,
PAYMENT_SCHEDULE_ID,
PAYMENT_TRXN_EXTENSION_ID,
PAYMENT_CHANNEL_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM AR_BOE_REMIT_RECEIPTS_NONCBR_V
where
/* WHERE (((selection_type in ('POTENTIAL_RECEIPTS_FOR_REMIT')) AND
(remittance_bank_account_id<> 10017 AND
batch_bank_account_id <> 10017) OR
(batch_bank_account_id <> 10017 AND override_flag = 'Y')) OR
(selection_type IN ('CURRENT_BATCH_UNREMITTED') --AND
\* selected_remittance_batch_id = 6046*\))
AND REVERSAL_DATE IS NULL
and (REMIT_METHOD_CODE IN ('STANDARD_AND_FACTORING', 'STANDARD'))
and (CURRENCY_CODE = 'CNY')*/
RECEIPT_NUMBER IN ( '20391021-1','25199928', '30533658')
SELECT REVERSAL_DATE,
RECEIPT_METHOD_NAME,
RECEIPT_NUMBER,
OVERRIDE_FLAG,
REMIT_BANK_ACCOUNT_NUMBER,
CUSTOMER_BANK_ACCOUNT_NUMBER,
RECEIPT_DATE,
MATURITY_DATE,
REMIT_BANK_NAME,
REMIT_BANK_BRANCH_NAME,
BANK_CHARGES,
CUSTOMER_BANK_NAME,
CUSTOMER_BANK_BRANCH_NAME,
CUSTOMER_NAME,
CUSTOMER_NUMBER,
ROW_ID,
REMITTANCE_BANK_BRANCH_ID,
REMITTANCE_BANK_ACCOUNT_ID,
CUSTOMER_BANK_ACCOUNT_ID,
CUSTOMER_BANK_BRANCH_ID,
BATCH_BANK_ACCOUNT_ID,
RECEIPT_METHOD_ID,
AMOUNT,
BATCH_ID,
REMIT_METHOD_CODE,
SELECTION_TYPE,
CURRENCY_CODE,
SELECTED_REMITTANCE_BATCH_ID,
PAY_FROM_CUSTOMER,
CUSTOMER_SITE_USE_ID,
CASH_RECEIPT_ID,
CASH_RECEIPT_HISTORY_ID,
PAYMENT_SCHEDULE_ID,
PAYMENT_TRXN_EXTENSION_ID,
PAYMENT_CHANNEL_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM AR_BOE_REMIT_RECEIPTS_CBR_V
WHERE (BATCH_ID in( 8011,28066,12038,12037) )
and (SELECTION_TYPE LIKE 'CURRENT_BATCH_REMITTED')
begin
mo_global.init(p_appl_short_name => 'AR');
end;
select ba.bank_acct_use_id bank_account_id,
bb.bank_name bank_name,
bb.branch_number bank_number,
cba.bank_account_num bank_account_number,
cba.bank_account_name bank_account_name,
cba.currency_code bank_account_currency,
l1.meaning ||
decode(crh.status,
'CLEARED',
decode(crh.factor_flag, 'Y', ' ' || l2.meaning, ''),
'') status,
cr.receipt_number receipt_number,
to_char(ps.due_date, 'dd-mm-yyyy') maturity_date,
rm.name payment_method,
cr.currency_code currency_code,
crh.amount amount,
crh.acctd_amount func_amount
from ar_lookups l1,
ar_lookups l2,
ar_payment_schedules ps,
ar_cash_receipts cr,
ar_cash_receipt_history crh,
ar_receipt_methods rm,
ce_bank_accounts cba,
ce_bank_acct_uses ba,
ce_bank_branches_v bb
where crh.cash_receipt_id = cr.cash_receipt_id
and cr.cash_receipt_id = ps.cash_receipt_id(+)
and cr.receipt_method_id = rm.receipt_method_id
and cr.remit_bank_acct_use_id = ba.bank_acct_use_id(+)
and ba.bank_account_id = cba.bank_account_id(+)
and bb.branch_party_id = cba.bank_branch_id -- Bug 6925308
--and bb.bank_party_id = cba.bank_branch_id
and crh.status = l1.lookup_code
and l1.lookup_type = 'RECEIPT_CREATION_STATUS'
and l2.lookup_type = 'REMITTANCE_METHOD'
and l2.lookup_code = 'FACTORING'
and RECEIPT_NUMBER IN ('20391021-1')
--and crh.cash_receipt_history_id > :MAX_CRH_ID
order by bb.bank_name,
cba.bank_account_num,
crh.status,
decode(crh.factor_flag, 'Y', 1, 'N', 2),
cr.currency_code,
cr.receipt_number