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_ACCT_SITES

Line 2914: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

2910: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
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

Line 4811: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

4807: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
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

Line 4821: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

4817: AND hcsu.status = 'A';
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

Line 5101: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5097: , pc_site_use VARCHAR2 ) IS
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

Line 5116: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5112: CURSOR get_site_from_acct ( pc_account_id NUMBER
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

Line 5130: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5126: SELECT hcas.cust_account_id
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

Line 5143: FROM hz_cust_acct_sites_all hcas,

5139: CURSOR get_acct_from_site ( pc_site_id NUMBER ) IS
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

Line 5152: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5148: AND hcas.cust_acct_site_id = pc_site_id;
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

Line 5160: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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

Line 5174: hz_cust_acct_sites_all hcas,

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
5178: AND hp.party_id = hca.party_id

Line 5191: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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

Line 5219: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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

Line 5249: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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
5253: AND hcsu.status = 'A'

Line 5278: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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
5282: AND hcsu.status = 'A'

Line 5305: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

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

Line 6569: FROM hz_cust_acct_sites s

6565:
6566: CURSOR c_get_cust_accnt_id(pc_party_site_id NUMBER)
6567: IS
6568: SELECT s.cust_account_id
6569: FROM hz_cust_acct_sites s
6570: WHERE s.party_site_id = pc_party_site_id
6571: AND status = 'A';
6572:
6573: CURSOR c_get_customer_accnt_id(pc_party_id NUMBER)

Line 6813: FROM hz_cust_acct_sites hcas,

6809: SELECT hcas.cust_account_id
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

Line 6840: FROM hz_cust_acct_sites hcas,

6836: SELECT hcas.cust_account_id
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

Line 6858: FROM hz_cust_acct_sites hcas,

6854: , hcsu.site_use_id
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

Line 6879: FROM hz_cust_acct_sites hcas,

6875: , hcsu.site_use_id
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

Line 6901: FROM hz_cust_acct_sites hcas,

6897: , hcsu.site_use_id
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,

Line 6905: hz_cust_acct_sites shcas,

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