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.INL_RULE_PVT dependencies on INL_CONDITIONS

Line 113: FROM inl_conditions c,

109: LeftAttr.attribute_code left_column_name, c.right_entity_code, RightEnt.table_name right_tbl_name,
110: RightAttr.attribute_code right_column_name, c.attribute_constant_number, c.attribute_constant_character,
111: c.attribute_constant_date, c.attribute_expression, c.line_operator_code, c.right_parenthesis_code,
112: c.logical_operator_code
113: FROM inl_conditions c,
114: inl_entities_vl LeftEnt,
115: inl_attributes_vl LeftAttr,
116: inl_entities_vl RightEnt,
117: inl_attributes_vl RightAttr

Line 338: inl_conditions c

334:
335: CURSOR c_cond_tables(p_rule_id IN NUMBER) IS
336: SELECT DISTINCT e.entity_code, e.table_name || ' ' || e.entity_code AS from_table_name
337: FROM inl_entities_vl e,
338: inl_conditions c
339: WHERE e.entity_code = c.left_entity_code
340: AND e.table_name IS NOT NULL
341: AND c.rule_id = p_rule_id
342: UNION

Line 345: inl_conditions c

341: AND c.rule_id = p_rule_id
342: UNION
343: SELECT DISTINCT e.entity_code, e.table_name || ' ' || e.entity_code AS from_table_name
344: FROM inl_entities_vl e,
345: inl_conditions c
346: WHERE e.entity_code = c.right_entity_code
347: AND e.table_name IS NOT NULL
348: AND c.rule_id = p_rule_id;
349:

Line 543: FROM inl_conditions

539: -- In case there is no condition created, skip the
540: -- build query execution
541: SELECT COUNT(1)
542: INTO l_condition_count
543: FROM inl_conditions
544: WHERE rule_id = p_rule_id;
545:
546: IF NVL(l_condition_count,0) = 0 THEN
547: RETURN NULL;

Line 809: FROM inl_conditions c,

805: DECODE(c.right_entity_code,'CONS_NUMBER', 'NUMBER',
806: DECODE(c.right_entity_code,'CONS_DATE', 'DATE', NULL))) AS datatype,
807: c.attribute_expression, c.attribute_constant_character,
808: c.attribute_constant_number, c.attribute_constant_date
809: FROM inl_conditions c,
810: inl_attributes_vl RAttr
811: WHERE RAttr.attribute_code (+) = c.right_attribute_code
812: AND c.rule_id = p_rule_id
813: AND c.right_entity_code IN ('CONS_CHAR', 'CONS_NUMBER', 'CONS_DATE')

Line 1217: FROM inl_conditions c

1213: l_right_attr_exp VARCHAR2(240);
1214:
1215: CURSOR c_desc_parenthesis(p_rule_id IN NUMBER)IS
1216: SELECT count(1)
1217: FROM inl_conditions c
1218: WHERE c.rule_id = p_rule_id
1219: AND c.left_parenthesis_code IS NOT NULL
1220: MINUS
1221: SELECT count(1)

Line 1222: FROM inl_conditions c1

1218: WHERE c.rule_id = p_rule_id
1219: AND c.left_parenthesis_code IS NOT NULL
1220: MINUS
1221: SELECT count(1)
1222: FROM inl_conditions c1
1223: WHERE c1.rule_id = p_rule_id
1224: AND c1.right_parenthesis_code IS NOT NULL;
1225: TYPE desc_parenthesis IS
1226: TABLE OF c_desc_parenthesis%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1232: FROM inl_conditions c

1228:
1229: CURSOR c_precedence_parenthesis(p_rule_id IN NUMBER) IS
1230: SELECT c.user_sequence, c.left_parenthesis_code,
1231: c.right_parenthesis_code, NULL AS right_parenthesis_close
1232: FROM inl_conditions c
1233: WHERE rule_id = p_rule_id
1234: ORDER BY c.user_sequence;
1235:
1236: TYPE precedence_parenthesis IS

Line 1244: FROM inl_conditions c

