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.CSI_SYSTEMS_PVT dependencies on HZ_PARTIES

Line 3024: AND party_source_table = 'HZ_PARTIES'

3020: SELECT instance_party_id,object_version_number,party_id,relationship_type_code
3021: FROM CSI_I_PARTIES
3022: WHERE contact_ip_id = p_contact_ip_id
3023: AND contact_flag = 'Y'
3024: AND party_source_table = 'HZ_PARTIES'
3025: AND sysdate BETWEEN NVL(active_start_date,sysdate) AND NVL(active_end_date,sysdate);
3026: --
3027: CURSOR install_csr(p_sys_id IN NUMBER) IS
3028: SELECT instance_id, install_location_id, object_version_number

Line 4493: ,hz_parties hz

4489: BEGIN
4490: SELECT 'x'
4491: INTO l_dummy
4492: FROM hz_cust_accounts hzc
4493: ,hz_parties hz
4494: WHERE hzc.cust_account_id = p_customer_id
4495: AND hzc.party_id=hz.party_id;
4496:
4497: /*SELECT 'x'

Line 4499: FROM hz_parties

4495: AND hzc.party_id=hz.party_id;
4496:
4497: /*SELECT 'x'
4498: INTO l_dummy
4499: FROM hz_parties
4500: WHERE party_id=p_customer_id; */
4501:
4502: EXCEPTION
4503: WHEN no_data_found THEN

Line 4523: ,hz_parties hz

4519: BEGIN
4520: SELECT 'x'
4521: INTO l_dummy
4522: FROM hz_cust_accounts hzc
4523: ,hz_parties hz
4524: WHERE hzc.cust_account_id = p_customer_id
4525: AND hzc.party_id=hz.party_id;
4526:
4527: /* SELECT 'x'

Line 4529: FROM hz_parties

4525: AND hzc.party_id=hz.party_id;
4526:
4527: /* SELECT 'x'
4528: INTO l_dummy
4529: FROM hz_parties
4530: WHERE party_id=p_customer_id; */
4531: EXCEPTION
4532: WHEN no_data_found THEN
4533: fnd_message.set_name('CSI', 'CSI_INVALID_CUSTOMER_ID');

Line 4723: FROM hz_parties

4719: THEN
4720: BEGIN
4721: SELECT 'x'
4722: INTO l_dummy
4723: FROM hz_parties
4724: WHERE party_id=p_ship_to_contact_id;
4725: EXCEPTION
4726: WHEN no_data_found THEN
4727: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');

Line 4740: FROM hz_parties

4736: THEN
4737: BEGIN
4738: SELECT 'x'
4739: INTO l_dummy
4740: FROM hz_parties
4741: WHERE party_id=p_ship_to_contact_id;
4742: EXCEPTION
4743: WHEN no_data_found THEN
4744: fnd_message.set_name('CSI', 'CSI_INVALID_SHIPTO_CT_ID');

Line 4789: FROM hz_parties

4785: THEN
4786: BEGIN
4787: SELECT 'x'
4788: INTO l_dummy
4789: FROM hz_parties
4790: WHERE party_id=p_bill_to_contact_id;
4791: EXCEPTION
4792: WHEN no_data_found THEN
4793: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');

Line 4805: FROM hz_parties

4801: THEN
4802: BEGIN
4803: SELECT 'x'
4804: INTO l_dummy
4805: FROM hz_parties
4806: WHERE party_id=p_bill_to_contact_id;
4807: EXCEPTION
4808: WHEN no_data_found THEN
4809: fnd_message.set_name('CSI', 'CSI_INVALID_BILLTO_CT_ID');

Line 4854: FROM hz_parties

4850: THEN
4851: BEGIN
4852: SELECT 'x'
4853: INTO l_dummy
4854: FROM hz_parties
4855: WHERE party_id=p_technical_contact_id;
4856: EXCEPTION
4857: WHEN no_data_found THEN
4858: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');

Line 4870: FROM hz_parties

4866: THEN
4867: BEGIN
4868: SELECT 'x'
4869: INTO l_dummy
4870: FROM hz_parties
4871: WHERE party_id=p_technical_contact_id;
4872: EXCEPTION
4873: WHEN no_data_found THEN
4874: fnd_message.set_name('CSI', 'CSI_INVALID_TECH_CT_ID');

Line 4918: FROM hz_parties

4914: THEN
4915: BEGIN
4916: SELECT 'x'
4917: INTO l_dummy
4918: FROM hz_parties
4919: WHERE party_id=p_service_admin_contact_id;
4920: EXCEPTION
4921: WHEN no_data_found THEN
4922: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');

Line 4934: FROM hz_parties

