DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_I_PARTIES

Line 228: ,csi_i_parties cip

224: ,cii.install_location_type_code install_location_type_code
225: ,cip.party_id party_id
226: ,cip.party_source_table party_source_table
227: FROM csi_item_instances cii
228: ,csi_i_parties cip
229: WHERE cii.instance_id = p_instance_id
230: AND cip.instance_id = cii.instance_id
231: AND cip.relationship_type_code = 'OWNER';
232:

Line 433: FROM csi_i_parties cip,

429: cia.instance_party_id pty_acc_instance_party_id,
430: cia.party_account_id pty_acc_party_account_id,
431: cia.relationship_type_code pty_acct_rel_type_code,
432: cia.object_version_number pty_acct_obj_version_number
433: FROM csi_i_parties cip,
434: csi_ip_accounts cia,
435: csi_t_txn_line_details ctld
436: WHERE cip.instance_id = ctld.instance_id
437: AND cip.contact_flag ='N'

Line 452: FROM csi_i_parties cip

448: cip.party_source_table pty_party_source_table,
449: cip.party_id pty_party_id,
450: cip.relationship_type_code pty_rel_type_code,
451: cip.object_version_number pty_obj_version_number
452: FROM csi_i_parties cip
453: WHERE cip.instance_id = p_instance_id
454: AND cip.contact_flag = 'N'
455: AND nvl(cip.active_end_date,sysdate) >= sysdate;
456: