eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_PARTY_ASSIGNMENT

Line 141: FROM csm_party_assignment tcpa

137: CURSOR l_party_ins_csr
138: IS
139: SELECT tcpa.user_id
140: , tcpa.party_id
141: FROM csm_party_assignment tcpa
142: WHERE tcpa.party_site_id IN (-1,-2)
143: AND tcpa.deleted_flag = 'N'
144: AND NOT EXISTS ( SELECT 1
145: FROM csm_parties_acc cpa

Line 160: FROM csm_party_assignment tcpa

156: SELECT tcpa.user_id
157: , tcpa.party_id
158: , hps.party_site_id
159: , hps.location_id
160: FROM csm_party_assignment tcpa
161: , hz_party_sites hps
162: WHERE tcpa.party_id = hps.party_id
163: AND tcpa.deleted_flag = 'N'
164: AND (tcpa.party_site_id = -1

Line 191: , csm_party_assignment tcpa

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
194: WHERE cii.location_id = cpsa.party_site_id
195: AND cpsa.party_id = tcpa.party_id

Line 219: , csm_party_assignment cpa

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
223: WHERE cii.owner_party_id = cpa.party_id

Line 254: FROM csm_party_assignment cpa

250: AND cca.source_object_id = ciia.instance_id
251: AND ccb.counter_type = 'REGULAR'
252: AND cca.source_object_code = 'CP'
253: AND ciia.user_id IN (SELECT cpa.user_id
254: FROM csm_party_assignment cpa
255: WHERE cpa.deleted_flag = 'N'
256: )
257: AND NOT EXISTS (SELECT 1
258: FROM csm_counters_acc ccsa

Line 276: FROM csm_party_assignment cpa

272: FROM csi_counter_readings ccr
273: , csm_counters_acc cca
274: WHERE ccr.counter_id = cca.counter_id
275: AND cca.user_id IN ( SELECT cpa.user_id
276: FROM csm_party_assignment cpa
277: WHERE cpa.deleted_flag ='N'
278: )
279: AND NOT EXISTS ( SELECT 1
280: FROM csm_counter_values_acc ccva

Line 297: FROM csm_party_assignment cpa

293: FROM csi_ctr_property_readings ccpr
294: , csm_counter_values_acc ccva
295: WHERE ccpr.counter_value_id = ccva.counter_value_id
296: AND ccva.user_id IN ( SELECT cpa.user_id
297: FROM csm_party_assignment cpa
298: WHERE cpa.deleted_flag ='N'
299: )
300: AND NOT EXISTS ( SELECT 1
301: FROM csm_counter_prop_values_acc ccpva

Line 318: FROM csm_party_assignment cpa

314: FROM csi_counter_properties_b ccpb
315: , csm_counters_acc cca
316: WHERE ccpb.counter_id = cca.counter_id
317: AND cca.user_id IN ( SELECT cpa.user_id
318: FROM csm_party_assignment cpa
319: WHERE cpa.deleted_flag ='N'
320: )
321: AND NOT EXISTS ( SELECT 1
322: FROM csm_counter_properties_acc ccpa

Line 339: , csm_party_assignment tcpa

335: , hpr.relationship_id
336: , hpr.directional_flag
337: , hpr.subject_id
338: FROM hz_relationships hpr
339: , csm_party_assignment tcpa
340: , hz_contact_points hcp
341: WHERE hpr.object_id = tcpa.party_id
342: AND hpr.party_id = hcp.owner_table_id
343: AND hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')

Line 362: , csm_party_assignment tcpa

358: IS
359: SELECT hca.cust_account_id
360: , tcpa.user_id
361: FROM hz_cust_accounts hca
362: , csm_party_assignment tcpa
363: WHERE hca.party_id = tcpa.party_id
364: AND tcpa.deleted_flag = 'N'
365: AND tcpa.party_site_id IN (-1,-2)
366: AND NOT EXISTS ( SELECT 1

Line 380: FROM csm_party_assignment tcpa

376: CURSOR l_party_del_csr
377: IS
378: SELECT tcpa.user_id
379: , tcpa.party_id
380: FROM csm_party_assignment tcpa
381: WHERE tcpa.party_site_id IN (-1,-2)
382: AND tcpa.deleted_flag = 'Y'
383: AND EXISTS ( SELECT 1
384: FROM csm_parties_acc cpa

Line 399: FROM csm_party_assignment tcpa,

395: SELECT tcpa.user_id
396: , tcpa.party_id
397: , hps.party_site_id
398: , hps.location_id
399: FROM csm_party_assignment tcpa,
400: hz_party_sites hps
401: WHERE tcpa.party_id = hps.party_id
402: AND tcpa.deleted_flag = 'Y'
403: AND (tcpa.party_site_id = -1

Line 428: , csm_party_assignment tcpa

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
431: AND cpsa.user_id = tcpa.user_id
432: AND cii.location_type_code = 'HZ_PARTY_SITES'

Line 447: , csm_party_assignment cpa

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
451: AND cii.location_type_code = 'HZ_LOCATIONS'

Line 544: , csm_party_assignment tcpa

540: , hpr.relationship_id
541: , hpr.directional_flag
542: , hpr.subject_id
543: FROM hz_relationships hpr
544: , csm_party_assignment tcpa
545: , hz_contact_points hcp
546: WHERE hpr.object_id = tcpa.party_id
547: AND hpr.party_id = hcp.owner_table_id
548: AND hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')

Line 567: , csm_party_assignment tcpa

563: IS
564: SELECT hca.cust_account_id
565: , tcpa.user_id
566: FROM hz_cust_accounts hca
567: , csm_party_assignment tcpa
568: WHERE hca.party_id = tcpa.party_id
569: AND tcpa.deleted_flag = 'Y'
570: AND tcpa.party_site_id IN (-1,-2)
571: AND EXISTS ( SELECT 1

Line 1705: DELETE FROM csm_party_assignment

1701:
1702: CLOSE l_customer_accounts_ins_csr;
1703: CSM_UTIL_PKG.LOG('Processing Customer Accounts-END ', 'CSM_PARTY_DATA_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
1704:
1705: DELETE FROM csm_party_assignment
1706: WHERE DELETED_FLAG='Y';
1707:
1708: COMMIT;
1709: