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.OZF_PRE_PROCESS_PVT dependencies on HZ_PARTY_SITES

Line 2924: FROM hz_party_sites hps

2920: AND hcsu.status = 'A';
2921:
2922: CURSOR get_party_acc_id (cv_party_site_id IN NUMBER) IS
2923: SELECT hp.party_id , hc.cust_account_id
2924: FROM hz_party_sites hps
2925: , hz_parties hp
2926: , hz_cust_accounts hc
2927: WHERE hps.party_id = hp.party_id
2928: AND hp.party_id = hc.party_id (+)

Line 4823: , hz_party_sites hps

4819: /*
4820: SELECT hcsu.site_use_id , hp.party_id , hc.cust_account_id
4821: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
4822: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
4823: , hz_party_sites hps
4824: , hz_parties hp
4825: , hz_cust_accounts hc
4826: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id
4827: AND hcs.party_site_id = hps.party_site_id

Line 4837: FROM hz_party_sites hps

4833: */
4834:
4835: CURSOR get_party_acc_id (cv_party_site_id IN NUMBER) IS
4836: SELECT hp.party_id , hc.cust_account_id
4837: FROM hz_party_sites hps
4838: , hz_parties hp
4839: , hz_cust_accounts hc
4840: WHERE hps.party_id = hp.party_id
4841: AND hp.party_id = hc.party_id (+)

Line 5103: hz_party_sites hps,

5099: , hcas.party_site_id
5100: , hp.party_id
5101: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5102: hz_cust_site_uses hcsu, -- hz_cust_site_uses_all hcsu,
5103: hz_party_sites hps,
5104: hz_parties hp
5105: WHERE hcas.party_site_id = hps.party_site_id
5106: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5107: AND hps.party_id = hp.party_id

Line 5118: hz_party_sites hps

5114: , pc_site_use VARCHAR2 ) IS
5115: SELECT hcas.cust_acct_site_id
5116: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5117: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5118: hz_party_sites hps
5119: WHERE hcas.party_site_id = hps.party_site_id
5120: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5121: AND hcas.cust_account_id = pc_account_id
5122: AND hcsu.location = pc_location

Line 5132: hz_party_sites hps,

5128: , hp.party_id
5129: , hp.party_name
5130: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5131: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5132: hz_party_sites hps,
5133: hz_parties hp
5134: WHERE hcas.party_site_id = hps.party_site_id
5135: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5136: AND hps.party_id = hp.party_id

Line 5144: hz_party_sites hps,

5140: SELECT hcas.cust_account_id
5141: , hp.party_id
5142: , hp.party_name
5143: FROM hz_cust_acct_sites_all hcas,
5144: hz_party_sites hps,
5145: hz_parties hp
5146: WHERE hcas.party_site_id = hps.party_site_id
5147: AND hps.party_id = hp.party_id
5148: AND hcas.cust_acct_site_id = pc_site_id;

Line 5154: hz_party_sites hps

5150: CURSOR get_party_site_id ( pc_site_use_id NUMBER ) IS
5151: SELECT hps.party_site_id
5152: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5153: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5154: hz_party_sites hps
5155: WHERE hcas.party_site_id = hps.party_site_id
5156: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5157: AND hcsu.cust_acct_site_id = pc_site_use_id
5158: UNION

Line 5162: hz_party_sites hps

5158: UNION
5159: SELECT hps.party_site_id
5160: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5161: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5162: hz_party_sites hps
5163: WHERE hcas.party_site_id = hps.party_site_id
5164: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5165: AND hcsu.site_use_id = pc_site_use_id;
5166:

Line 5175: hz_party_sites hps

5171: hp.party_name
5172: FROM hz_cust_accounts hca,
5173: hz_parties hp,
5174: hz_cust_acct_sites_all hcas,
5175: hz_party_sites hps
5176: WHERE hcas.party_site_id = hps.party_site_id
5177: AND hcas.cust_account_id = hca.cust_account_id
5178: AND hp.party_id = hca.party_id
5179: AND hps.party_site_id = pc_address_id;

Line 5192: hz_party_sites hps,

