APPS.AME_ENGINE dependencies on AME_RULE_USAGES

Line 3207: ame_rule_usages.priority priority,

3203: ame_rules.rule_id rule_id,
3204: nvl(ame_rules.item_class_id,
3205: headerItemClassIdIn) item_class_id,
3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category
3209: from
3210: ame_rules,
3211: ame_rule_usages,

Line 3208: ame_rule_usages.approver_category approver_category

3204: nvl(ame_rules.item_class_id,
3205: headerItemClassIdIn) item_class_id,
3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category
3209: from
3210: ame_rules,
3211: ame_rule_usages,
3212: ame_item_class_usages

Line 3211: ame_rule_usages,

3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category
3209: from
3210: ame_rules,
3211: ame_rule_usages,
3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and
3215: ame_rule_usages.item_id = engAmeApplicationId and

Line 3214: ame_rules.rule_id = ame_rule_usages.rule_id and

3210: ame_rules,
3211: ame_rule_usages,
3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and
3215: ame_rule_usages.item_id = engAmeApplicationId and
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or

Line 3215: ame_rule_usages.item_id = engAmeApplicationId and

3211: ame_rule_usages,
3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and
3215: ame_rule_usages.item_id = engAmeApplicationId and
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or
3219: (ame_rules.rule_type = ame_util.combinationRuleType and

Line 3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or

3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or
3219: (ame_rules.rule_type = ame_util.combinationRuleType and
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3222: (ame_rules.rule_type = ame_util.authorityRuleType and
3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and

Line 3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or

3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3222: (ame_rules.rule_type = ame_util.authorityRuleType and
3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and
3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and

Line 3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or

3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and
3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and
3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and

Line 3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or

3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and
3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and
3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and

Line 3233: substRuleThresholdIn >= ame_rule_usages.priority)) or

3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and
3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and

Line 3236: preRuleThresholdIn >= ame_rule_usages.priority)) or

3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3239: postRuleThresholdIn >= ame_rule_usages.priority)) or
3240: (ame_rules.rule_type = ame_util.productionRuleType and

Line 3239: postRuleThresholdIn >= ame_rule_usages.priority)) or

3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3239: postRuleThresholdIn >= ame_rule_usages.priority)) or
3240: (ame_rules.rule_type = ame_util.productionRuleType and
3241: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3242: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3243: (processProductionRulesIn = ame_util.booleanTrue or

Line 3242: productionRuleThresholdIn >= ame_rule_usages.priority))) and

