DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 7657: PO_VENDOR_SITES_ALL PVS

7653: x_contact_details.country,
7654: x_contact_details.email
7655: FROM CSI_I_PARTIES CIP,
7656: PO_VENDOR_CONTACTS PVC,
7657: PO_VENDOR_SITES_ALL PVS
7658: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7659: AND CIP.PARTY_ID = PVC.VENDOR_CONTACT_ID
7660: AND PVS.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID
7661: AND rownum < 2;