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_ACCOUNTS

Line 801: FROM hz_cust_accounts

797:
798: CURSOR chk_cust_account ( pc_account_id NUMBER)
799: IS
800: SELECT 'X'
801: FROM hz_cust_accounts
802: WHERE cust_account_id = pc_account_id;
803:
804: l_chk_flag VARCHAR2(1) := NULL;
805: time NUMBER;

Line 1046: FROM hz_cust_accounts

1042:
1043: CURSOR get_partner_party_id ( pc_account_id NUMBER )
1044: IS
1045: SELECT party_id
1046: FROM hz_cust_accounts
1047: WHERE cust_account_id = pc_account_id;
1048:
1049: l_party_contact_id NUMBER;
1050: l_party_id NUMBER;

Line 2907: FROM hz_cust_accounts cust

2903:
2904: CURSOR get_account_id (pc_party_Id NUMBER)
2905: IS
2906: SELECT cust.cust_account_id
2907: FROM hz_cust_accounts cust
2908: WHERE cust.party_id = pc_party_Id;
2909:
2910: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
2911: , pc_site_use VARCHAR2 )

Line 2926: , hz_cust_accounts hc

2922: CURSOR get_party_acc_id (cv_party_site_id IN NUMBER) IS
2923: SELECT hp.party_id , hc.cust_account_id
2924: FROM hz_party_sites hps
2925: , hz_parties hp
2926: , hz_cust_accounts hc
2927: WHERE hps.party_id = hp.party_id
2928: AND hp.party_id = hc.party_id (+)
2929: AND hps.party_site_id = cv_party_site_id;
2930:

Line 4804: FROM hz_cust_accounts cust

4800:
4801: CURSOR get_account_id (pc_party_Id NUMBER)
4802: IS
4803: SELECT cust.cust_account_id
4804: FROM hz_cust_accounts cust
4805: WHERE cust.party_id = pc_party_Id;
4806:
4807: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
4808: , pc_site_use VARCHAR2 )

Line 4825: , hz_cust_accounts hc

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
4827: AND hcs.party_site_id = hps.party_site_id
4828: AND hps.party_id = hp.party_id
4829: AND hcs.cust_account_id = hc.cust_account_id

Line 4839: , hz_cust_accounts hc

4835: CURSOR get_party_acc_id (cv_party_site_id IN NUMBER) IS
4836: SELECT hp.party_id , hc.cust_account_id
4837: FROM hz_party_sites hps
4838: , hz_parties hp
4839: , hz_cust_accounts hc
4840: WHERE hps.party_id = hp.party_id
4841: AND hp.party_id = hc.party_id (+)
4842: AND hps.party_site_id = cv_party_site_id;
4843:

Line 5089: FROM hz_cust_accounts cust, hz_parties pt

5085:
5086: CURSOR get_party_id(pc_account_Id NUMBER) IS
5087: SELECT cust.party_id
5088: , pt.party_name
5089: FROM hz_cust_accounts cust, hz_parties pt
5090: WHERE cust_account_id = pc_account_Id
5091: AND cust.party_id = pt.party_id ;
5092:
5093:

Line 5172: FROM hz_cust_accounts hca,

5168: SELECT hca.cust_account_id,
5169: hp.party_id,
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

Line 5188: FROM hz_cust_accounts hca,

5184: hcsu.site_use_id,
5185: hp.party_id,
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,

Line 5216: FROM hz_cust_accounts hca,

5212: decode(p_party_type,'SHIP_FROM', NULL,
5213: 'SOLD_FROM', NULL,
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,

Line 5246: FROM hz_cust_accounts hca,

5242: 'SOLD_FROM', NULL,
5243: hps.party_site_id) party_site_id,
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

Line 5275: FROM hz_cust_accounts hca,

5271: 'SOLD_FROM', NULL,
5272: hps.party_site_id) party_site_id,
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

Line 5302: FROM hz_cust_accounts hca,

5298: decode(p_party_type,'SHIP_FROM', NULL,
5299: 'SOLD_FROM', NULL,
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,

Line 6576: FROM hz_cust_accounts a

6572:
6573: CURSOR c_get_customer_accnt_id(pc_party_id NUMBER)
6574: IS
6575: SELECT a.cust_account_id
6576: FROM hz_cust_accounts a
6577: WHERE a.party_id = pc_party_id
6578: AND status = 'A';
6579:
6580: l_msg_count number;

Line 6829: FROM hz_cust_accounts hca,

6825: -- SOLD_FROM (ship_from_cust_account_id, ship_from_site_id)
6826: CURSOR get_sf_cust_and_site(cv_cust_account_id IN NUMBER) IS
6827: SELECT hp.party_id
6828: , hp.party_name
6829: FROM hz_cust_accounts hca,
6830: hz_parties hp
6831: WHERE hp.party_id = hca.party_id
6832: AND hca.cust_account_id = cv_cust_account_id;
6833: