eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_UTIL_PUB dependencies on OKC_K_GRPINGS

Line 528: AND exists (Select 'x' from OKC_K_GRPINGS okg

524: SELECT hdr.id hdr_id, authoring_org_id org_id
525: FROM okc_k_headers_b hdr
526: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
527: AND Hdr.Template_yn = 'N'
528: AND exists (Select 'x' from OKC_K_GRPINGS okg
529: Where okg.included_chr_id = hdr.id
530: And okg.cgp_parent_id= cp_group_id)
531: AND Hdr.id = CP_CONTRACT_ID;
532:

Line 553: AND exists (Select 'x' from OKC_K_GRPINGS okg

549: SELECT hdr.id hdr_id, authoring_org_id org_id
550: FROM okc_k_headers_b hdr
551: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
552: AND Hdr.Template_yn = 'N'
553: AND exists (Select 'x' from OKC_K_GRPINGS okg
554: Where okg.included_chr_id = hdr.id
555: And okg.cgp_parent_id= cp_group_id);
556:
557: --CP_CONTRACT_ID is null