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