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_IMPORT_RULES_PVT dependencies on OKC_XPRT_RULE_CONDITIONS

Line 97: FROM okc_xprt_rule_conditions c

93: 'IS_NOT','NOTTRUE',
94: 'NOT_IN','NOTTRUE',
95: c.operator),
96: c.object_value_type
97: FROM okc_xprt_rule_conditions c
98: WHERE c.rule_id = p_rule_id;
99:
100: /*CURSOR csr_rule_cond_vals(p_rule_condition_id IN NUMBER) IS
101: SELECT v.object_value_code

Line 111: FROM okc_xprt_rule_cond_vals v, okc_xprt_rule_conditions c

107: 'VARIABLE',DECODE(SUBSTR(v.object_value_code,1,3),'OKC',v.object_value_code,'USER$' || v.object_value_code),
108: 'CONSTANT','CONSTANT$' || v.object_value_code,
109: v.object_value_code) object_value_code
110: --v.object_value_code
111: FROM okc_xprt_rule_cond_vals v, okc_xprt_rule_conditions c
112: WHERE v.rule_condition_id = c.rule_condition_id
113: AND v.rule_condition_id = p_rule_condition_id;
114:
115: CURSOR csr_rule_outcomes IS

Line 127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;

123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;

Line 128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;

124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;

Line 129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;

125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:

Line 130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;

126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;

Line 131: l_operator okc_xprt_rule_conditions.operator%TYPE;

127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;
135:

Line 132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;

128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;
130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;
135:
136: l_object_type_outcome okc_xprt_rule_outcomes.object_type%TYPE;