Skip to Content
0
Former Member
Oct 25, 2011 at 07:52 AM

Native SQL Procedure Code

70 Views

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