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 396: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

392:
393: -- insert into the global temp table
394:
395: l_sql_string := 'select distinct to_char(cond.object_code) condition_question_id, to_char(object_value_id) outcome_question_id
396: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
397: where cond.object_type = ''QUESTION''
398: and outcome.object_type = ''QUESTION''
399: and cond.rule_id = outcome.rule_id
400: and cond.rule_id in (

Line 435: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

431:
432: UNION ALL
433:
434: select distinct to_char(cond.object_value_code) condition_question_id, to_char(object_value_id) outcome_question_id
435: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
436: where cond.object_value_type = ''QUESTION''
437: and outcome.object_type = ''QUESTION''
438: and cond.rule_id = outcome.rule_id
439: and cond.rule_id in (

Line 623: okc_xprt_rule_conditions c,

619: -- All DISTINCT Clauses from Conditions
620: SELECT v.object_value_code article_id,
621: a.article_title
622: FROM okc_xprt_rule_cond_vals v,
623: okc_xprt_rule_conditions c,
624: okc_xprt_rule_hdrs_all r,
625: okc_articles_all a
626: WHERE v.rule_condition_id = c.rule_condition_id
627: AND c.rule_id = r.rule_id

Line 847: okc_xprt_rule_conditions c,

843: -- All DISTINCT Clauses from Conditions
844: SELECT v.object_value_code article_id,
845: a.article_title
846: FROM okc_xprt_rule_cond_vals v,
847: okc_xprt_rule_conditions c,
848: okc_xprt_rule_hdrs_all r,
849: okc_articles_all a
850: WHERE v.rule_condition_id = c.rule_condition_id
851: AND c.rule_id = r.rule_id

Line 1025: FROM okc_xprt_rule_conditions c,

1021: -- Questions in Conditions
1022: SELECT DISTINCT q.question_name question_name,
1023: c.object_value_set_name value_set_name,
1024: q.question_id question_id
1025: FROM okc_xprt_rule_conditions c,
1026: okc_xprt_questions_vl q
1027: WHERE q.question_id = c.object_code
1028: AND c.object_type='QUESTION'
1029: AND c.object_code_datatype IN ('L','B')

Line 1046: FROM okc_xprt_rule_conditions c,

1042:
1043: -- List of Values used in Rule for a Question
1044: CURSOR csr_rule_question_values(p_question_id IN NUMBER) IS
1045: SELECT v.object_value_code question_value
1046: FROM okc_xprt_rule_conditions c,
1047: okc_xprt_rule_cond_vals v
1048: WHERE c.rule_condition_id = v.rule_condition_id
1049: AND c.object_type = 'QUESTION'
1050: AND c.object_code_datatype IN ('L','B')

Line 1441: FROM okc_xprt_rule_conditions c

1437: CURSOR csr_rule_variables IS
1438: SELECT DISTINCT okc_xprt_util_pvt.get_object_name(c.OBJECT_TYPE,c.OBJECT_CODE) variable_name,
1439: c.object_code variable_code,
1440: c.object_value_set_name value_set_name
1441: FROM okc_xprt_rule_conditions c
1442: WHERE c.rule_id = p_rule_id
1443: AND c.object_type = 'VARIABLE'
1444: AND c.object_code_datatype = 'V';
1445:

Line 1449: FROM okc_xprt_rule_conditions c,

1445:
1446: -- List of Values used in Rule for a Variable
1447: CURSOR csr_rule_variable_values(p_variable_name IN VARCHAR2) IS
1448: SELECT v.object_value_code variable_value
1449: FROM okc_xprt_rule_conditions c,
1450: okc_xprt_rule_cond_vals v
1451: WHERE c.rule_condition_id = v.rule_condition_id
1452: AND c.object_type = 'VARIABLE'
1453: AND c.object_code_datatype = 'V'

Line 1923: FROM okc_xprt_rule_conditions c,

1919: -- List of questions used in rule
1920: CURSOR csr_rule_questions IS
1921: -- Questions in Conditions LHS
1922: SELECT DISTINCT q.question_name question_name
1923: FROM okc_xprt_rule_conditions c,
1924: okc_xprt_questions_vl q
1925: WHERE q.question_id = c.object_code
1926: AND c.object_type='QUESTION'
1927: AND c.rule_id = p_rule_id

Line 1932: FROM okc_xprt_rule_conditions c,

1928: AND q.disabled_flag = 'Y'
1929: UNION
1930: -- Questions in Conditions RHS
1931: SELECT DISTINCT q.question_name question_name
1932: FROM okc_xprt_rule_conditions c,
1933: okc_xprt_questions_vl q
1934: WHERE q.question_id = c.object_value_code
1935: AND c.object_value_type='QUESTION'
1936: AND c.rule_id = p_rule_id

Line 2210: okc_xprt_rule_conditions rcon,

2206: rcon.object_code variable_code, -- LHS of Condition
2207: t.variable_name variable_name,
2208: rhdr.rule_name rule_name
2209: FROM okc_xprt_rule_hdrs_all rhdr,
2210: okc_xprt_rule_conditions rcon,
2211: okc_bus_variables_b v,
2212: okc_bus_variables_tl t
2213: WHERE rhdr.rule_id = rcon.rule_id
2214: AND rhdr.rule_id = p_rule_id

Line 2226: okc_xprt_rule_conditions rcon,

2222: rcon.object_value_code variable_code, -- RHS of Condition
2223: t.variable_name variable_name,
2224: rhdr.rule_name rule_name
2225: FROM okc_xprt_rule_hdrs_all rhdr,
2226: okc_xprt_rule_conditions rcon,
2227: okc_bus_variables_b v,
2228: okc_bus_variables_tl t
2229: WHERE rhdr.rule_id = rcon.rule_id
2230: AND rhdr.rule_id = p_rule_id