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_PARTIES

Line 2925: , hz_parties hp

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 (+)
2929: AND hps.party_site_id = cv_party_site_id;

Line 4824: , hz_parties hp

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
4828: AND hps.party_id = hp.party_id

Line 4838: , hz_parties hp

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 (+)
4842: AND hps.party_site_id = cv_party_site_id;

Line 5089: FROM hz_cust_accounts cust, hz_parties pt

5085:
5086: CURSOR get_party_id(pc_account_Id NUMBER) IS
5087: SELECT cust.party_id
5088: , pt.party_name
5089: FROM hz_cust_accounts cust, hz_parties pt
5090: WHERE cust_account_id = pc_account_Id
5091: AND cust.party_id = pt.party_id ;
5092:
5093:

Line 5104: hz_parties hp

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
5108: AND hcas.cust_account_id = pc_account_id

Line 5133: hz_parties hp

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
5137: AND hcsu.site_use_id = pc_site_use_id;

Line 5145: hz_parties hp

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;
5149:

Line 5173: hz_parties hp,

5169: hp.party_id,
5170: hcas.cust_acct_site_id,
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

Line 5189: hz_parties hp,

5185: hp.party_id,
5186: hcas.party_site_id,
5187: hp.party_name
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

Line 5217: hz_parties hp,

5213: 'SOLD_FROM', NULL,
5214: hps.party_site_id) party_site_id,
5215: hp.party_id
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

Line 5247: hz_parties hp,

5243: hps.party_site_id) party_site_id,
5244: hp.party_id,
5245: hp.party_name
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

Line 5276: hz_parties hp,

5272: hps.party_site_id) party_site_id,
5273: hp.party_id,
5274: hp.party_name
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

Line 5303: hz_parties hp,

5299: 'SOLD_FROM', NULL,
5300: hps.party_site_id) party_site_id,
5301: hp.party_id
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

Line 5321: FROM hz_parties

5317:
5318: -- [BEGIN OF BUG 4186465 FIXING]
5319: CURSOR get_party_name(cv_party_id IN NUMBER) IS
5320: SELECT party_name
5321: FROM hz_parties
5322: WHERE party_id = cv_party_id;
5323: -- [END OF BUG 4186465 FIXING]
5324:
5325: -- Bug 5201195 (+)

Line 5333: FROM hz_parties party

5329: , use.party_site_use_id
5330: , site.party_site_id
5331: , party.party_id
5332: , party.party_name
5333: FROM hz_parties party
5334: , hz_party_sites site
5335: , hz_locations loc
5336: , hz_party_site_uses use
5337: WHERE site.location_id = loc.location_id

Line 5961: hz_parties hzp

5957: SELECT party_id
5958: FROM ( SELECT hzmp.party_id,
5959: score
5960: FROM hz_matched_parties_gt hzmp,
5961: hz_parties hzp
5962: WHERE search_context_id = pc_search_id
5963: AND hzp.party_id = hzmp.party_id
5964: ORDER BY score desc, hzp.creation_date desc )
5965: WHERE rownum = 1;

Line 6816: hz_parties hp

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
6820: AND hcas.cust_account_id = cv_cust_account_id

Line 6830: hz_parties hp

6826: CURSOR get_sf_cust_and_site(cv_cust_account_id IN NUMBER) IS
6827: SELECT hp.party_id
6828: , hp.party_name
6829: FROM hz_cust_accounts hca,
6830: hz_parties hp
6831: WHERE hp.party_id = hca.party_id
6832: AND hca.cust_account_id = cv_cust_account_id;
6833:
6834: -- SOLD_FROM (ship_from_site_id)

Line 6843: hz_parties hp

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
6847: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 6861: hz_parties hp

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
6865: AND hcas.cust_account_id = cv_cust_account_id

Line 6882: hz_parties hp,

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
6886: AND hps.party_site_id = hcas.party_site_id

Line 6904: hz_parties hp,

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
6908: AND hp.party_id = hps.party_id