APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_PARTIES

Line 3696: HZ_PARTIES prt,

3692: CURSOR check_cust_on_credit_hold
3693: IS
3694: SELECT prt.party_name
3695: FROM oe_hold_sources_all ohs,
3696: HZ_PARTIES prt,
3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3698: okc_k_headers_all_b rl
3699: WHERE ohs.hold_entity_code = 'C'
3700: AND ohs.released_flag = 'N'

Line 4276: FROM HZ_PARTIES --okx_parties_v

4272: AND serviceable_product_flag = 'Y';
4273:
4274: CURSOR l_covparty_csr(l_inv_id NUMBER) IS
4275: SELECT status
4276: FROM HZ_PARTIES --okx_parties_v
4277: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION') AND PARTY_ID = l_inv_id;
4278:
4279: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4280: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK

Line 6400: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6396: l_rel_cust_flag VARCHAR2 (5) := 'Y';
6397:
6398: CURSOR get_cust_id(l_cust_acct_id NUMBER) IS
6399: SELECT P.PARTY_NAME name, CA.PARTY_ID party_id
6400: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6401: WHERE CA.PARTY_ID = P.PARTY_ID AND
6402: CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6403:
6404: -- This cursor will return the party id of the customer or third party

Line 6585: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6581: CURSOR is_cust_hdr_active(l_party_id NUMBER) IS
6582: SELECT CA.CUST_ACCOUNT_ID,
6583: ca.status,
6584: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6585: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6586: WHERE CA.PARTY_ID = P.PARTY_ID
6587: AND P.PARTY_ID = l_party_id;
6588:
6589: -- GCHADHA --

Line 6609: hz_parties p

6605: p.party_id party_id
6606:
6607: FROM OKX_CUST_SITE_USES_V a,
6608: hz_cust_accounts c,
6609: hz_parties p
6610: WHERE a.id1 = p_bill_to_site_use_id
6611: AND c.cust_account_id = a.cust_account_id
6612: AND a.site_use_code = 'BILL_TO'
6613: AND p.party_id = c.party_id;

Line 6621: hz_parties p

6617: c.cust_account_id CUST_ID1,
6618: p.party_id party_id
6619: FROM OKX_CUST_SITE_USES_V a,
6620: hz_cust_accounts c,
6621: hz_parties p
6622: WHERE a.id1 = p_ship_to_site_use_id
6623: AND c.cust_account_id = a.cust_account_id
6624: AND a.site_use_code = 'SHIP_TO'
6625: AND p.party_id = c.party_id;

Line 6630: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6626:
6627: CURSOR Get_Status_Party (l_cust_acct_id IN NUMBER, l_party_id IN NUMBER) IS
6628: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6629: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6630: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6631: WHERE CA.PARTY_ID = P.PARTY_ID
6632: AND P.PARTY_ID = l_party_id
6633: AND CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6634:

Line 6664: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6660: -- Check whether the customer/third party is active or not.
6661: CURSOR Get_Status_Party_Main (l_party_id IN NUMBER) IS
6662: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6663: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6664: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6665: WHERE CA.PARTY_ID = P.PARTY_ID
6666: AND P.PARTY_ID = l_party_id
6667: AND CA.STATUS = 'A';
6668: