PO_HEADERS_ALL.TYPE_LOOKUP_CODE in Oracle APPS

SELECT lookup_type, lookup_code, meaning

  FROM fnd_lookup_values

 WHERE     1 = 1

       AND lookup_type = 'POO:DOCUMENT_TYPE'

       AND enabled_flag = 'Y'

       AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)

                       AND NVL (end_date_active, SYSDATE)