APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_PARTIES

Line 3768: HZ_PARTIES prt,

3764: CURSOR check_cust_on_credit_hold
3765: IS
3766: SELECT prt.party_name
3767: FROM oe_hold_sources_all ohs,
3768: HZ_PARTIES prt,
3769: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3770: okc_k_headers_all_b rl
3771: WHERE ohs.hold_entity_code = 'C'
3772: AND ohs.released_flag = 'N'

Line 3798: HZ_PARTIES prt,

3794: 3,
3795: 4) credit_typ
3796: FROM oe_hold_sources_all ohs,
3797: oe_hold_definitions ohd,
3798: HZ_PARTIES prt,
3799: HZ_PARTY_SITES PS,
3800: HZ_CUST_ACCT_SITES_ALL CA,
3801: HZ_CUST_SITE_USES_ALL CS,
3802: okc_k_headers_all_b rl

Line 3830: HZ_PARTIES prt,

3826: 3,
3827: 4) credit_typ
3828: FROM oe_hold_sources_all ohs,
3829: oe_hold_definitions ohd,
3830: HZ_PARTIES prt,
3831: HZ_PARTY_SITES PS,
3832: HZ_CUST_ACCT_SITES_ALL CA,
3833: HZ_CUST_SITE_USES_ALL CS,
3834: okc_k_headers_all_b rl

Line 4423: FROM HZ_PARTIES --okx_parties_v

4419: AND serviceable_product_flag = 'Y';
4420:
4421: CURSOR l_covparty_csr(l_inv_id NUMBER) IS
4422: SELECT status
4423: FROM HZ_PARTIES --okx_parties_v
4424: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION') AND PARTY_ID = l_inv_id;
4425:
4426: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK

Line 6547: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6543: l_rel_cust_flag VARCHAR2 (5) := 'Y';
6544:
6545: CURSOR get_cust_id(l_cust_acct_id NUMBER) IS
6546: SELECT P.PARTY_NAME name, CA.PARTY_ID party_id
6547: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6548: WHERE CA.PARTY_ID = P.PARTY_ID AND
6549: CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6550:
6551: -- This cursor will return the party id of the customer or third party

Line 6732: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6728: CURSOR is_cust_hdr_active(l_party_id NUMBER) IS
6729: SELECT CA.CUST_ACCOUNT_ID,
6730: ca.status,
6731: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6732: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6733: WHERE CA.PARTY_ID = P.PARTY_ID
6734: AND P.PARTY_ID = l_party_id;
6735:
6736: -- GCHADHA --

Line 6756: hz_parties p

6752: p.party_id party_id
6753:
6754: FROM OKX_CUST_SITE_USES_V a,
6755: hz_cust_accounts c,
6756: hz_parties p
6757: WHERE a.id1 = p_bill_to_site_use_id
6758: AND c.cust_account_id = a.cust_account_id
6759: AND a.site_use_code = 'BILL_TO'
6760: AND p.party_id = c.party_id;

Line 6768: hz_parties p

6764: c.cust_account_id CUST_ID1,
6765: p.party_id party_id
6766: FROM OKX_CUST_SITE_USES_V a,
6767: hz_cust_accounts c,
6768: hz_parties p
6769: WHERE a.id1 = p_ship_to_site_use_id
6770: AND c.cust_account_id = a.cust_account_id
6771: AND a.site_use_code = 'SHIP_TO'
6772: AND p.party_id = c.party_id;

Line 6777: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6773:
6774: CURSOR Get_Status_Party (l_cust_acct_id IN NUMBER, l_party_id IN NUMBER) IS
6775: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6776: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6777: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6778: WHERE CA.PARTY_ID = P.PARTY_ID
6779: AND P.PARTY_ID = l_party_id
6780: AND CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6781:

Line 6813: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6809: -- Check whether the customer/third party is active or not.
6810: CURSOR Get_Status_Party_Main (l_party_id IN NUMBER) IS
6811: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6812: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6813: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6814: WHERE CA.PARTY_ID = P.PARTY_ID
6815: AND P.PARTY_ID = l_party_id
6816: AND CA.STATUS = 'A';
6817: