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.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 340: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp

336:
337: -- cursor to retrieve templates associated to the rule
338: CURSOR template_cursor IS
339: select distinct(temp.template_id) Template_Id, temp.org_id, temp.intent
340: from OKC_XPRT_TEMPLATE_RULES rules, okc_terms_templates_all temp
341: where rules.rule_id = p_rule_id
342: and rules.template_id = temp.template_id
343: and (sysdate between nvl(temp.start_date, sysdate) and nvl(temp.end_date, sysdate ))
344: UNION

Line 346: -- join to okc_xprt_template_rules

342: and rules.template_id = temp.template_id
343: and (sysdate between nvl(temp.start_date, sysdate) and nvl(temp.end_date, sysdate ))
344: UNION
345: -- Org Wide Rule templates. Reverted back the changes done for 5019422 by removing
346: -- join to okc_xprt_template_rules
347: SELECT t.template_id, t.org_id, t.intent
348: FROM okc_terms_templates_all t,
349: okc_xprt_rule_hdrs_all r
350: WHERE t.org_id = r.org_id

Line 440: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

436: and outcome.object_type = ''QUESTION''
437: and cond.rule_id = outcome.rule_id
438: and cond.rule_id in (
439:
440: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
441: where assoc.rule_id = rules.rule_id
442: and assoc.template_id = ' ||l_Template_Id ||
443: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
444:

Line 463: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

459: ' and rule_id in '||l_request_rule_ids||
460:
461: ' UNION ALL
462:
463: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
464: where assoc.rule_id = rules.rule_id
465: and assoc.template_id = ' ||l_Template_Id||
466: ' and rules.rule_id in ' ||l_request_rule_ids||
467:

Line 478: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

474: where cond.object_value_type = ''QUESTION''
475: and outcome.object_type = ''QUESTION''
476: and cond.rule_id = outcome.rule_id
477: and cond.rule_id in (
478: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
479: where assoc.rule_id = rules.rule_id
480: and assoc.template_id = ' ||l_Template_Id||
481: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
482:

Line 501: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

497: ' and rule_id in ' ||l_request_rule_ids||
498:
499: ' UNION ALL
500:
501: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
502: where assoc.rule_id = rules.rule_id
503: and assoc.template_id = ' ||l_Template_Id||
504: ' and rules.rule_id in ' ||l_request_rule_ids||
505:

Line 2143: FROM okc_xprt_template_rules

2139: WHERE rule_id = p_rule_id;
2140:
2141: CURSOR csr_rule_templates IS
2142: SELECT 'x'
2143: FROM okc_xprt_template_rules
2144: WHERE rule_id = p_rule_id
2145: AND NVL(deleted_flag,'N') = 'N' ;
2146:
2147: l_api_name CONSTANT VARCHAR2(30) := 'check_rule_templates';