5188: FROM hz_cust_accounts hca,
5189: hz_parties hp,
5190: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5191: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5192: hz_party_sites hps,
5193: hz_locations hl
5194: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5195: AND hcas.party_site_id = hps.party_site_id
5196: AND hcsu.status = 'A'

Line 5220: hz_party_sites hps,

5216: FROM hz_cust_accounts hca,
5217: hz_parties hp,
5218: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5219: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5220: hz_party_sites hps,
5221: hz_locations hl
5222: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5223: AND hcas.party_site_id = hps.party_site_id
5224: AND hcsu.status = 'A'

Line 5250: hz_party_sites hps

5246: FROM hz_cust_accounts hca,
5247: hz_parties hp,
5248: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5249: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5250: hz_party_sites hps
5251: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5252: AND hcas.party_site_id = hps.party_site_id
5253: AND hcsu.status = 'A'
5254: AND hps.status = 'A'

Line 5279: hz_party_sites hps

5275: FROM hz_cust_accounts hca,
5276: hz_parties hp,
5277: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5278: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5279: hz_party_sites hps
5280: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5281: AND hcas.party_site_id = hps.party_site_id
5282: AND hcsu.status = 'A'
5283: AND hps.status = 'A'

Line 5306: hz_party_sites hps,

5302: FROM hz_cust_accounts hca,
5303: hz_parties hp,
5304: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5305: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5306: hz_party_sites hps,
5307: hz_locations hl
5308: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5309: AND hcas.party_site_id = hps.party_site_id
5310: AND hcsu.status = 'A'

Line 5975: hz_party_sites hzps

5971: hzmps.party_site_id,
5972: score ,
5973: hzps.creation_date
5974: FROM hz_matched_party_sites_gt hzmps,
5975: hz_party_sites hzps
5976: WHERE search_context_id = pc_search_id
5977: AND hzps.party_site_id = hzmps.party_site_id
5978: AND hzps.party_id = hzmps.party_id
5979: ORDER BY score desc, hzps.creation_date desc;

Line 6815: hz_party_sites hps,

6811: , hp.party_id
6812: , hp.party_name
6813: FROM hz_cust_acct_sites hcas,
6814: hz_cust_site_uses hcsu,
6815: hz_party_sites hps,
6816: hz_parties hp
6817: WHERE hp.party_id = hcas.cust_account_id
6818: AND hp.party_id = hps.party_id
6819: AND hps.party_site_id = hcas.party_site_id

Line 6842: hz_party_sites hps,

6838: , hp.party_id
6839: , hp.party_name
6840: FROM hz_cust_acct_sites hcas,
6841: hz_cust_site_uses hcsu,
6842: hz_party_sites hps,
6843: hz_parties hp
6844: WHERE hp.party_id = hcas.cust_account_id
6845: AND hp.party_id = hps.party_id
6846: AND hps.party_site_id = hcas.party_site_id

Line 6860: hz_party_sites hps,

6856: , hp.party_id
6857: , hp.party_name
6858: FROM hz_cust_acct_sites hcas,
6859: hz_cust_site_uses hcsu,
6860: hz_party_sites hps,
6861: hz_parties hp
6862: WHERE hp.party_id = hcas.cust_account_id
6863: AND hp.party_id = hps.party_id
6864: AND hps.party_site_id = hcas.party_site_id

Line 6881: hz_party_sites hps,

6877: , hp.party_id
6878: , hp.party_name
6879: FROM hz_cust_acct_sites hcas,
6880: hz_cust_site_uses hcsu,
6881: hz_party_sites hps,
6882: hz_parties hp,
6883: hz_cust_site_uses shcsu
6884: WHERE hp.party_id = hcas.cust_account_id
6885: AND hp.party_id = hps.party_id

Line 6903: hz_party_sites hps,

6899: , hp.party_id
6900: , hp.party_name
6901: FROM hz_cust_acct_sites hcas,
6902: hz_cust_site_uses hcsu,
6903: hz_party_sites hps,
6904: hz_parties hp,
6905: hz_cust_acct_sites shcas,
6906: hz_cust_site_uses shcsu
6907: WHERE hp.party_id = hcas.cust_account_id