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.AME_ENGINE dependencies on AME_CONDITION_USAGES

Line 3288: ame_condition_usages

3284: ame_rules.rule_type <> ame_util.productionRuleType) and
3285: not exists (select *
3286: from
3287: ame_conditions,
3288: ame_condition_usages
3289: where
3290: ame_conditions.condition_type <> ame_util.listModConditionType and
3291: ame_conditions.condition_id = ame_condition_usages.condition_id and
3292: ame_condition_usages.rule_id = ame_rules.rule_id and

Line 3291: ame_conditions.condition_id = ame_condition_usages.condition_id and

3287: ame_conditions,
3288: ame_condition_usages
3289: where
3290: ame_conditions.condition_type <> ame_util.listModConditionType and
3291: ame_conditions.condition_id = ame_condition_usages.condition_id and
3292: ame_condition_usages.rule_id = ame_rules.rule_id and
3293: engEffectiveRuleDate between
3294: ame_conditions.start_date and
3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3292: ame_condition_usages.rule_id = ame_rules.rule_id and

3288: ame_condition_usages
3289: where
3290: ame_conditions.condition_type <> ame_util.listModConditionType and
3291: ame_conditions.condition_id = ame_condition_usages.condition_id and
3292: ame_condition_usages.rule_id = ame_rules.rule_id and
3293: engEffectiveRuleDate between
3294: ame_conditions.start_date and
3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3296: engEffectiveRuleDate between

Line 3297: ame_condition_usages.start_date and

3293: engEffectiveRuleDate between
3294: ame_conditions.start_date and
3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3296: engEffectiveRuleDate between
3297: ame_condition_usages.start_date and
3298: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3300: rownum < 2) and
3301: engEffectiveRuleDate between

Line 3298: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3294: ame_conditions.start_date and
3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3296: engEffectiveRuleDate between
3297: ame_condition_usages.start_date and
3298: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3300: rownum < 2) and
3301: engEffectiveRuleDate between
3302: ame_rules.start_date and

Line 3524: (select ame_condition_usages.condition_id

3520: string_value
3521: from ame_string_values
3522: where
3523: condition_id in
3524: (select ame_condition_usages.condition_id
3525: from
3526: ame_attributes,
3527: ame_conditions,
3528: ame_condition_usages,

Line 3528: ame_condition_usages,

3524: (select ame_condition_usages.condition_id
3525: from
3526: ame_attributes,
3527: ame_conditions,
3528: ame_condition_usages,
3529: ame_rule_usages
3530: where
3531: ame_attributes.attribute_type = ame_util.stringAttributeType and
3532: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 3533: ame_conditions.condition_id = ame_condition_usages.condition_id and

3529: ame_rule_usages
3530: where
3531: ame_attributes.attribute_type = ame_util.stringAttributeType and
3532: ame_attributes.attribute_id = ame_conditions.attribute_id and
3533: ame_conditions.condition_id = ame_condition_usages.condition_id and
3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and
3536: engEffectiveRuleDate between
3537: ame_attributes.start_date and

Line 3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and

3530: where
3531: ame_attributes.attribute_type = ame_util.stringAttributeType and
3532: ame_attributes.attribute_id = ame_conditions.attribute_id and
3533: ame_conditions.condition_id = ame_condition_usages.condition_id and
3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and
3536: engEffectiveRuleDate between
3537: ame_attributes.start_date and
3538: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3543: ame_condition_usages.start_date and

3539: engEffectiveRuleDate between
3540: ame_conditions.start_date and
3541: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3542: engEffectiveRuleDate between
3543: ame_condition_usages.start_date and
3544: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3545: engEffectiveRuleDate between
3546: ame_rule_usages.start_date and
3547: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and

Line 3544: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3540: ame_conditions.start_date and
3541: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3542: engEffectiveRuleDate between
3543: ame_condition_usages.start_date and
3544: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3545: engEffectiveRuleDate between
3546: ame_rule_usages.start_date and
3547: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and
3548: engEffectiveRuleDate between

Line 3580: ame_condition_usages.rule_id rule_id,

3576: ame_conditions.parameter_two parameter_two,
3577: ame_conditions.parameter_three parameter_three,
3578: ame_conditions.include_lower_limit,
3579: ame_conditions.include_upper_limit,
3580: ame_condition_usages.rule_id rule_id,
3581: ame_rules.rule_type rule_type,
3582: nvl(ame_rules.item_class_id,
3583: headerItemClassIdIn) rule_item_class,
3584: ame_rule_usages.priority priority,

Line 3589: ame_condition_usages,

3585: ame_rule_usages.approver_category
3586: from
3587: ame_attributes,
3588: ame_conditions,
3589: ame_condition_usages,
3590: ame_rules,
3591: ame_rule_usages
3592: where
3593: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 3595: ame_conditions.condition_id = ame_condition_usages.condition_id and

3591: ame_rule_usages
3592: where
3593: ame_attributes.attribute_id = ame_conditions.attribute_id and
3594: ame_conditions.condition_type <> ame_util.listModConditionType and
3595: ame_conditions.condition_id = ame_condition_usages.condition_id and
3596: ame_condition_usages.rule_id = ame_rules.rule_id and
3597: ame_rules.rule_id = ame_rule_usages.rule_id and
3598: ame_rule_usages.item_id = engAmeApplicationId and
3599: (processPrioritiesIn = ame_util.booleanFalse or

Line 3596: ame_condition_usages.rule_id = ame_rules.rule_id and

3592: where
3593: ame_attributes.attribute_id = ame_conditions.attribute_id and
3594: ame_conditions.condition_type <> ame_util.listModConditionType and
3595: ame_conditions.condition_id = ame_condition_usages.condition_id and
3596: ame_condition_usages.rule_id = ame_rules.rule_id and
3597: ame_rules.rule_id = ame_rule_usages.rule_id and
3598: ame_rule_usages.item_id = engAmeApplicationId and
3599: (processPrioritiesIn = ame_util.booleanFalse or
3600: (ame_rules.rule_type = ame_util.combinationRuleType and

Line 3633: ame_condition_usages.start_date and

3629: engEffectiveRuleDate between
3630: ame_conditions.start_date and
3631: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3632: engEffectiveRuleDate between
3633: ame_condition_usages.start_date and
3634: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3635: engEffectiveRuleDate between
3636: ame_rules.start_date and
3637: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3634: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3630: ame_conditions.start_date and
3631: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3632: engEffectiveRuleDate between
3633: ame_condition_usages.start_date and
3634: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3635: engEffectiveRuleDate between
3636: ame_rules.start_date and
3637: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3638: engEffectiveRuleDate between

Line 4426: ame_condition_usages,

4422: exists
4423: (
4424: select 1
4425: from ame_conditions,
4426: ame_condition_usages,
4427: ame_rules,
4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id

Line 4430: and ame_conditions.condition_id = ame_condition_usages.condition_id

4426: ame_condition_usages,
4427: ame_rules,
4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date

Line 4431: and ame_condition_usages.rule_id = ame_rules.rule_id

4427: ame_rules,
4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date
4435: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4440: and ((engEffectiveRuleDate between ame_condition_usages.start_date

4436: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4437: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4438: and engEffectiveRuleDate between ame_conditions.start_date
4439: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)
4440: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4441: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4442: union
4443: select 1
4444: from ame_mandatory_attributes,

Line 4441: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))

4437: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4438: and engEffectiveRuleDate between ame_conditions.start_date
4439: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)
4440: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4441: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4442: union
4443: select 1
4444: from ame_mandatory_attributes,
4445: ame_actions,

Line 7648: ame_condition_usages

7644: parameterOne,
7645: parameterTwo
7646: from
7647: ame_conditions,
7648: ame_condition_usages
7649: where
7650: ame_condition_usages.rule_id = ruleIdIn and
7651: ame_condition_usages.condition_id = ame_conditions.condition_id and
7652: ame_conditions.condition_type = ame_util.listModConditionType and

Line 7650: ame_condition_usages.rule_id = ruleIdIn and

7646: from
7647: ame_conditions,
7648: ame_condition_usages
7649: where
7650: ame_condition_usages.rule_id = ruleIdIn and
7651: ame_condition_usages.condition_id = ame_conditions.condition_id and
7652: ame_conditions.condition_type = ame_util.listModConditionType and
7653: engEffectiveRuleDate between
7654: ame_conditions.start_date and

Line 7651: ame_condition_usages.condition_id = ame_conditions.condition_id and

7647: ame_conditions,
7648: ame_condition_usages
7649: where
7650: ame_condition_usages.rule_id = ruleIdIn and
7651: ame_condition_usages.condition_id = ame_conditions.condition_id and
7652: ame_conditions.condition_type = ame_util.listModConditionType and
7653: engEffectiveRuleDate between
7654: ame_conditions.start_date and
7655: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 7657: ame_condition_usages.start_date and

7653: engEffectiveRuleDate between
7654: ame_conditions.start_date and
7655: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7656: engEffectiveRuleDate between
7657: ame_condition_usages.start_date and
7658: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7659: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7660: /* Check for an invalid wf_roles.name value in parameter_two. */
7661: if(parameterTwo = ame_util.invalidApproverWfRolesName) then

Line 7658: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

7654: ame_conditions.start_date and
7655: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7656: engEffectiveRuleDate between
7657: ame_condition_usages.start_date and
7658: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7659: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7660: /* Check for an invalid wf_roles.name value in parameter_two. */
7661: if(parameterTwo = ame_util.invalidApproverWfRolesName) then
7662: raise invalidNameException;