DBA Data[Home] [Help]

APPS.OKI_REFRESH_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 378: FROM okc_k_party_roles_b

374: , buff => ' ');
375: IF (p_object_name = 'OKI_SALES_K_HDRS')
376: THEN
377: FOR r_rec IN (SELECT dnz_chr_id, count(1) chr_count
378: FROM okc_k_party_roles_b
379: WHERE rle_code IN ('CUSTOMER','LICENSEE','BUYER')
380: AND cle_id is null
381: GROUP BY dnz_chr_id
382: HAVING COUNT(1) > 1)

Line 2649: , okc_k_party_roles_b cpl

2645: FROM
2646: okc_k_headers_b khr
2647: , oks_k_headers_b hoks -- 11510 Changes
2648: , oki_job_run_dtl jrd -- 11510 Changes
2649: , okc_k_party_roles_b cpl
2650: , okc_statuses_b sts
2651: , gl_periods spd
2652: , gl_periods spd1 -- 11510 Changes
2653: , okc_k_rel_objs ro

Line 3107: , okc_k_party_roles_b cpl

3103: FROM
3104: oki_job_run_dtl jrd
3105: , okc_k_headers_b khr
3106: , oks_k_headers_b hoks -- 11510 Changes
3107: , okc_k_party_roles_b cpl
3108: , okc_statuses_b sts
3109: , gl_periods spd
3110: , gl_periods spd1 -- 11510 Changes
3111: , okc_k_rel_objs ro