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_RULE_CONDITIONS

Line 434: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

430:
431: -- insert into the global temp table
432:
433: l_sql_string := 'select distinct to_char(cond.object_code) condition_question_id, to_char(object_value_id) outcome_question_id
434: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
435: where cond.object_type = ''QUESTION''
436: and outcome.object_type = ''QUESTION''
437: and cond.rule_id = outcome.rule_id
438: and cond.rule_id in (

Line 473: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

469:
470: UNION ALL
471:
472: select distinct to_char(cond.object_value_code) condition_question_id, to_char(object_value_id) outcome_question_id
473: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
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 (

Line 661: okc_xprt_rule_conditions c,

657: -- All DISTINCT Clauses from Conditions
658: SELECT v.object_value_code article_id,
659: a.article_title
660: FROM okc_xprt_rule_cond_vals v,
661: okc_xprt_rule_conditions c,
662: okc_xprt_rule_hdrs_all r,
663: okc_articles_all a
664: WHERE v.rule_condition_id = c.rule_condition_id
665: AND c.rule_id = r.rule_id

Line 906: okc_xprt_rule_conditions c,

902: -- All DISTINCT Clauses from Conditions
903: SELECT v.object_value_code article_id,
904: a.article_title
905: FROM okc_xprt_rule_cond_vals v,
906: okc_xprt_rule_conditions c,
907: okc_xprt_rule_hdrs_all r,
908: okc_articles_all a
909: WHERE v.rule_condition_id = c.rule_condition_id
910: AND c.rule_id = r.rule_id

Line 1096: FROM okc_xprt_rule_conditions c,

1092: -- Questions in Conditions
1093: SELECT DISTINCT q.question_name question_name,
1094: c.object_value_set_name value_set_name,
1095: q.question_id question_id
1096: FROM okc_xprt_rule_conditions c,
1097: okc_xprt_questions_vl q
1098: WHERE q.question_id = c.object_code
1099: AND c.object_type='QUESTION'
1100: AND c.object_code_datatype IN ('L','B')

Line 1117: FROM okc_xprt_rule_conditions c,

1113:
1114: -- List of Values used in Rule for a Question
1115: CURSOR csr_rule_question_values(p_question_id IN NUMBER) IS
1116: SELECT v.object_value_code question_value
1117: FROM okc_xprt_rule_conditions c,
1118: okc_xprt_rule_cond_vals v
1119: WHERE c.rule_condition_id = v.rule_condition_id
1120: AND c.object_type = 'QUESTION'
1121: AND c.object_code_datatype IN ('L','B')

Line 1512: FROM okc_xprt_rule_conditions c

1508: CURSOR csr_rule_variables IS
1509: SELECT DISTINCT okc_xprt_util_pvt.get_object_name(c.OBJECT_TYPE,c.OBJECT_CODE) variable_name,
1510: c.object_code variable_code,
1511: c.object_value_set_name value_set_name
1512: FROM okc_xprt_rule_conditions c
1513: WHERE c.rule_id = p_rule_id
1514: AND c.object_type = 'VARIABLE'
1515: AND c.object_code_datatype = 'V';
1516:

Line 1520: FROM okc_xprt_rule_conditions c,

1516:
1517: -- List of Values used in Rule for a Variable
1518: CURSOR csr_rule_variable_values(p_variable_name IN VARCHAR2) IS
1519: SELECT v.object_value_code variable_value
1520: FROM okc_xprt_rule_conditions c,
1521: okc_xprt_rule_cond_vals v
1522: WHERE c.rule_condition_id = v.rule_condition_id
1523: AND c.object_type = 'VARIABLE'
1524: AND c.object_code_datatype = 'V'

Line 1994: FROM okc_xprt_rule_conditions c,

1990: -- List of questions used in rule
1991: CURSOR csr_rule_questions IS
1992: -- Questions in Conditions LHS
1993: SELECT DISTINCT q.question_name question_name
1994: FROM okc_xprt_rule_conditions c,
1995: okc_xprt_questions_vl q
1996: WHERE q.question_id = c.object_code
1997: AND c.object_type='QUESTION'
1998: AND c.rule_id = p_rule_id

Line 2003: FROM okc_xprt_rule_conditions c,

1999: AND q.disabled_flag = 'Y'
2000: UNION
2001: -- Questions in Conditions RHS
2002: SELECT DISTINCT q.question_name question_name
2003: FROM okc_xprt_rule_conditions c,
2004: okc_xprt_questions_vl q
2005: WHERE q.question_id = c.object_value_code
2006: AND c.object_value_type='QUESTION'
2007: AND c.rule_id = p_rule_id

Line 2281: okc_xprt_rule_conditions rcon,

2277: rcon.object_code variable_code, -- LHS of Condition
2278: t.variable_name variable_name,
2279: rhdr.rule_name rule_name
2280: FROM okc_xprt_rule_hdrs_all rhdr,
2281: okc_xprt_rule_conditions rcon,
2282: okc_bus_variables_b v,
2283: okc_bus_variables_tl t
2284: WHERE rhdr.rule_id = rcon.rule_id
2285: AND rhdr.rule_id = p_rule_id

Line 2297: okc_xprt_rule_conditions rcon,

2293: rcon.object_value_code variable_code, -- RHS of Condition
2294: t.variable_name variable_name,
2295: rhdr.rule_name rule_name
2296: FROM okc_xprt_rule_hdrs_all rhdr,
2297: okc_xprt_rule_conditions rcon,
2298: okc_bus_variables_b v,
2299: okc_bus_variables_tl t
2300: WHERE rhdr.rule_id = rcon.rule_id
2301: AND rhdr.rule_id = p_rule_id