To look at the source code a formula function i.e. if you want to determine
the logic used to return the value concerned you can do the following
1. Establish the defintion name held in the table FF_FUNCTIONS
For example if you are interested in the function called
CALCULATE_CONTINUOUS_SERVICE
SELECT DEFINITION FROM FF_FUNCTIONS WHERE NAME = ‘CALCULATE_CONTINUOUS_SERVICE’
This will return the package.procedure
In this case it returns
pqp_service_history_calc_pkg.calcualate_continuous_service
2.Establish the file name held on the service for this package
SELECT TEXT FROM USER_SOURCE WHERE NAME = ‘PQP_SERVICE_HISTORY_CALC_PKG’
AND TEXT LIKE ‘%$Header%’
This will return the file name
In this case this is
pqshpcal.pkb
3.Access the package body code from the server and identify the procedure
concerned
In this case you can search code until locate function
calcualate_continuous_service
Excellent..
Good Job my Friend.
LikeLike