APPS.CSI_MASS_EDIT_PUB dependencies on CSI_I_PARTIES

Line 232: ,csi_i_parties cip

228: ,cii.install_location_type_code install_location_type_code
229: ,cip.party_id party_id
230: ,cip.party_source_table party_source_table
231: FROM csi_item_instances cii
232: ,csi_i_parties cip
233: WHERE cii.instance_id = p_instance_id
234: AND cip.instance_id = cii.instance_id
235: AND cip.relationship_type_code = 'OWNER';
236:

Line 506: FROM csi_i_parties cip,

502: cia.instance_party_id pty_acc_instance_party_id,
503: cia.party_account_id pty_acc_party_account_id,
504: cia.relationship_type_code pty_acct_rel_type_code,
505: cia.object_version_number pty_acct_obj_version_number
506: FROM csi_i_parties cip,
507: csi_ip_accounts cia,
508: csi_t_txn_line_details ctld
509: WHERE cip.instance_id = ctld.instance_id
510: AND cip.contact_flag ='N'

Line 530: FROM csi_i_parties cip,

526: null pty_acc_instance_party_id,
527: null pty_acc_party_account_id,
528: null pty_acct_rel_type_code,
529: null pty_acct_obj_version_number
530: FROM csi_i_parties cip,
531: csi_t_txn_line_details ctld
532: WHERE cip.instance_id = ctld.instance_id
533: AND cip.contact_flag ='N'
534: AND cip.relationship_type_code = 'OWNER'

Line 539: AND NOT EXISTS (SELECT 'X' FROM csi_i_parties cip, csi_ip_accounts cia

535: AND ctld.transaction_line_id = p_txn_line_id
536: AND ctld.instance_exists_flag = 'Y'
537: AND ctld.preserve_detail_flag = 'Y'
538: AND cip.party_id in (SELECT INTERNAL_PARTY_ID FROM csi_install_parameters)
539: AND NOT EXISTS (SELECT 'X' FROM csi_i_parties cip, csi_ip_accounts cia
540: WHERE cip.INSTANCE_PARTY_ID = cia.INSTANCE_PARTY_ID
541: AND cip.instance_id = ctld.instance_id
542: AND cip.contact_flag = 'N'
543: AND cip.relationship_type_code = 'OWNER');

Line 552: FROM csi_i_parties cip

548: cip.party_source_table pty_party_source_table,
549: cip.party_id pty_party_id,
550: cip.relationship_type_code pty_rel_type_code,
551: cip.object_version_number pty_obj_version_number
552: FROM csi_i_parties cip
553: WHERE cip.instance_id = p_instance_id
554: AND cip.contact_flag = 'N'
555: AND nvl(cip.active_end_date,sysdate) >= sysdate;
556:

Line 4987: from CSI_I_PARTIES cip, csi_ip_accounts cia

4983: Select cip.INSTANCE_PARTY_ID, cip.PARTY_ID, cia.PARTY_ACCOUNT_ID, cia.IP_ACCOUNT_ID,
4984: CIP.OBJECT_VERSION_NUMBER, CIA.OBJECT_VERSION_NUMBER
4985: into l_instance_party_id, l_curr_partyid, l_curr_accountid, l_ip_account_id,
4986: l_party_obj_ver, l_act_obj_ver
4987: from CSI_I_PARTIES cip, csi_ip_accounts cia
4988: where cip.INSTANCE_PARTY_ID = cia.INSTANCE_PARTY_ID
4989: AND cip.RELATIONSHIP_TYPE_CODE = 'OWNER' AND cip.CONTACT_FLAG = 'N'
4990: AND Nvl(cip.ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE
4991: AND Nvl(cip.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE

Line 5000: from CSI_I_PARTIES cip

4996: when no_data_found then
4997: BEGIN
4998: Select cip.INSTANCE_PARTY_ID, cip.PARTY_ID, CIP.OBJECT_VERSION_NUMBER
4999: into l_instance_party_id, l_curr_partyid, l_party_obj_ver
5000: from CSI_I_PARTIES cip
5001: where cip.RELATIONSHIP_TYPE_CODE = 'OWNER' AND cip.CONTACT_FLAG = 'N'
5002: AND Nvl(cip.ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE
5003: AND Nvl(cip.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE
5004: AND cip.INSTANCE_ID = l_instance.INSTANCE_ID;

Line 5563: from CSI_I_PARTIES cip

5559: l_dummy_var := 'Y';
5560: BEGIN
5561: Select 'X'
5562: into l_dummy_var
5563: from CSI_I_PARTIES cip
5564: where cip.RELATIONSHIP_TYPE_CODE = 'BILL_TO' AND cip.CONTACT_FLAG = 'N'
5565: AND Nvl(cip.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE
5566: AND cip.INSTANCE_ID = l_instance.INSTANCE_ID
5567: AND cip.PARTY_ID = l_instance.ASSOCIATE_BILL_TO_PARTY_ID;

Line 5613: from CSI_I_PARTIES cip

5609: l_dummy_var := 'Y';
5610: BEGIN
5611: Select 'X'
5612: into l_dummy_var
5613: from CSI_I_PARTIES cip
5614: where cip.RELATIONSHIP_TYPE_CODE = 'SHIP_TO' AND cip.CONTACT_FLAG = 'N'
5615: AND Nvl(cip.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE
5616: AND cip.INSTANCE_ID = l_instance.INSTANCE_ID
5617: AND cip.PARTY_ID = l_instance.ASSOCIATE_SHIP_TO_PARTY_ID;