APPS.OKC_DBTREE_PVT dependencies on OKC_K_GRPINGS

Line 361: from okc_k_grpings_v p

357: creation_date,
358: okc_query.GetChildCount(id) numchildren
359: from okc_k_groups_v g
360: where NOT EXISTS (select 1
361: from okc_k_grpings_v p
362: where p.included_cgp_id = g.id)
363: AND ( (g.public_yn = decode(gflag,'U','Y',gflag,'A','Y'))
364: OR (g.public_yn = decode(gflag,'P','N') AND created_by = 10589)
365: OR (gflag = 'A' AND created_by = 10589)

Line 381: from okc_k_grpings_v p

377: creation_date,
378: okc_query.GetChildCount(id) numchildren
379: from okc_k_groups_v g
380: where NOT EXISTS (select 1
381: from okc_k_grpings_v p
382: where p.included_cgp_id = g.id)
383: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
384: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
385: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)

Line 403: from okc_k_grpings_v p, okc_k_groups_v g1

399: okc_query.GetChildCount(id) numchildren
400: from okc_k_groups_v g
401: where NOT EXISTS (
402: select 1
403: from okc_k_grpings_v p, okc_k_groups_v g1
404: where p.included_cgp_id = g.id
405: and g1.id = p.cgp_parent_id
406: and g1.public_yn = 'Y'
407:

Line 411: from okc_k_grpings_v p, okc_k_groups_v g1

407:
408: UNION
409:
410: select 1
411: from okc_k_grpings_v p, okc_k_groups_v g1
412: where p.included_cgp_id = g.id
413: and g1.id = p.cgp_parent_id
414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
415: )

Line 619: from okc_k_grpings g,

615: g.included_cgp_id occur_id,
616: t.name node_name,
617: b.public_yn,
618: okc_query.GetChildCount(b.id) numchildren
619: from okc_k_grpings g,
620: okc_k_groups_b b,
621: okc_k_groups_tl t
622: where g.cgp_parent_id = p_grp_id
623: and g.included_cgp_id IS NOT NULL

Line 633: -- from okc_k_grpings g,

629: -- g.id node_id,
630: -- g.included_chr_id occur_id,
631: -- b.contract_number node_name,
632: -- okc_query.GetChildCount(b.id) numchildren
633: -- from okc_k_grpings g,
634: -- okc_k_headers_b b,
635: -- okc_k_headers_tl t
636: -- where g.cgp_parent_id = p_grp_id
637: -- and g.included_chr_id IS NOT NULL