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 3095: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

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
3099: AND hcsu.primary_flag= 'Y'

Line 5157: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

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
5161: AND hcs.party_site_id = hps.party_site_id

Line 5174: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

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
5178: WHERE hcsu.cust_acct_site_id = hcs.cust_acct_site_id

Line 5190: , hz_cust_site_uses hcsu --, hz_cust_site_uses_all hcsu

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
5194: AND hcs.party_site_id = hps.party_site_id

Line 5543: hz_cust_site_uses hcsu, -- hz_cust_site_uses_all hcsu,

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

Line 5558: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5572: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5594: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5602: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5631: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5627: hcas.party_site_id,
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

Line 5659: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 5689: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5685: hp.party_id,
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

Line 5718: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

5714: hp.party_id,
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

Line 5745: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,

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

Line 7268: hz_cust_site_uses hcsu,

7264: , hps.party_site_id
7265: , hp.party_id
7266: , hp.party_name
7267: FROM hz_cust_acct_sites hcas,
7268: hz_cust_site_uses hcsu,
7269: hz_party_sites hps,
7270: hz_parties hp
7271: WHERE hp.party_id = hcas.cust_account_id
7272: AND hp.party_id = hps.party_id

Line 7295: hz_cust_site_uses hcsu,

7291: , hps.party_site_id
7292: , hp.party_id
7293: , hp.party_name
7294: FROM hz_cust_acct_sites hcas,
7295: hz_cust_site_uses hcsu,
7296: hz_party_sites hps,
7297: hz_parties hp
7298: WHERE hp.party_id = hcas.cust_account_id
7299: AND hp.party_id = hps.party_id

Line 7313: hz_cust_site_uses hcsu,

7309: , hps.party_site_id
7310: , hp.party_id
7311: , hp.party_name
7312: FROM hz_cust_acct_sites hcas,
7313: hz_cust_site_uses hcsu,
7314: hz_party_sites hps,
7315: hz_parties hp
7316: WHERE hp.party_id = hcas.cust_account_id
7317: AND hp.party_id = hps.party_id

Line 7334: hz_cust_site_uses hcsu,

7330: , hps.party_site_id
7331: , hp.party_id
7332: , hp.party_name
7333: FROM hz_cust_acct_sites hcas,
7334: hz_cust_site_uses hcsu,
7335: hz_party_sites hps,
7336: hz_parties hp,
7337: hz_cust_site_uses shcsu
7338: WHERE hp.party_id = hcas.cust_account_id

Line 7337: hz_cust_site_uses shcsu

7333: FROM hz_cust_acct_sites hcas,
7334: hz_cust_site_uses hcsu,
7335: hz_party_sites hps,
7336: hz_parties hp,
7337: hz_cust_site_uses shcsu
7338: WHERE hp.party_id = hcas.cust_account_id
7339: AND hp.party_id = hps.party_id
7340: AND hps.party_site_id = hcas.party_site_id
7341: --AND hcas.cust_account_id = cv_cust_account_id ninarasi fix for FP bug 13011922

Line 7356: hz_cust_site_uses hcsu,

7352: , hps.party_site_id
7353: , hp.party_id
7354: , hp.party_name
7355: FROM hz_cust_acct_sites hcas,
7356: hz_cust_site_uses hcsu,
7357: hz_party_sites hps,
7358: hz_parties hp,
7359: hz_cust_acct_sites shcas,
7360: hz_cust_site_uses shcsu

Line 7360: hz_cust_site_uses shcsu

7356: hz_cust_site_uses hcsu,
7357: hz_party_sites hps,
7358: hz_parties hp,
7359: hz_cust_acct_sites shcas,
7360: hz_cust_site_uses shcsu
7361: WHERE hp.party_id = hcas.cust_account_id
7362: AND hp.party_id = hps.party_id
7363: AND hps.party_site_id = hcas.party_site_id
7364: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id