Privileged Access Review
SELECT fr.responsibility_name,
fu.user_name,
urg.start_date,
urg.end_date
FROM apps.fnd_user_resp_groups_direct urg,
apps.fnd_user fu,
apps.fnd_responsibility_vl fr
WHERE 1 = 1
AND urg.user_id = fu.user_id
AND fr.responsibility_id = urg.responsibility_id
AND (fu.end_date IS NULL)
AND fr.responsibility_name IN ('Application Developer',
'Auditing Manager',
'Functional Administrator',
'Functional Developer',
'CRM Administrator',
'System Administration',
'System Administrator',
'User Management',
'WES IT System Administrator',
'XML Publisher Administrator')
and urg.end_date is null
ORDER BY fr.responsibility_name, fu.user_name
JFlore Vendor Cash Discount Extract
SELECT pv.segment1 "VENDOR_NUM",
pv.vendor_name "VENDOR_NAME",
pvsa.vendor_site_code "VENDOR_SITE_CODE",
aia.payment_status_flag,
DECODE(aia.payment_status_flag, 'N', 'UN-PAID', 'PAID') payment_status,
aia.invoice_type_lookup_code,
aia.invoice_num "INVOICE_NUM",
aia.invoice_date "INVOICE_DATE",
aia.gl_date "INVOICE_GL_DATE",
apsa.DUE_DATE,
apsa.DISCOUNT_DATE,
aia.terms_date,
aia.invoice_amount,
aia.amount_paid,
(SELECT sum(discount_taken) FROM ap_invoice_payments_all WHERE invoice_id = aia.invoice_id) DISCOUNT_TAKEN,
(SELECT sum(discount_lost) FROM ap_invoice_payments_all WHERE invoice_id = aia.invoice_id) DISCOUNT_LOST,
at.name "PAY_TERM_NAME",
apsa.DISCOUNT_AMOUNT_AVAILABLE,
apsa.DISCOUNT_AMOUNT_REMAINING,
pvsa.ALWAYS_TAKE_DISC_FLAG,
aia.description "INVOICE_DESCRIPTION",
aia.source,
aia.org_id,
decode(aia.org_id, 121, 'USD WESCO OU',
122, 'CAD WESCO OU',
146, 'M AND M WESCO OU') OPERATING_UNIT
-- aia.vendor_id """"""""VENDOR_ID"""""""",
FROM apps.ap_invoices_all aia,
apps.po_vendors pv,
apps.po_vendor_sites_all pvsa,
apps.ap_payment_schedules_all apsa,
apps.ap_terms at
WHERE pv.vendor_id = aia.vendor_id
AND pvsa.vendor_site_id = aia.vendor_site_id
AND aia.invoice_amount != 0
AND aia.payment_status_flag = 'N'
AND aia.amount_paid <> aia.invoice_amount
AND apsa.invoice_id = aia.invoice_id
AND at.term_id = aia.terms_id
AND aia.org_id <> 146
-- and (aia.gl_date BETWEEN TO_DATE ('01-JAN-1951', 'DD-MON-YYYY')
-- AND TO_DATE ('05-APR-2022', 'DD-MON-YYYY'))
--ORDER BY 2, 3, 8
ORDER BY 8