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
No comments:
Post a Comment