Saturday, March 27, 2021

iSupplier Portal: Query to fetch iSupplier user details with linked vendor data in Oracle Applications R12

 







            In this post, we have given a query which helps to link iSupplier user and respective vendors.

Instance: R12.2.4

Query:

SELECT fu.user_name isupplier_user_name, fu.start_date user_start_date, fu.end_date user_end_date, NVL(fu.email_address, user_party.email_address ) email_address, pv.vendor_name, user_party.person_last_name contact_last_name, user_party.person_first_name contact_first_name, hzr.end_date user_vend_relation_enddate, fu.person_party_id, pv.party_id vendor_party_id, pv.vendor_id, hzr.relationship_id, hzr.party_id rel_party_id, fu.user_id FROM po_vendors pv, hz_parties user_party, fnd_user fu, hz_relationships hzr, ak_web_user_sec_attr_values sec WHERE fu.person_party_id = user_party.party_id AND hzr.relationship_type = 'CONTACT' AND hzr.relationship_code = 'CONTACT_OF' AND hzr.subject_id = fu.person_party_id AND hzr.subject_type = 'PERSON' AND hzr.subject_table_name = 'HZ_PARTIES' AND hzr.object_type = 'ORGANIZATION' AND hzr.object_table_name = 'HZ_PARTIES' AND hzr.object_id = pv.party_id AND hzr.status = 'A' AND sec.web_user_id = fu.user_id AND sec.attribute_code = 'ICX_SUPPLIER_ORG_ID' AND sec.number_value = pv.vendor_id AND sec.attribute_application_id = 177;

2 Responses to “iSupplier Portal: Query to fetch iSupplier user details with linked vendor data in Oracle Applications R12”

Akhi said...
July 23, 2021 at 2:43 AM

Hi,

Is it possible to fetch supplier last login into Isupplier portal


Naani said...
February 11, 2022 at 11:21 AM

Hi, Thanks you so much. Its very useful. Could you please provide us the same query for iRecevables user details as well ?


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.