3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3239: postRuleThresholdIn >= ame_rule_usages.priority)) or
3240: (ame_rules.rule_type = ame_util.productionRuleType and
3241: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3242: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3243: (processProductionRulesIn = ame_util.booleanTrue or
3244: ame_rules.rule_type <> ame_util.productionRuleType) and
3245: not exists (select *
3246: from

Line 3265: ame_rule_usages.start_date and

3261: engEffectiveRuleDate between
3262: ame_rules.start_date and
3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3264: engEffectiveRuleDate between
3265: ame_rule_usages.start_date and
3266: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3267: engEffectiveRuleDate between
3268: ame_item_class_usages.start_date and
3269: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

Line 3266: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3262: ame_rules.start_date and
3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3264: engEffectiveRuleDate between
3265: ame_rule_usages.start_date and
3266: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3267: engEffectiveRuleDate between
3268: ame_item_class_usages.start_date and
3269: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3270: order by

Line 3489: ame_rule_usages

3485: from
3486: ame_attributes,
3487: ame_conditions,
3488: ame_condition_usages,
3489: ame_rule_usages
3490: where
3491: ame_attributes.attribute_type = ame_util.stringAttributeType and
3492: ame_attributes.attribute_id = ame_conditions.attribute_id and
3493: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 3494: ame_condition_usages.rule_id = ame_rule_usages.rule_id and

3490: where
3491: ame_attributes.attribute_type = ame_util.stringAttributeType and
3492: ame_attributes.attribute_id = ame_conditions.attribute_id and
3493: ame_conditions.condition_id = ame_condition_usages.condition_id and
3494: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3495: ame_rule_usages.item_id = engAmeApplicationId and
3496: engEffectiveRuleDate between
3497: ame_attributes.start_date and
3498: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3495: ame_rule_usages.item_id = engAmeApplicationId and

3491: ame_attributes.attribute_type = ame_util.stringAttributeType and
3492: ame_attributes.attribute_id = ame_conditions.attribute_id and
3493: ame_conditions.condition_id = ame_condition_usages.condition_id and
3494: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3495: ame_rule_usages.item_id = engAmeApplicationId and
3496: engEffectiveRuleDate between
3497: ame_attributes.start_date and
3498: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3499: engEffectiveRuleDate between

Line 3506: ame_rule_usages.start_date and

3502: engEffectiveRuleDate between
3503: ame_condition_usages.start_date and
3504: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3505: engEffectiveRuleDate between
3506: ame_rule_usages.start_date and
3507: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and
3508: engEffectiveRuleDate between
3509: ame_string_values.start_date and
3510: nvl(ame_string_values.end_date - ame_util.oneSecond, engEffectiveRuleDate)

Line 3507: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and

3503: ame_condition_usages.start_date and
3504: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3505: engEffectiveRuleDate between
3506: ame_rule_usages.start_date and
3507: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and
3508: engEffectiveRuleDate between
3509: ame_string_values.start_date and
3510: nvl(ame_string_values.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3511: order by condition_id;

Line 3544: ame_rule_usages.priority priority,

3540: ame_condition_usages.rule_id rule_id,
3541: ame_rules.rule_type rule_type,
3542: nvl(ame_rules.item_class_id,
3543: headerItemClassIdIn) rule_item_class,
3544: ame_rule_usages.priority priority,
3545: ame_rule_usages.approver_category
3546: from
3547: ame_attributes,
3548: ame_conditions,

Line 3545: ame_rule_usages.approver_category

3541: ame_rules.rule_type rule_type,
3542: nvl(ame_rules.item_class_id,
3543: headerItemClassIdIn) rule_item_class,
3544: ame_rule_usages.priority priority,
3545: ame_rule_usages.approver_category
3546: from
3547: ame_attributes,
3548: ame_conditions,
3549: ame_condition_usages,

Line 3551: ame_rule_usages

3547: ame_attributes,
3548: ame_conditions,
3549: ame_condition_usages,
3550: ame_rules,
3551: ame_rule_usages
3552: where
3553: ame_attributes.attribute_id = ame_conditions.attribute_id and
3554: ame_conditions.condition_type <> ame_util.listModConditionType and
3555: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 3557: ame_rules.rule_id = ame_rule_usages.rule_id and

3553: ame_attributes.attribute_id = ame_conditions.attribute_id and
3554: ame_conditions.condition_type <> ame_util.listModConditionType and
3555: ame_conditions.condition_id = ame_condition_usages.condition_id and
3556: ame_condition_usages.rule_id = ame_rules.rule_id and
3557: ame_rules.rule_id = ame_rule_usages.rule_id and
3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3558: ame_rule_usages.item_id = engAmeApplicationId and

3554: ame_conditions.condition_type <> ame_util.listModConditionType and
3555: ame_conditions.condition_id = ame_condition_usages.condition_id and
3556: ame_condition_usages.rule_id = ame_rules.rule_id and
3557: ame_rules.rule_id = ame_rule_usages.rule_id and
3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or

Line 3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or

3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3563: (ame_rules.rule_type = ame_util.authorityRuleType and
3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and

Line 3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or

3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3563: (ame_rules.rule_type = ame_util.authorityRuleType and
3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and
3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and

Line 3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or

3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and
3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and
3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and

Line 3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or

3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and
3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and
3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and

Line 3574: substRuleThresholdIn >= ame_rule_usages.priority)) or

3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and
3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and

Line 3577: preRuleThresholdIn >= ame_rule_usages.priority)) or

3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3580: postRuleThresholdIn >= ame_rule_usages.priority)) or
3581: (ame_rules.rule_type = ame_util.productionRuleType and

Line 3580: postRuleThresholdIn >= ame_rule_usages.priority)) or

3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3580: postRuleThresholdIn >= ame_rule_usages.priority)) or
3581: (ame_rules.rule_type = ame_util.productionRuleType and
3582: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3583: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3584: (processProductionRulesIn = ame_util.booleanTrue or

Line 3583: productionRuleThresholdIn >= ame_rule_usages.priority))) and

3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3580: postRuleThresholdIn >= ame_rule_usages.priority)) or
3581: (ame_rules.rule_type = ame_util.productionRuleType and
3582: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3583: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3584: (processProductionRulesIn = ame_util.booleanTrue or
3585: ame_rules.rule_type <> ame_util.productionRuleType) and
3586: engEffectiveRuleDate between
3587: ame_attributes.start_date and

Line 3599: ame_rule_usages.start_date and

3595: engEffectiveRuleDate between
3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3598: engEffectiveRuleDate between
3599: ame_rule_usages.start_date and
3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3601: order by
3602: rule_item_class,
3603: ame_rules.rule_type,

Line 3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3598: engEffectiveRuleDate between
3599: ame_rule_usages.start_date and
3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3601: order by
3602: rule_item_class,
3603: ame_rules.rule_type,
3604: ame_rules.rule_id,

Line 4388: ame_rule_usages

4384: select 1
4385: from ame_conditions,
4386: ame_condition_usages,
4387: ame_rules,
4388: ame_rule_usages
4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id

Line 4392: and ame_rules.rule_id = ame_rule_usages.rule_id

4388: ame_rule_usages
4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4393: and ame_rule_usages.item_id = applicationIdIn

4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))

Line 4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date

4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4398: and engEffectiveRuleDate between ame_conditions.start_date
4399: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)
4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date

Line 4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))

4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4398: and engEffectiveRuleDate between ame_conditions.start_date
4399: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)
4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4401: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))

Line 4408: ame_rule_usages

4404: from ame_mandatory_attributes,
4405: ame_actions,
4406: ame_action_usages,
4407: ame_rules,
4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id

Line 4414: and ame_rules.rule_id = ame_rule_usages.rule_id

4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4415: and ame_rule_usages.item_id = applicationIdIn

4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))

Line 4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date

4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date

Line 4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))

4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date
4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)