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 3105: , hz_parties hp

3101:
3102: CURSOR get_party_acc_id (cv_party_site_id IN NUMBER) IS
3103: SELECT hp.party_id , hc.cust_account_id
3104: FROM hz_party_sites hps
3105: , hz_parties hp
3106: , hz_cust_accounts hc
3107: WHERE hps.party_id = hp.party_id
3108: AND hp.party_id = hc.party_id (+)
3109: AND hps.party_site_id = cv_party_site_id;

Line 5176: , hz_parties hp

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
5179: AND hcs.party_site_id = hps.party_site_id
5180: AND hps.party_id = hp.party_id

Line 5530: FROM hz_cust_accounts cust, hz_parties pt

5526:
5527: CURSOR get_party_id(pc_account_Id NUMBER) IS
5528: SELECT cust.party_id
5529: , pt.party_name
5530: FROM hz_cust_accounts cust, hz_parties pt
5531: WHERE cust_account_id = pc_account_Id
5532: AND cust.party_id = pt.party_id ;
5533:
5534:

Line 5545: hz_parties hp

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
5548: AND hps.party_id = hp.party_id
5549: AND hcas.cust_account_id = pc_account_id

Line 5574: hz_parties hp

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
5577: AND hps.party_id = hp.party_id
5578: AND hcsu.site_use_id = pc_site_use_id;

Line 5586: hz_parties hp

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

Line 5614: hz_parties hp,

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

Line 5630: hz_parties hp,

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

Line 5658: hz_parties hp,

5654: 'SOLD_FROM', NULL,
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

Line 5688: hz_parties hp,

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

Line 5717: hz_parties hp,

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

Line 5744: hz_parties hp,

5740: 'SOLD_FROM', NULL,
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

Line 5762: FROM hz_parties

5758:
5759: -- [BEGIN OF BUG 4186465 FIXING]
5760: CURSOR get_party_name(cv_party_id IN NUMBER) IS
5761: SELECT party_name
5762: FROM hz_parties
5763: WHERE party_id = cv_party_id;
5764: -- [END OF BUG 4186465 FIXING]
5765:
5766: -- Bug 5201195 (+)

Line 5774: FROM hz_parties party

5770: , use.party_site_use_id
5771: , site.party_site_id
5772: , party.party_id
5773: , party.party_name
5774: FROM hz_parties party
5775: , hz_party_sites site
5776: , hz_locations loc
5777: , hz_party_site_uses use
5778: WHERE site.location_id = loc.location_id

Line 6414: hz_parties hzp

6410: SELECT party_id
6411: FROM ( SELECT hzmp.party_id,
6412: score
6413: FROM hz_matched_parties_gt hzmp,
6414: hz_parties hzp
6415: WHERE search_context_id = pc_search_id
6416: AND hzp.party_id = hzmp.party_id
6417: ORDER BY score desc, hzp.creation_date desc )
6418: WHERE rownum = 1;

Line 7270: hz_parties hp

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
7273: AND hps.party_site_id = hcas.party_site_id
7274: AND hcas.cust_account_id = cv_cust_account_id

Line 7284: hz_parties hp

7280: CURSOR get_sf_cust_and_site(cv_cust_account_id IN NUMBER) IS
7281: SELECT hp.party_id
7282: , hp.party_name
7283: FROM hz_cust_accounts hca,
7284: hz_parties hp
7285: WHERE hp.party_id = hca.party_id
7286: AND hca.cust_account_id = cv_cust_account_id;
7287:
7288: -- SOLD_FROM (ship_from_site_id)

Line 7297: hz_parties hp

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

Line 7315: hz_parties hp

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
7318: AND hps.party_site_id = hcas.party_site_id
7319: AND hcas.cust_account_id = cv_cust_account_id

Line 7336: hz_parties hp,

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
7339: AND hp.party_id = hps.party_id
7340: AND hps.party_site_id = hcas.party_site_id

Line 7358: hz_parties hp,

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
7361: WHERE hp.party_id = hcas.cust_account_id
7362: AND hp.party_id = hps.party_id