Friday, January 14, 2022

POS_SUPPLIER_MAPPINGS

POS_SUPPLIER_MAPPINGS table holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID. This is useful in case of two vendors effectively belong to the same HZ_PARTY Record.

SELECT psm.* 
  FROM pos_supplier_mappings  psm
 WHERE psm.party_id = 123456
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

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...