DBA Data[Home] [Help]

APPS.INL_RULE_PVT dependencies on INL_ATTRIBUTES_VL

Line 115: inl_attributes_vl LeftAttr,

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
119: AND RightAttr.entity_code (+) = c.right_entity_code

Line 117: inl_attributes_vl RightAttr

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
121: AND LeftEnt.entity_code = c.left_entity_code

Line 810: inl_attributes_vl RAttr

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')
814: ORDER BY c.user_sequence;

Line 1277: inl_attributes_vl RAttr

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')
1281: ORDER BY c.user_sequence;