USEFUL SQL QUERIES

1. Find known table inside unknown package in plsql.

          select owner, name, referenced_owner, type from dba_dependencies where                                                              

          REFERENCED_NAME ='IBY_FNDCPT_PAYER_ASSGN_INSTR_V';

    2.  How do i get the last 4 digits of a phone number in sql developer?

         SELECT VENDOR_NAME,UPPER(VENDOR_NAME), SUBSTR(VENDOR_PHONE,                                                                                              

         Length(VENDOR_PHONE)-4) FROM AP.VENDORS;

    3. Below query is used to check which financial family pack was applied in a instance.

        SELECT FA.APPLICATION_SHORT_NAME APP,
        FPI.PATCH_LEVEL
        FROM FND_PRODUCT_INSTALLATIONS FPI,
        FND_APPLICATION FA
        WHERE FA.APPLICATION_ID = FPI.APPLICATION_ID;