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_ALL

Line 3094: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

3090: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
3091: , pc_site_use VARCHAR2 )
3092: IS
3093: SELECT hcsu.site_use_id
3094: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
3095: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
3096: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id
3097: AND hcs.cust_account_id = pc_cust_account_id
3098: AND hcsu.site_use_code = pc_site_use

Line 5156: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

5152: , pc_party_site_id IN NUMBER
5153: , pc_site_use VARCHAR2 )
5154: IS
5155: SELECT hps.party_id , hcsu.site_use_id
5156: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
5157: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
5158: , hz_party_sites hps
5159: , hz_cust_accounts hc
5160: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id

Line 5173: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

5169:
5170:
5171: /*
5172: SELECT hcsu.site_use_id , hp.party_id , hc.cust_account_id
5173: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
5174: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
5175: , hz_party_sites hps
5176: , hz_parties hp
5177: , hz_cust_accounts hc

Line 5189: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs

5185: */
5186:
5187: CURSOR get_party_site_acc_id (pc_party_site_id IN NUMBER, pc_site_use VARCHAR2) IS
5188: SELECT hc.cust_account_id , hps.party_id , hcsu.site_use_id
5189: FROM hz_cust_acct_sites hcs --hz_cust_acct_sites_all hcs
5190: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu
5191: , hz_party_sites hps
5192: , hz_cust_accounts hc
5193: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id

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

5538: , pc_site_use VARCHAR2 ) IS
5539: SELECT hcsu.site_use_id
5540: , hcas.party_site_id
5541: , hp.party_id
5542: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5543: hz_cust_site_uses hcsu, -- hz_cust_site_uses_all hcsu,
5544: hz_party_sites hps,
5545: hz_parties hp
5546: WHERE hcas.party_site_id = hps.party_site_id

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

5553: CURSOR get_site_from_acct ( pc_account_id NUMBER
5554: , pc_location VARCHAR2
5555: , pc_site_use VARCHAR2 ) IS
5556: SELECT hcas.cust_acct_site_id
5557: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5558: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5559: hz_party_sites hps
5560: WHERE hcas.party_site_id = hps.party_site_id
5561: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id

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

5567: SELECT hcas.cust_account_id
5568: , hps.party_site_id
5569: , hp.party_id
5570: , hp.party_name
5571: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5572: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5573: hz_party_sites hps,
5574: hz_parties hp
5575: WHERE hcas.party_site_id = hps.party_site_id

Line 5584: FROM hz_cust_acct_sites_all hcas,

5580: CURSOR get_acct_from_site ( pc_site_id NUMBER ) IS
5581: SELECT hcas.cust_account_id
5582: , hp.party_id
5583: , hp.party_name
5584: FROM hz_cust_acct_sites_all hcas,
5585: hz_party_sites hps,
5586: hz_parties hp
5587: WHERE hcas.party_site_id = hps.party_site_id
5588: AND hps.party_id = hp.party_id

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

5589: AND hcas.cust_acct_site_id = pc_site_id;
5590:
5591: CURSOR get_party_site_id ( pc_site_use_id NUMBER ) IS
5592: SELECT hps.party_site_id
5593: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5594: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5595: hz_party_sites hps
5596: WHERE hcas.party_site_id = hps.party_site_id
5597: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id

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

5597: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5598: AND hcsu.cust_acct_site_id = pc_site_use_id
5599: UNION
5600: SELECT hps.party_site_id
5601: FROM hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5602: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5603: hz_party_sites hps
5604: WHERE hcas.party_site_id = hps.party_site_id
5605: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 5615: hz_cust_acct_sites_all hcas,

5611: hcas.cust_acct_site_id,
5612: hp.party_name
5613: FROM hz_cust_accounts hca,
5614: hz_parties hp,
5615: hz_cust_acct_sites_all hcas,
5616: hz_party_sites hps
5617: WHERE hcas.party_site_id = hps.party_site_id
5618: AND hcas.cust_account_id = hca.cust_account_id
5619: AND hp.party_id = hca.party_id

Line 5632: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5628: hp.party_name
5629: FROM hz_cust_accounts hca,
5630: hz_parties hp,
5631: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5632: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5633: hz_party_sites hps,
5634: hz_locations hl
5635: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5636: AND hcas.party_site_id = hps.party_site_id

Line 5660: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5656: hp.party_id
5657: FROM hz_cust_accounts hca,
5658: hz_parties hp,
5659: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5660: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5661: hz_party_sites hps,
5662: hz_locations hl
5663: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5664: AND hcas.party_site_id = hps.party_site_id

Line 5690: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5686: hp.party_name
5687: FROM hz_cust_accounts hca,
5688: hz_parties hp,
5689: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5690: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5691: hz_party_sites hps
5692: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5693: AND hcas.party_site_id = hps.party_site_id
5694: AND hcsu.status = 'A'

Line 5719: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5715: hp.party_name
5716: FROM hz_cust_accounts hca,
5717: hz_parties hp,
5718: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5719: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5720: hz_party_sites hps
5721: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5722: AND hcas.party_site_id = hps.party_site_id
5723: AND hcsu.status = 'A'

Line 5746: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,

5742: hp.party_id
5743: FROM hz_cust_accounts hca,
5744: hz_parties hp,
5745: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5746: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5747: hz_party_sites hps,
5748: hz_locations hl
5749: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5750: AND hcas.party_site_id = hps.party_site_id