Tracking dependencies and completing necessary recompilations are performed automatically by Oracle. Local dependency management occurs when Oracle manages dependencies among the objects in a single database. For example, a statement in a procedure can reference a table in the same database. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Jun 08, 2015 · Query to check Value Set; Query to check Concurrent Request Status; Query to check Customer address related details by passing Order Number; Query to get Bill_to Ship_to Deliver_to Sold_to customer details; Query to Alter Session in Oracle Apps; How to know the sql query that is being executed for the long running concurrent program in Oracle apps There are two ways you may check the dependencies of a table: 1) Using Toad you can see the dependecies of a table. 2) Yaping Chen recommends using a procedure with “dbma_utility.GET_DEPENDENCY” example: