Payables and Cash Management - EBS (MOSC)

MOSC Banner

Query to fetch the Payments data to send it to the bank

edited Aug 17, 2012 2:54AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Hello Every one,

As we are migrating from 11i(11.5.10.2) to R12(12.1.3), i am having a one Requirement. In 11i, we are creating a payment file by using the below query.

select  ------
from
       ap_selected_invoice_checks asic
        , ap_invoice_selection_criteria aisc
        --, ap_bank_accounts aba
        --, ap_bank_branches abb
        , ap_check_stocks acs
        , ap_check_formats acf
        , po_vendor_sites pvs
        , po_vendors pv
        , AP_XML_BATCHLEVEL2_V apbv
 WHERE ACS.CHECK_STOCK_ID = AISC.CHECK_STOCK_ID
         and ACS.CHECK_FORMAT_ID = ACF.CHECK_FORMAT_ID
         --and asic.external_bank_account_id = aba.bank_account_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center