Friday, 24 April 2015

Query to find API Name for oracle apps diffrent Module.

Most public APIs have the words 'pub' or 'api' in them, which helps narrow down the field. For example if you were looking for an inventory item API, you could search on the word ITEM as follows :

SELECT distinct object_name pkg, procedure$ proc
FROM dba_objects obj, sys.argument$ args
WHERE obj.object_id = args.obj#
AND obj.object_type = 'PACKAGE'
AND obj.owner = 'APPS'
AND ( obj.object_name LIKE '%API%'
OR obj.object_name LIKE '%PUB%' )
AND args.procedure$ LIKE '%ITEM%'
ORDER BY object_name, procedure$

No comments:

Post a Comment

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...