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_CLAIM_PVT dependencies on HZ_CUST_ACCOUNTS

Line 437: , hz_cust_accounts c

433: p_party_relationship_id in number) is
434: SELECT p.party_id -- ,p.party_name
435: FROM hz_relationships r -- Bug 4654753
436: , hz_parties p
437: , hz_cust_accounts c
438: WHERE r.subject_id = p.party_id
439: AND r.relationship_id = p_party_relationship_id -- Bug 4654753
440: AND r.object_id = c.party_id
441: AND c.cust_account_id = p_cust_account_id;

Line 752: FROM hz_cust_accounts

748: WHERE cust_acct_site_id = p_site_id;
749:
750: CURSOR cust_account_info_csr(p_cust_account_id in number) is
751: SELECT party_id, sales_channel_code
752: FROM hz_cust_accounts
753: WHERE CUST_ACCOUNT_ID = p_cust_account_id;
754:
755: -- waiting for customer_class_code query
756: --CURSOR cust_account_info_csr(p_cust_account_id in number) is

Line 758: --FROM hz_cust_accounts

754:
755: -- waiting for customer_class_code query
756: --CURSOR cust_account_info_csr(p_cust_account_id in number) is
757: --SELECT party_id, customer_class_code, sales_channel_code
758: --FROM hz_cust_accounts
759: --WHERE CUST_ACCOUNT_ID = p_cust_account_id;
760:
761: CURSOR party_info_csr(p_party_id in number)is
762: SELECT category_code

Line 1575: FROM HZ_CUST_ACCOUNTS

1571:
1572: --Cursor to get the party_id of the customer.
1573: CURSOR get_party_id_csr( p_cust_account_id IN NUMBER )IS
1574: SELECT party_id
1575: FROM HZ_CUST_ACCOUNTS
1576: WHERE cust_account_id = p_cust_account_id;
1577:
1578:
1579: --Cursor to get the Threshold amounts from the customers

Line 1940: FROM HZ_CUST_ACCOUNTS H

1936: l_msg_count NUMBER;
1937:
1938: CURSOR c_party_id(p_cust_id in number) IS
1939: SELECT h.party_id
1940: FROM HZ_CUST_ACCOUNTS H
1941: WHERE h.cust_account_id = p_cust_id;
1942:
1943: BEGIN
1944:

Line 3743: FROM hz_cust_accounts

3739:
3740: -- This cursor get the account_name of a cust_acc. We might not need it.
3741: CURSOR cust_account_name_csr(p_customer_account_id in number) IS
3742: SELECT account_name
3743: FROM hz_cust_accounts
3744: WHERE cust_account_id = p_customer_account_id;
3745:
3746: /* CURSOR org_id_csr IS -- R12 Enhancements
3747: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))

Line 4996: hz_cust_accounts cust, ozf_sys_parameters_all ozfsys

4992: type.name ClaimType,
4993: reason.name ClaimReason,
4994: claim.org_id
4995: from ozf_claims_all claim, ozf_claim_types_all_vl type, ozf_reason_codes_all_vl reason,
4996: hz_cust_accounts cust, ozf_sys_parameters_all ozfsys
4997: where
4998: type.claim_type_id = claim.claim_type_id AND
4999: reason.reason_code_id = ozfsys.reason_code_id AND
5000: claim.cust_account_id = cust.cust_account_id AND

Line 6184: FROM HZ_CUST_ACCOUNTS

6180: l_days_due number;
6181:
6182: CURSOR primary_sales_rep_id_csr(p_customer_account_id in number) IS
6183: SELECT primary_salesrep_id
6184: FROM HZ_CUST_ACCOUNTS
6185: WHERE cust_account_id = p_customer_account_id;
6186: l_sales_rep_id NUMBER;
6187:
6188: CURSOR user_status_id_csr (p_id in number) IS

Line 8155: from ozf_claims_all claim, hz_cust_accounts cust

8151: claim.deduction_attribute1 ClaimDedAttr12,
8152: claim.deduction_attribute1 ClaimDedAttr13,
8153: claim.deduction_attribute1 ClaimDedAttr14,
8154: claim.deduction_attribute1 ClaimDedAttr15
8155: from ozf_claims_all claim, hz_cust_accounts cust
8156: Where
8157: claim.cust_account_id = cust.cust_account_id AND
8158: claim.claim_id = ' || l_claim.claim_id);
8159:

Line 8202: from ozf_claims_all claim, hz_cust_accounts cust

8198: claim.deduction_attribute1 ClaimDedAttr13,
8199: claim.deduction_attribute1 ClaimDedAttr14,
8200: claim.deduction_attribute1 ClaimDedAttr15,
8201: claim.org_id
8202: from ozf_claims_all claim, hz_cust_accounts cust
8203: Where
8204: claim.cust_account_id = cust.cust_account_id AND
8205: claim.claim_id = ' || l_claim.claim_id);
8206: END IF;

Line 8266: from ozf_claims_all claim, hz_cust_accounts cust

8262: claim.deduction_attribute1 ClaimDedAttr13,
8263: claim.deduction_attribute1 ClaimDedAttr14,
8264: claim.deduction_attribute1 ClaimDedAttr15,
8265: claim.org_id
8266: from ozf_claims_all claim, hz_cust_accounts cust
8267: Where
8268: claim.cust_account_id = cust.cust_account_id AND
8269: claim.claim_id = ' || l_claim.claim_id);
8270:

Line 8386: hz_cust_accounts c

8382: p_party_id in number) IS
8383: SELECT count(p.party_id)
8384: FROM hz_parties p,
8385: hz_relationships r,
8386: hz_cust_accounts c
8387: WHERE p.party_id = r.subject_id
8388: AND r.relationship_code = p_relation_type
8389: AND r.object_id = c.party_id
8390: AND c.cust_account_id = p_cust_id

Line 8399: FROM hz_cust_accounts hca,

8395: CURSOR cust_site_csr(p_cust_id in number,
8396: p_site_use_code in varchar2,
8397: p_site_use_id in number) IS
8398: SELECT count(hcsu.site_use_id)
8399: FROM hz_cust_accounts hca,
8400: hz_cust_acct_sites hcas,
8401: hz_cust_site_uses hcsu
8402: WHERE hcas.cust_acct_site_id = hcsu.cust_acct_site_id
8403: AND hcas.cust_account_id = hca.cust_account_id

Line 9003: FROM hz_cust_accounts hca

8999: --l_number_of_reason_code_id number;
9000:
9001: CURSOR num_of_cust_acctid_csr(l_id in number) IS
9002: SELECT count(hca.cust_account_id)
9003: FROM hz_cust_accounts hca
9004: WHERE hca.cust_account_id = l_id;
9005: -- remove this condition for now AND hca.status = 'A'
9006:
9007: l_number_of_cust number;