PL/SQL (MOSC)

MOSC Banner

script

edited Oct 11, 2009 2:09AM in PL/SQL (MOSC) 1 commentAnswered
Hi BOBb,

i got this action plan from customer service im pasting below i dont understand how to make the script of the action plan given by them pleas have a look.

 6 ) Data Fix Script(s).
1. File Name (Including Path):
noship/datafix/ap_fix_party_site_id.sql

2. Script text (In addition to file name, please include script here)
--drop table ap_invoices_8844175;
----------------------------
-- Step 1 - Take Backup
----------------------------

create table ap_invoices_8844175 as
select ai.*
from ap_invoices_all ai,
ap_supplier_sites_all s
where ai.party_site_id is null
and s.vendor_site_id = ai.vendor_site_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