DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSI_II_RELATIONSHIPS

Line 193: , CSI_II_RELATIONSHIPS CIR

189: FROM csi_item_instances cii
190: , csm_party_sites_acc cpsa
191: , csm_party_assignment tcpa
192: , csi_i_version_labels civ
193: , CSI_II_RELATIONSHIPS CIR
194: WHERE cii.location_id = cpsa.party_site_id
195: AND cpsa.party_id = tcpa.party_id
196: AND cpsa.user_id = tcpa.user_id
197: AND cii.location_type_code = 'HZ_PARTY_SITES'

Line 222: , CSI_II_RELATIONSHIPS CIR

218: FROM csi_item_instances cii
219: , csm_party_assignment cpa
220: , hz_locations hz
221: , csi_i_version_labels civ
222: , CSI_II_RELATIONSHIPS CIR
223: WHERE cii.owner_party_id = cpa.party_id
224: AND cii.location_id = hz.location_id
225: AND cii.location_type_code = 'HZ_LOCATIONS'
226: AND cpa.party_site_id IN (-1,-2)