Home » SQL & PL/SQL » SQL & PL/SQL » Post data in AP interface table
Post data in AP interface table [message #192617] Wed, 13 September 2006 00:34 Go to next message
koushick
Messages: 2
Registered: September 2006
Location: india
Junior Member

Dear all
i have a staging table.its format is
INV_TYPE VARCHAR2 (25),
INV_SRL_NO VARCHAR2 (40),
INV_NUM VARCHAR2 (50),
INV_DATE DATE,
SUPPLIER_CODE VARCHAR2 (15),
SUPPLIER_SITE_CODE VARCHAR2 (15),
INV_AMOUNT NUMBER,
DESCRIPTION VARCHAR2 (150),
GL_DATE DATE,
OLD_ACCT VARCHAR2 (30),
MESSAGE VARCHAR2 (250),
STATUS VARCHAR2 (10)
i have to take all datas from this table and put it in AP Interface table.Datas are present till OLD_ACCT.
Plz let me know the procedure/plsql code for doing this.

Regards,
Koushick
Re: Post data in AP interface table [message #193339 is a reply to message #192617] Fri, 15 September 2006 14:57 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Please write my code..... Hmmm....

1) You do not state what the API should do.
2) You give no information about the context, version of Oracle etc.

MAYBE it is a bit over the hill, to ask someone to do YOUR JOB?

I mean, this is not like a single problem, or a "how does/should this work".

Orafaq.com is not writemycode.com......

Br
Kim
Re: Post data in AP interface table [message #193346 is a reply to message #192617] Fri, 15 September 2006 15:43 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Duplicate post

http://www.orafaq.com/forum/m/192621/66800/#msg_192621
Previous Topic: How to check records between AM && PM in a single day
Next Topic: How to remove fixed number of characters from a text data type
Goto Forum:
  


Current Time: Tue Dec 06 10:17:32 CST 2016

Total time taken to generate the page: 0.13634 seconds