ERPstuff - Oracle EBS Community

For Oracle University Corporate Training Queries or Partnership Contact : Sumera Khan Afghan Regional Education Manager South Asia Growth Economics #211, Software Technology Part 2, ETC, Sir Agha Khan Road, F-5/1, Islamabad - 44000 E-mail : sumera.afghan@oracle.com Phone : +92 51 2872550 Cellular : ...

What I got understanding from your posting you need to use formula column for this calculations. If your issue is something else then please let us know. thanks

Hmm bit tricky...........hope someone will have some solution. Let's wait...

Download sample from the following link,

topic.asp?TOPIC_ID=12

The only issue you will have to clear records from that table when abnormal close of application will occure. Hope you got my point. This technique is normally used in web based applications like you may check at the botton of erpstuff.com where you have info the current online users. Ya it would be...

You will have to move the values to a variable with concatenation, My_variable := My_variable || ',' || c1rec.CUSTOMER_ITEM_NUMBER; 38 dbms_output.put_line(c1rec.CUSTOMER_ITEM_NUMBER||','); Move line 38 after 39 as below, 39 END LOOP; 38 dbms_output.put_line(My_variable); Hope will resolve your issue.

Please don't duplicate the threads.......once posted its fine.

topic.asp?TOPIC_ID=157

You should create the fiew first then use where while selecting data from the view.

create view emp_v as select * from emp

select * from emp_v where deptno = 12

You can also use if conditions if required to have multiple different where for the query.

From your post what I am trying to understand is that you want to have a self join but still a confusion is that in one category you have LAND and in other VERHICLES but what would be the key to join them? So first need we need to identify the key to build relation. Secondly please check lexical ref...

Only wanted to provide info about different levels.

SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The default value is 0. SYSTEM.MESSAGE_LEVEL can be set to either a character string or a number. The values assigned can be any value between 0 and 25, but values lower than 0 or higher than 25 will g...

Ya better to have some output as well on the basis of sample data.thanks

Is this issue different than the following already discussed one,

topic.asp?TOPIC_ID=143

Pl let us know exactly which requirement as I have provided different options. thanks