Oracle Cloud ERP

Search This Blog

Query : Purchasing Category and GL Account

on March 11, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

select *
--category_name, category_id
from POR_BROWSE_CATEGORIES_TL

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Query : Suppliers

Tables used: POZ_SUPPLIERS POZ_SUPPLIERS_V HZ_PARTIES select ps.taxpayer_country, psv.segment1, psv.vendor_name, psv.vendor_id, hp.party_id, psv.enabled_flag, psv.type_1099, psv.withholding_status_lookup_code, psv.withholding_start_date, psv.business_relationship, psv.vendor_type_lookup_code, ps.creation_source from poz_suppliers ps, poz_suppliers_v psv, hz_parties hp where hp.party_id = ps.party_id and hp.party_id = psv.party_id --count by supplier type (enabled only) select count(psv.vendor_type_lookup_code), psv.vendor_type_lookup_code from poz_suppliers ps, poz_suppliers_v psv, hz_parties hp where hp.party_id = ps.party_id and hp.party_id = psv.party_id and ps.enabled_flag = 'Y' group by psv.vendor_type_lookup_code

Query : Suppliers - Vendor, Site, Parties, Payment Terms

select psv.vendor_name, psv.segment1 "VendorNumber", ps.END_DATE_ACTIVE "SupplierEndDate", psv.enabled_flag, psv.business_relationship, psv.vendor_type_lookup_code, ps.creation_source, pss.vendor_site_code, pss.inactive_date "SiteEndDate", pss.terms_id, at.name "Term" from poz_suppliers ps, poz_supplier_sites_all_m pss, poz_suppliers_v psv, hz_parties hp ,AP_TERMS_TL at where hp.party_id = ps.party_id and hp.party_id = psv.party_id and ps.vendor_id = pss.vendor_id and at.term_id(+) = pss.terms_id and ps.vendor_TYPE_LOOKUP_CODE = 'SUPPLIER'

Query : Users and Application Roles

Tables used: per_user_roles pur per_roles_dn prd per_users pu PER_PERSON_NAMES_F ppnf Select distinct prd.role_common_name, pu.username, ppnf.first_name, ppnf.last_name from per_user_roles pur, per_roles_dn prd, per_users pu, PER_PERSON_NAMES_F ppnf where pur.role_id = prd.role_id and prd.role_common_name = 'XXX_ROLE_NAME' and pu.user_id = pur.user_id and ppnf.person_id = pu.person_id From: https://rpforacle.blogspot.com/2019/03/user-and-roles-query-in-oracle-cloud.html SELECT pu.user_id, pu.username, ppnf.full_name, prdt.role_id, prdt.role_name, prd.role_common_name, prdt.description, TO_CHAR (pur.start_date, 'DD-MON-YY...

Powered by Blogger

Query : Purchasing Category and GL Account

Comments

Post a Comment