Search found 12 matches
- Mon Apr 23, 2007 6:49 am
- Forum: Order Management
- Topic: Problem in feching data from pl/sql table in apps
- Replies: 0
- Views: 1356
Problem in feching data from pl/sql table in apps
Dear Friends I have created one procedure in that i m passing Customer id as in put parameter based on that i m fetching all orders placed by that order. I have given out parameter as pl/sql base apps table. Problem is that when i m going to execute it from pl/sql block. it is taking all lines only ...
- Tue Apr 17, 2007 8:32 am
- Forum: Order Management
- Topic: Customer to order..........urgent
- Replies: 2
- Views: 2955
Dear Ahmad Thanks.... [quote]<b>Get Customer Id By using this query</b> select CUSTOMER_NAME,CUSTOMER_ID from ra_customers rc <b>Pass Customer Id in below query you can get Complete order header</b> SELECT ooh.org_id ou, ooh.header_id hdr_id, ooh.order_category_code CATEGORY, ooh.order_number ord_nu...
- Tue Apr 17, 2007 3:27 am
- Forum: Order Management
- Topic: Customer to order..........urgent
- Replies: 2
- Views: 2955
Customer to order..........urgent
Hi friends
I m having following requirement.....
Is there any API in oracle apps which gives information as follows..
Suppose i have entered aperticular customer number..
That API should return the all Sales order against that perticular Customer...
Awaiting for reply...
I m having following requirement.....
Is there any API in oracle apps which gives information as follows..
Suppose i have entered aperticular customer number..
That API should return the all Sales order against that perticular Customer...
Awaiting for reply...
- Thu Apr 12, 2007 7:30 am
- Forum: Oracle Forms & Reports
- Topic: HELP REQUIRED IN QUERY
- Replies: 6
- Views: 3364
Hi..Friend.... May be following code usefull for u.. 1 declare 2 type nest_tab is table of varchar2(25); 3 nt1 nest_tab :=nest_tab('qqh@gmail.com','she.yahoo.com','rams@comp.com'); 4 answer nest_tab; 5 procedure my_nest_data (xx_data nest_tab) is 6 output varchar2(100); 7 begin 8 IF xx_data IS NULL ...
- Thu Apr 12, 2007 6:11 am
- Forum: Oracle Forms & Reports
- Topic: oracle apps forms
- Replies: 2
- Views: 2046
- Thu Apr 12, 2007 6:08 am
- Forum: Oracle Forms & Reports
- Topic: Dynamicaly population of list
- Replies: 2
- Views: 8368
Dynamicaly population of list
Dear alll... I have written following code for population of client no dynamicaly. but whn i run the form and clicks on the list item it gives error like... CLIENT_NO is not list item...but i have already set the propery of CLIENT_NO as list_item and list_style as comb Box. My recoed gruop populates...
- Thu Apr 12, 2007 6:01 am
- Forum: Order Management
- Topic: move order problem
- Replies: 2
- Views: 1917
- Mon Apr 09, 2007 3:43 am
- Forum: Order Management
- Topic: move order problem
- Replies: 2
- Views: 1917
move order problem
Dear friends.... i have created sales order in my vision instance...as follows 1)created order[enter] for warehouse v1 2)booked order. 3)pick the order for warehouse v1 4)Move order-->at thes time when i m entering batch number in header tab it is giving error...invalid number.. Experts can u give m...
- Fri Apr 06, 2007 8:55 am
- Forum: Oracle Forms & Reports
- Topic: Dynamically selecting the layout
- Replies: 1
- Views: 1205
- Fri Apr 06, 2007 8:48 am
- Forum: Oracle Forms & Reports
- Topic: Procedure registration
- Replies: 1
- Views: 1269
- Fri Apr 06, 2007 8:43 am
- Forum: Oracle Databases
- Topic: pl/sql table insertion error
- Replies: 0
- Views: 15001
pl/sql table insertion error
Dear all friends i m facing problem in following package.... my requirement is such as i have to pass the a tem pl/sql tabe to the oracle apps oe_order_pub.process_order api as a input for inventory item. for that purpose have created xx_xart table. i have created one packege, as follows create or r...
- Thu Apr 05, 2007 1:35 am
- Forum: Order Management
- Topic: booking order by using oe_order_pub.process_order
- Replies: 0
- Views: 2809
booking order by using oe_order_pub.process_order
Hi.. Good Morning to all of u.... .......................................... Dear All Oracle Apps Guru... I m facing problem at the time of booking sales order through API(oe_order_pub.process_order). I am able to enter the order,but i m unable to book the order. Following are the mandatory coln r h...