DBA Data[Home] [Help]

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 795: pos_supplier_mappings psm

791: and fu.person_party_id (+) = hp.party_id
792: and hp.party_id not in
793: (
794: select contact_party_id from pos_contact_requests pcr,
795: pos_supplier_mappings psm
796: where pcr.request_status='PENDING'
797: and psm.mapping_id = pcr.mapping_id
798: and psm.PARTY_ID = l_from_party_id --:2
799: and contact_party_id is not null