APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITES

Line 2951: hz_party_sites c

2947: a.cust_account_id,
2948: a.org_id
2949: FROM hz_cust_acct_sites_all a,
2950: hz_cust_site_uses_all b,
2951: hz_party_sites c
2952: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2953: AND c.party_site_id = a.party_site_id
2954: AND b.site_use_id = p_site_use_id;
2955:

Line 3769: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,

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'
3773: AND ohs.org_id = okc_context.get_okc_org_id

Line 3799: HZ_PARTY_SITES PS,

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
3803: WHERE ohs.hold_entity_code = 'C'

Line 3831: HZ_PARTY_SITES PS,

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
3835: WHERE ohs.hold_entity_code = 'B'

Line 4455: FROM HZ_PARTY_SITES -- okx_party_sites_v

4451: -- Changed this cursor because object1_id1 will be holding the party_site_id
4452: -- not the customer site use id.
4453: CURSOR l_covsit_csr(partySiteId NUMBER) IS
4454: SELECT status
4455: FROM HZ_PARTY_SITES -- okx_party_sites_v
4456: WHERE party_site_id = partySiteId;
4457:
4458: --Changed cursor because ste_code does not have QA_HOLD
4459: CURSOR l_hdr_csr(l_chr_id NUMBER) IS