Edi Yanto (何 萬 新)

Populate Order Import Interface Tables From Existing Sales Order

Posted by: Edi Yanto on: January 26, 2012

The script below is used to populate the order import interface tables using data from an existing sales order.
Interface Tables:

OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PAYMENTS_INTERFACE
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL

Base Tables:

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS
OE_PAYMENTS
OE_SALES_CREDITS
OE_LOT_SERIAL_NUMBERS

Script:

DECLARE
l_return_status       VARCHAR2 (1);
l_order_number_from   NUMBER;
l_order_source_id     NUMBER;
BEGIN
oe_debug_pub.debug_on;
oe_debug_pub.initialize;
oe_inf_populate_pub.populate_interface (p_api_version_number      => 1.0,
x_return_status           => l_return_status,
p_order_number_from       => :p_order_number,
p_order_source_id         => :p_order_source_id
);
END;

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

RSS Syndication


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn
Edi Yanto (何 萬 新) - Blogged Page Rank Check

My Certifications

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 4 other followers

 

January 2012
M T W T F S S
« May    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Top Rated

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.

RSS detikcom: situs warta era digital

  • An error has occurred; the feed is probably down. Try again later.

 

January 2012
M T W T F S S
« May    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Visitors

Categories

Blog Stats

  • 49,482 hits

Users Online

web counter

Pages

Follow

Get every new post delivered to your Inbox.