DBA Data[Home] [Help]

APPS.INL_RULE_PVT dependencies on INL_ENTITIES_VL

Line 114: inl_entities_vl LeftEnt,

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
118: WHERE RightAttr.attribute_code (+) = c.right_attribute_code

Line 116: inl_entities_vl RightEnt,

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
118: WHERE RightAttr.attribute_code (+) = c.right_attribute_code
119: AND RightAttr.entity_code (+) = c.right_entity_code
120: AND RightEnt.entity_code (+) = c.right_entity_code

Line 337: FROM inl_entities_vl e,

333: l_usage_code VARCHAR2(30);
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

Line 344: FROM inl_entities_vl e,

340: AND e.table_name IS NOT NULL
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;