Native SQL Procedure Code

Former Member — Tue, 25 Oct 2011 07:52:12 GMT

Hi All,

During analysis of an issue I cam across a native SQL procedure code .

Procedure Name : APS_ORDER_CHANGE .

I checked with my basis team and unable to find the code.

Basis team used the following queries to retrieve the procedure code.

SQL> select OBJECT_NAME, SUBOBJECT_NAME, OBJECT_TYPE, STATUS from user_objects where OBJECT_TYPE='PROCEDURE' and OBJECT_NAME='APS_ORDER_CHANGE';

no rows selected

SQL> select OWNER, OBJECT_NAME, STATUS from dba_objects where OBJECT_TYPE='PROCEDURE' and OBJECT_NAME='APS_ORDER_CHANGE';

no rows selected

SQL>

Can anyone please let me know where can I find the procedure code?

Thanks & Regards,

Shafivullah Mohammad

Re: Native SQL Procedure Code

Former Member — Tue, 25 Oct 2011 08:13:42 GMT

Hi,

Take a look at the following OSS note 698400

hope it will help you..

Thanks & regards.