1240: -- Get all rows which are not the last row or rows with just left parenthesis
1241: -- and have no logical operator
1242: CURSOR c_no_logical_operator(p_sequence NUMBER) IS
1243: SELECT c.user_sequence
1244: FROM inl_conditions c
1245: WHERE c.rule_id = p_rule_id
1246: AND c.logical_operator_code IS NULL
1247: AND c.user_sequence <> p_sequence
1248: AND NOT EXISTS (SELECT condition_id

Line 1249: FROM inl_conditions c2

1245: WHERE c.rule_id = p_rule_id
1246: AND c.logical_operator_code IS NULL
1247: AND c.user_sequence <> p_sequence
1248: AND NOT EXISTS (SELECT condition_id
1249: FROM inl_conditions c2
1250: WHERE c2.rule_id = p_rule_id
1251: AND c2.left_parenthesis_code IS NOT NULL
1252: AND c2.left_entity_code IS NULL
1253: AND c2.condition_id = c.condition_id);

Line 1261: FROM inl_conditions c

1257: -- Check if next row has only right parentheses
1258: -- and have no logical operator
1259: CURSOR c_only_right_parenthesis IS
1260: SELECT 'x'
1261: FROM inl_conditions c
1262: WHERE c.rule_id = p_rule_id
1263: AND c.left_entity_code IS NULL
1264: AND c.right_parenthesis_code IS NOT NULL
1265: AND c.user_sequence = (SELECT a.user_sequence

Line 1266: FROM inl_conditions a

1262: WHERE c.rule_id = p_rule_id
1263: AND c.left_entity_code IS NULL
1264: AND c.right_parenthesis_code IS NOT NULL
1265: AND c.user_sequence = (SELECT a.user_sequence
1266: FROM inl_conditions a
1267: WHERE a.rule_id = c.rule_id
1268: AND a.user_sequence > l_no_logical_operator.user_sequence
1269: AND rownum = 1);
1270:

Line 1276: FROM inl_conditions c,

1272: CURSOR c_right_attrs(p_rule_id IN NUMBER) IS
1273: SELECT c.user_sequence, c.right_entity_code, RAttr.datatype_code,
1274: c.attribute_expression, c.attribute_constant_character,
1275: c.attribute_constant_number, c.attribute_constant_date
1276: FROM inl_conditions c,
1277: inl_attributes_vl RAttr
1278: WHERE RAttr.attribute_code (+) = c.right_attribute_code
1279: AND c.rule_id = p_rule_id
1280: AND c.right_entity_code IN ( 'EXPR', 'CONS_CHAR')

Line 1317: FROM inl_conditions c

1313:
1314: -- Verify if Rule has condition line(s)
1315: SELECT count(1)
1316: INTO l_count_condition
1317: FROM inl_conditions c
1318: WHERE c.rule_id = p_rule_id;
1319:
1320: IF(NVL(l_count_condition,0) = 0) THEN
1321: FND_MESSAGE.SET_NAME('INL', 'INL_ERR_COND_NOT_COMPLETED') ;

Line 1349: FROM inl_conditions c

1345:
1346: IF l_return = 'TRUE' THEN
1347: SELECT NVL(max(user_sequence),0)
1348: INTO l_max_left_seq
1349: FROM inl_conditions c
1350: WHERE c.rule_id = p_rule_id
1351: AND c.left_parenthesis_code IS NOT NULL;
1352:
1353: SELECT NVL(max(user_sequence),0)

Line 1355: FROM inl_conditions c

1351: AND c.left_parenthesis_code IS NOT NULL;
1352:
1353: SELECT NVL(max(user_sequence),0)
1354: INTO l_max_right_seq
1355: FROM inl_conditions c
1356: WHERE c.rule_id = p_rule_id
1357: AND c.right_parenthesis_code IS NOT NULL;
1358:
1359: IF l_max_right_seq < l_max_left_seq then

Line 1370: FROM inl_conditions c

1366:
1367: IF l_return = 'TRUE' THEN
1368: SELECT NVL(min(user_sequence),0)
1369: INTO l_min_left_seq
1370: FROM inl_conditions c
1371: WHERE c.rule_id = p_rule_id
1372: AND c.left_parenthesis_code IS NOT NULL;
1373:
1374: SELECT NVL(min(user_sequence),0)

Line 1376: FROM inl_conditions c

1372: AND c.left_parenthesis_code IS NOT NULL;
1373:
1374: SELECT NVL(min(user_sequence),0)
1375: INTO l_min_right_seq
1376: FROM inl_conditions c
1377: WHERE c.rule_id = p_rule_id
1378: AND c.right_parenthesis_code IS NOT NULL;
1379:
1380: IF l_min_right_seq < l_min_left_seq then

Line 1433: FROM inl_conditions c

1429: -- Check if condition has wrong number of logical operators
1430: IF l_return = 'TRUE' THEN
1431: SELECT max(user_sequence)
1432: INTO l_desc_user_sequence
1433: FROM inl_conditions c
1434: WHERE c.rule_id = p_rule_id;
1435:
1436: -- Check if last row has logical operator
1437: SELECT count(1)

Line 1439: FROM inl_conditions c

1435:
1436: -- Check if last row has logical operator
1437: SELECT count(1)
1438: INTO l_last_row_with_logical_oper
1439: FROM inl_conditions c
1440: WHERE c.rule_id = p_rule_id
1441: AND c.user_sequence = l_desc_user_sequence
1442: AND c.logical_operator_code IS NOT NULL;
1443: