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 820: FROM hz_cust_accounts

816:
817: CURSOR chk_cust_account ( pc_account_id NUMBER)
818: IS
819: SELECT 'X'
820: FROM hz_cust_accounts
821: WHERE cust_account_id = pc_account_id;
822:
823: l_chk_flag VARCHAR2(1) := NULL;
824: time NUMBER;

Line 1065: FROM hz_cust_accounts

1061:
1062: CURSOR get_partner_party_id ( pc_account_id NUMBER )
1063: IS
1064: SELECT party_id
1065: FROM hz_cust_accounts
1066: WHERE cust_account_id = pc_account_id;
1067:
1068: l_party_contact_id NUMBER;
1069: l_party_id NUMBER;

Line 3087: FROM hz_cust_accounts cust

3083:
3084: CURSOR get_account_id (pc_party_Id NUMBER)
3085: IS
3086: SELECT cust.cust_account_id
3087: FROM hz_cust_accounts cust
3088: WHERE cust.party_id = pc_party_Id;
3089:
3090: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
3091: , pc_site_use VARCHAR2 )

Line 3106: , hz_cust_accounts hc

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;
3110:

Line 5148: FROM hz_cust_accounts cust

5144:
5145: CURSOR get_account_id (pc_party_Id NUMBER)
5146: IS
5147: SELECT cust.cust_account_id
5148: FROM hz_cust_accounts cust
5149: WHERE cust.party_id = pc_party_Id;
5150:
5151: CURSOR get_site_use_id ( pc_cust_account_id NUMBER
5152: , pc_party_site_id IN NUMBER

Line 5159: , hz_cust_accounts hc

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
5162: AND hps.party_id = hc.party_id
5163: AND hcs.cust_account_id = hc.cust_account_id

Line 5177: , hz_cust_accounts hc

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
5181: AND hcs.cust_account_id = hc.cust_account_id

Line 5192: , hz_cust_accounts hc

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
5195: AND hps.party_id = hc.party_id
5196: AND hcs.cust_account_id = hc.cust_account_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 5613: FROM hz_cust_accounts hca,

5609: SELECT hca.cust_account_id,
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

Line 5629: FROM hz_cust_accounts hca,

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

Line 5657: FROM hz_cust_accounts hca,

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

Line 5687: FROM hz_cust_accounts hca,

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

Line 5716: FROM hz_cust_accounts hca,

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

Line 5743: FROM hz_cust_accounts hca,

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

Line 7029: FROM hz_cust_accounts a

7025:
7026: CURSOR c_get_customer_accnt_id(pc_party_id NUMBER)
7027: IS
7028: SELECT a.cust_account_id
7029: FROM hz_cust_accounts a
7030: WHERE a.party_id = pc_party_id
7031: AND status = 'A';
7032:
7033: l_msg_count number;

Line 7283: FROM hz_cust_accounts hca,

7279: -- SOLD_FROM (ship_from_cust_account_id, ship_from_site_id)
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: