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,
JPLFND_USER_V usr_cr,
JPLFND_USER_V 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.creation_date;