|
|
begin
-- ﾖ?鰒ｯid
fnd_client_info.set_org_context('81');
end;
/* Formatted on 2004/10/30 09:28 (Formatter Plus v4.8.0) */
SELECT 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,
attribute_category, attribute1, attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7, attribute8, attribute9,
attribute10, attribute11, attribute12, attribute13, attribute14,
attribute15
FROM ar_boe_remit_receipts_v
WHERE
reversal_date IS NULL
AND
( ( (selection_type IN ('POTENTIAL_RECEIPTS_FOR_REMIT'))
AND ( remittance_bank_account_id = 10000
AND batch_bank_account_id = 10000
)
OR (batch_bank_account_id = 10000 AND override_flag = 'Y')
)
OR ( selection_type IN ('CURRENT_BATCH_UNREMITTED')
--AND selected_remittance_batch_id = 1493
)
)
AND (amount = 300000)
AND (remit_method_code IN ('STANDARD_AND_FACTORING', 'STANDARD'))
--and selection_type = 'CURRENT_BATCH_UNREMITTED' |
|
楼主: vvyjp
IP卡
狗仔卡
楼主
显身卡
发表于 2004-11-9 18:02
