ERPstuff - Oracle EBS Community

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 ...

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 ...

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...

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 ...

Hi...venkat....

you want to develop new oracle apps form or u want to customize the original form..

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 ...

Dear Rekha...

Thanks for giving reply.....

Order is successfully pick released ..after getting batch number the nexrt step is tranfering material in stagging inventory for that transact move order will require...but that batch number is not appearing in the lov..

Awaiting for reply....

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 ...

hi...
can u tryied assigning dummy value for each layout..

and check...at after paramenter form which is required layout you want to print...

hi..frnd..

if you want to register u r procedure in oracle apps then at that time it is manadatory..

other wise if u r running normaly..then not require...

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 ...

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 ...