Query to find AP Pay Group

Below is the SQL query to find the Pay Groups in Oracle Accounts Payables (AP). 

Navigation:

Payables Manager -> Setup -> Lookups -> Purchasing -> Search for 'PAY GROUP' in Type field

SELECT lc.lookup_type               "Lookup Type",
       lc.lookup_code               "Lookup Code",
       lc.displayed_field           "Displayed Field",
       lc.description               "Description",
       TRUNC (lc.creation_date)     "Creation Date",
       usr_cr.user_name             "Created By",
       TRUNC (lc.last_update_date)  "Last Update Date",
       usr_up.user_name             "Last Updated By"
  FROM PO_LOOKUP_CODES  lc,
       FND_USER         usr_cr,
       FND_USER         usr_up
 WHERE lc.created_by = usr_cr.user_id
   AND lc.last_updated_by = usr_up.user_id
   AND lc.lookup_type = 'PAY GROUP'
   AND lc.enabled_flag = 'Y'
   AND SYSDATE <= NVL (lc.inactive_date, SYSDATE)
 ORDER BY lc.lookup_type, lc.lookup_code;