1 Reply Latest reply: Jun 4, 2013 1:53 AM by SAML. RSS

    Oracle application alert.

    997402
      Hello all. I am very new beginner to this forums as well as entry level to oracle application.
      My client project is upgrading from 11i to R12.

      I have one oracle alert which contains below query (11i)

      ACTUAL 11i query:

      SELECT DISTINCT substr(haou.name,1,4),
      substr(aca.vendor_name,1,45),
      aca.check_number,
      to_char(nvl(aca.amount,0),'999G999G990'),
      aca.currency_code,
      u.user_name
      INTO
      &OU,
      &RMT2,
      &CHKN,
      &CHKA,
      &CHKC,
      &USR
      FROM ap.ap_checks_all aca, ap.AP_CHECK_STOCKS_ALL acsa, apps.fnd_user u, hr.hr_all_organization_units haou,
      ap.AP_INVOICE_PAYMENTS_ALL aipa, ap.ap_invoices_all aia
      WHERE aca.check_stock_id = acsa.check_stock_id
      and aca.check_id = aipa.check_id (+)
      and aipa.invoice_id = aia.invoice_id
      and aia.created_by = aca.created_by
      AND aca.org_id = haou.organization_id
      and aca.created_by = u.user_id
      and acsa.name not in ('WIRE','BOA WIRES')
      and aca.amount > 99.99
      and trunc(aca.creation_date) >= trunc(sysdate)
      order by 1,2
      ===============================
      In R12 I know I have to change AP.AP_CHECK_STOCKS_ALL is obsolete in Oracle r12. I have to replace it with CE.CE_PAYMENT_DOCUMENTS.
      But when u change it is saying error in joint of
      aca.check_stock_id = acsa.check_stock_id . --- HERE I confused how to solve this joint.

      How to joint AP.AP_CHECK_STOCKS_ALL and CE.CE_PAYMENT_DOCUMENTS. table
      i.e aca.check_stock_id = acsa.check_stock_id.

      Many Thanks in advance.