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 3248: ame_condition_usages

3244: ame_rules.rule_type <> ame_util.productionRuleType) and
3245: not exists (select *
3246: from
3247: ame_conditions,
3248: ame_condition_usages
3249: where
3250: ame_conditions.condition_type <> ame_util.listModConditionType and
3251: ame_conditions.condition_id = ame_condition_usages.condition_id and
3252: ame_condition_usages.rule_id = ame_rules.rule_id and

Line 3251: ame_conditions.condition_id = ame_condition_usages.condition_id and

3247: ame_conditions,
3248: ame_condition_usages
3249: where
3250: ame_conditions.condition_type <> ame_util.listModConditionType and
3251: ame_conditions.condition_id = ame_condition_usages.condition_id and
3252: ame_condition_usages.rule_id = ame_rules.rule_id and
3253: engEffectiveRuleDate between
3254: ame_conditions.start_date and
3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3252: ame_condition_usages.rule_id = ame_rules.rule_id and

3248: ame_condition_usages
3249: where
3250: ame_conditions.condition_type <> ame_util.listModConditionType and
3251: ame_conditions.condition_id = ame_condition_usages.condition_id and
3252: ame_condition_usages.rule_id = ame_rules.rule_id and
3253: engEffectiveRuleDate between
3254: ame_conditions.start_date and
3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3256: engEffectiveRuleDate between

Line 3257: ame_condition_usages.start_date and

3253: engEffectiveRuleDate between
3254: ame_conditions.start_date and
3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3256: engEffectiveRuleDate between
3257: ame_condition_usages.start_date and
3258: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3259: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3260: rownum < 2) and
3261: engEffectiveRuleDate between

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

3254: ame_conditions.start_date and
3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3256: engEffectiveRuleDate between
3257: ame_condition_usages.start_date and
3258: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3259: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3260: rownum < 2) and
3261: engEffectiveRuleDate between
3262: ame_rules.start_date and

Line 3484: (select ame_condition_usages.condition_id

3480: string_value
3481: from ame_string_values
3482: where
3483: condition_id in
3484: (select ame_condition_usages.condition_id
3485: from
3486: ame_attributes,
3487: ame_conditions,
3488: ame_condition_usages,

Line 3488: ame_condition_usages,

3484: (select ame_condition_usages.condition_id
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

Line 3493: ame_conditions.condition_id = ame_condition_usages.condition_id and

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
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

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 3503: ame_condition_usages.start_date and

3499: engEffectiveRuleDate between
3500: ame_conditions.start_date and
3501: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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

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

3500: ame_conditions.start_date and
3501: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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

Line 3540: ame_condition_usages.rule_id rule_id,

3536: ame_conditions.parameter_two parameter_two,
3537: ame_conditions.parameter_three parameter_three,
3538: ame_conditions.include_lower_limit,
3539: ame_conditions.include_upper_limit,
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,

Line 3549: ame_condition_usages,

3545: ame_rule_usages.approver_category
3546: from
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

Line 3555: ame_conditions.condition_id = ame_condition_usages.condition_id and

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
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

Line 3556: ame_condition_usages.rule_id = ame_rules.rule_id and

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
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

Line 3593: ame_condition_usages.start_date and

3589: engEffectiveRuleDate between
3590: ame_conditions.start_date and
3591: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3592: engEffectiveRuleDate between
3593: ame_condition_usages.start_date and
3594: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3595: engEffectiveRuleDate between
3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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

3590: ame_conditions.start_date and
3591: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3592: engEffectiveRuleDate between
3593: ame_condition_usages.start_date and
3594: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3595: engEffectiveRuleDate between
3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3598: engEffectiveRuleDate between

Line 4386: ame_condition_usages,

4382: exists
4383: (
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

Line 4390: and ame_conditions.condition_id = ame_condition_usages.condition_id

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
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date

Line 4391: and ame_condition_usages.rule_id = ame_rules.rule_id

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
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)))

Line 4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date

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)))
4402: union
4403: select 1
4404: from ame_mandatory_attributes,

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

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)))
4402: union
4403: select 1
4404: from ame_mandatory_attributes,
4405: ame_actions,

Line 7370: ame_condition_usages

7366: parameterOne,
7367: parameterTwo
7368: from
7369: ame_conditions,
7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and

Line 7372: ame_condition_usages.rule_id = ruleIdIn and

7368: from
7369: ame_conditions,
7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and

Line 7373: ame_condition_usages.condition_id = ame_conditions.condition_id and

7369: ame_conditions,
7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 7379: ame_condition_usages.start_date and

7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7381: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7382: /* Check for an invalid wf_roles.name value in parameter_two. */
7383: if(parameterTwo = ame_util.invalidApproverWfRolesName) then

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

7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7381: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7382: /* Check for an invalid wf_roles.name value in parameter_two. */
7383: if(parameterTwo = ame_util.invalidApproverWfRolesName) then
7384: raise invalidNameException;