DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on PO_VENDOR_CONTACTS

Line 7606: PO_VENDOR_CONTACTS PVC,

7602: x_contact_details.state,
7603: x_contact_details.country,
7604: x_contact_details.email
7605: FROM CSI_I_PARTIES CIP,
7606: PO_VENDOR_CONTACTS PVC,
7607: PO_VENDOR_SITES_ALL PVS
7608: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7609: AND CIP.PARTY_ID = PVC.VENDOR_CONTACT_ID
7610: AND PVS.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID