DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 189: FROM csi_item_instances cii

185: , cii.inventory_item_id
186: , cii.last_vld_organization_id
187: , civ.version_label
188: , CIR.OBJECT_ID
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

Line 218: FROM csi_item_instances cii

214: , cii.inventory_item_id
215: , cii.last_vld_organization_id
216: , civ.version_label
217: , CIR.OBJECT_ID
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

Line 426: FROM csi_item_instances cii

422: SELECT cii.instance_id
423: , tcpa.user_id
424: , cii.inventory_item_id
425: , cii.LAST_VLD_ORGANIZATION_ID
426: FROM csi_item_instances cii
427: , csm_party_sites_acc cpsa
428: , csm_party_assignment tcpa
429: WHERE cii.location_id = cpsa.party_site_id
430: AND cpsa.party_id = tcpa.party_id

Line 446: FROM csi_item_instances cii

442: SELECT cii.instance_id
443: , cpa.user_id
444: , cii.inventory_item_id
445: , cii.last_vld_organization_id
446: FROM csi_item_instances cii
447: , csm_party_assignment cpa
448: , hz_locations hz
449: WHERE cii.owner_party_id = cpa.party_id
450: AND cii.location_id = hz.location_id