4930: THEN
4931: BEGIN
4932: SELECT 'x'
4933: INTO l_dummy
4934: FROM hz_parties
4935: WHERE party_id=p_service_admin_contact_id;
4936: EXCEPTION
4937: WHEN no_data_found THEN
4938: fnd_message.set_name('CSI', 'CSI_INVALID_SRVADMIN_CT_ID');

Line 5834: ,HZ_PARTIES hzp

5830: ,p_system_header_tbl(sys_row).party_id
5831: ,p_system_header_tbl(sys_row).customer_party_number
5832: ,p_system_header_tbl(sys_row).party_name
5833: FROM HZ_CUST_ACCOUNTS hza
5834: ,HZ_PARTIES hzp
5835: WHERE hza.cust_account_id = p_system_header_tbl(sys_row).customer_id
5836: AND hza.party_id = hzp.party_id;
5837: EXCEPTION
5838: WHEN OTHERS THEN

Line 5879: ,HZ_PARTIES hzp

5875: ,p_system_header_tbl(sys_row).ship_to_site_number
5876: FROM HZ_CUST_SITE_USES_ALL hzsu
5877: ,HZ_CUST_ACCT_SITES_ALL hzca
5878: ,HZ_PARTY_SITES hps
5879: ,HZ_PARTIES hzp
5880: ,HZ_LOCATIONS hls
5881: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).ship_to_site_use_id
5882: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id
5883: AND hzca.party_site_id = hps.party_site_id

Line 5928: ,HZ_PARTIES hzp

5924: ,p_system_header_tbl(sys_row).bill_to_site_number
5925: FROM HZ_CUST_SITE_USES_ALL hzsu
5926: ,HZ_CUST_ACCT_SITES_ALL hzca
5927: ,HZ_PARTY_SITES hps
5928: ,HZ_PARTIES hzp
5929: ,HZ_LOCATIONS hls
5930: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).bill_to_site_use_id
5931: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id
5932: AND hzca.party_site_id = hps.party_site_id

Line 5975: ,HZ_PARTIES hzp

5971: ,p_system_header_tbl(sys_row).install_description
5972: ,p_system_header_tbl(sys_row).install_location_id
5973: ,p_system_header_tbl(sys_row).install_site_number
5974: FROM HZ_PARTY_SITES hps
5975: ,HZ_PARTIES hzp
5976: ,HZ_LOCATIONS hls
5977: WHERE hps.party_site_id = p_system_header_tbl(sys_row).install_site_use_id
5978: AND hps.party_id = hzp.party_id
5979: AND hps.location_id = hls.location_id;

Line 5993: FROM HZ_PARTIES hzp

5989: SELECT hzp.party_number
5990: ,hzp.party_name
5991: INTO p_system_header_tbl(sys_row).technical_contact_number
5992: ,p_system_header_tbl(sys_row).technical_contact
5993: FROM HZ_PARTIES hzp
5994: WHERE hzp.party_id = p_system_header_tbl(sys_row).technical_contact_id;
5995: EXCEPTION
5996: WHEN OTHERS THEN
5997: NULL;

Line 6008: FROM HZ_PARTIES hzp

6004: SELECT hzp.party_number
6005: ,hzp.party_name
6006: INTO p_system_header_tbl(sys_row).service_admin_contact_number
6007: ,p_system_header_tbl(sys_row).service_admin_contact
6008: FROM HZ_PARTIES hzp
6009: WHERE hzp.party_id = p_system_header_tbl(sys_row).service_admin_contact_id;
6010: EXCEPTION
6011: WHEN OTHERS THEN
6012: NULL;

Line 6023: FROM HZ_PARTIES hzp

6019: SELECT hzp.party_number
6020: ,hzp.party_name
6021: INTO p_system_header_tbl(sys_row).bill_to_contact_number
6022: ,p_system_header_tbl(sys_row).bill_to_contact
6023: FROM HZ_PARTIES hzp
6024: WHERE hzp.party_id = p_system_header_tbl(sys_row).bill_to_contact_id;
6025: EXCEPTION
6026: WHEN OTHERS THEN
6027: NULL;

Line 6038: FROM HZ_PARTIES hzp

6034: SELECT hzp.party_number
6035: ,hzp.party_name
6036: INTO p_system_header_tbl(sys_row).ship_to_contact_number
6037: ,p_system_header_tbl(sys_row).ship_to_contact
6038: FROM HZ_PARTIES hzp
6039: WHERE hzp.party_id = p_system_header_tbl(sys_row).ship_to_contact_id;
6040: EXCEPTION
6041: WHEN OTHERS THEN
6042: NULL;