1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Financials AP 11i tables Vs R12 tables

Discussion in 'Oracle Financials' started by rollingstar35, May 13, 2012.

  1. rollingstar35

    rollingstar35 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    75
    Hello,

    I have a package that works in Oracle Apps 11i instance. This package is using 11i tables in its cursors. we are moving this package to r12 and thus this package has to run in r12 using r12 tables. I have heard that a lot of tables have been changed from 11i to r12 in oracle financials. here is the code.
    Some of the tables in the AP that were used in 11i were AP_BANK_ACCOUNTS_ALL, AP_BANK_BRANCHES, AP_CHECKS_ALL,

    AP_INV_SELECTION_CRITERIA_ALL,

    fnd_lookup_values_vl. I need to know their R12 counterparts or the R12 tables that needs to be inserted here.




    SELECT DISTINCT abb.attribute1 attribute1

    FROM APPS.ap_bank_accounts_all ABA,

    APPS.ap_bank_branches ABB,

    XXAP.XXAP_CD_PAYBATCH_APPR_OUT XCOUT,

    APPS.AP_INV_SELECTION_CRITERIA_ALL AISC

    WHERE aisc.checkrun_id = xcout.batch_id

    AND aisc.bank_account_id = aba.bank_account_id

    AND aba.bank_branch_id = abb.bank_branch_id


    SELECT ABB.ATTRIBUTE1 MESSAGE_ID,

    FROM APPS.AP_BANK_ACCOUNTS_ALL ABA,

    APPS.AP_BANK_BRANCHES ABB,

    APPS.AP_CHECKS_ALL CHK,

    APPS.AP_INV_SELECTION_CRITERIA_ALL AISC,

    APPS.fnd_lookup_values_vl FLV,

    XXAP.XXAP_APP_OUT XCOUT

    WHERE ABA.bank_branch_id = ABB.bank_branch_id

    AND AISC.bank_account_id = ABA.bank_account_id

    AND XCOUT.batch_id = AISC.checkrun_id

    AND CHK.checkrun_id = AISC.checkrun_id

    AND CHK.PAYMENT_METHOD_LOOKUP_CODE = AISC.PAYMENT_METHOD_LOOKUP_CODE

    AND ABA.ATTRIBUTE4 = FLV.LOOKUP_CODE