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_CUST_SITE_USES

Line 2915: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

2911: , pc_site_use VARCHAR2 )
2912: IS
2913: SELECT hcsu.site_use_id
2914: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
2915: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
2916: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id
2917: AND hcs.cust_account_id = pc_cust_account_id
2918: AND hcsu.site_use_code = pc_site_use
2919: AND hcsu.primary_flag= 'Y'

Line 4812: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

4808: , pc_site_use VARCHAR2 )
4809: IS
4810: SELECT hcsu.site_use_id
4811: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
4812: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
4813: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id
4814: AND hcs.cust_account_id = pc_cust_account_id
4815: AND hcsu.site_use_code = pc_site_use
4816: AND hcsu.primary_flag= 'Y'

Line 4822: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

4818:
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

Line 5102: hz_cust_site_uses hcsu, -- hz_cust_site_uses_all hcsu,

5098: SELECT hcsu.site_use_id
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

Line 5117: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5113: , pc_location VARCHAR2
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

Line 5131: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5127: , hps.party_site_id
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

Line 5153: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5161: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5157: AND hcsu.cust_acct_site_id = pc_site_use_id
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;

Line 5190: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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
5194: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 5218: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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
5222: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 5248: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5277: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5304: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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
5308: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 6814: hz_cust_site_uses hcsu,

6810: , hps.party_site_id
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

Line 6841: hz_cust_site_uses hcsu,

6837: , hps.party_site_id
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

Line 6859: hz_cust_site_uses hcsu,

6855: , hps.party_site_id
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

Line 6880: hz_cust_site_uses hcsu,

6876: , hps.party_site_id
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

Line 6883: hz_cust_site_uses shcsu

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

Line 6902: hz_cust_site_uses hcsu,

6898: , hps.party_site_id
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

Line 6906: hz_cust_site_uses shcsu

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
6909: AND hps.party_site_id = hcas.party_site_id
6910: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id