Friday, January 14, 2022

HZ_ORGANIZATION_PROFILES

This table captures additional Supplier information.

Examples are like credit scoring details of Supplier or the No. of Employees working in Supplier Organization.

SELECT hop.* 
  FROM hz_organization_profiles hop
 WHERE hop.party_id = 123456

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...