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_ITEM_CLASS_USAGES

Line 3212: ame_item_class_usages

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
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and

Line 3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and

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
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3217: ame_item_class_usages.application_id = engAmeApplicationId and

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
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or

Line 3268: ame_item_class_usages.start_date 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
3271: ame_item_class_usages.item_class_order_number,
3272: item_class_id,

Line 3269: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

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
3271: ame_item_class_usages.item_class_order_number,
3272: item_class_id,
3273: ame_rules.rule_type,

Line 3271: ame_item_class_usages.item_class_order_number,

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
3271: ame_item_class_usages.item_class_order_number,
3272: item_class_id,
3273: ame_rules.rule_type,
3274: ame_rules.rule_id;
3275: conditionlessItemClassIds ame_util.idList;

Line 3925: ame_item_class_usages

3921: ame_attribute_usages.is_static
3922: from
3923: ame_attributes,
3924: ame_attribute_usages,
3925: ame_item_class_usages
3926: where
3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and

Line 3930: ame_item_class_usages.application_id = applicationIdIn and

3926: where
3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and
3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or
3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in

Line 3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and
3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or
3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id

Line 3955: ame_item_class_usages.start_date and

3951: engEffectiveRuleDate between
3952: ame_attribute_usages.start_date and
3953: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3954: engEffectiveRuleDate between
3955: ame_item_class_usages.start_date and
3956: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3957: /*
3958: The order-by conditions are all necessary. The second is to break
3959: item_class_order_number ties in a determinate order. The third is

Line 3956: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

3952: ame_attribute_usages.start_date and
3953: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3954: engEffectiveRuleDate between
3955: ame_item_class_usages.start_date and
3956: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3957: /*
3958: The order-by conditions are all necessary. The second is to break
3959: item_class_order_number ties in a determinate order. The third is
3960: to display attribute names in alphabetical order on the test tab.

Line 3964: ame_item_class_usages.item_class_order_number,

3960: to display attribute names in alphabetical order on the test tab.
3961: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
3962: */
3963: order by
3964: ame_item_class_usages.item_class_order_number,
3965: ame_item_class_usages.item_class_id,
3966: ame_attributes.name;
3967: cursor testTransCurrencyCursor(attributeIdIn in integer) is
3968: select

Line 3965: ame_item_class_usages.item_class_id,

3961: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
3962: */
3963: order by
3964: ame_item_class_usages.item_class_order_number,
3965: ame_item_class_usages.item_class_id,
3966: ame_attributes.name;
3967: cursor testTransCurrencyCursor(attributeIdIn in integer) is
3968: select
3969: attribute_value_1,

Line 4350: ame_item_class_usages

4346: ame_attribute_usages.is_static
4347: from
4348: ame_attributes,
4349: ame_attribute_usages,
4350: ame_item_class_usages
4351: where
4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and

Line 4355: ame_item_class_usages.application_id = applicationIdIn and

4351: where
4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id

Line 4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from

Line 4379: ame_item_class_usages.start_date and

4375: sysdate between
4376: ame_attribute_usages.start_date and
4377: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4378: sysdate between
4379: ame_item_class_usages.start_date and
4380: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) and
4381: -- Condition to check whether the attribute is used in the rule
4382: exists
4383: (

Line 4380: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) and

4376: ame_attribute_usages.start_date and
4377: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4378: sysdate between
4379: ame_item_class_usages.start_date and
4380: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) and
4381: -- Condition to check whether the attribute is used in the rule
4382: exists
4383: (
4384: select 1

Line 4434: ame_item_class_usages.item_class_order_number,

4430: to display attribute names in alphabetical order on the test tab.
4431: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4432: */
4433: order by
4434: ame_item_class_usages.item_class_order_number,
4435: ame_item_class_usages.item_class_id,
4436: ame_attributes.name;
4437: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4438: select

Line 4435: ame_item_class_usages.item_class_id,

4431: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4432: */
4433: order by
4434: ame_item_class_usages.item_class_order_number,
4435: ame_item_class_usages.item_class_id,
4436: ame_attributes.name;
4437: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4438: select
4439: attribute_value_1,

Line 5055: ame_item_class_usages.item_id_query,

5051: cursor itemClassUsageCursor(applicationIdIn in integer) is
5052: select
5053: ame_item_classes.item_class_id,
5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from

Line 5056: ame_item_class_usages.item_class_order_number,

5052: select
5053: ame_item_classes.item_class_id,
5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from
5060: ame_item_classes,

Line 5057: ame_item_class_usages.item_class_par_mode,

5053: ame_item_classes.item_class_id,
5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from
5060: ame_item_classes,
5061: ame_item_class_usages

Line 5058: ame_item_class_usages.item_class_sublist_mode

5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from
5060: ame_item_classes,
5061: ame_item_class_usages
5062: where

Line 5061: ame_item_class_usages

5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from
5060: ame_item_classes,
5061: ame_item_class_usages
5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between

Line 5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

5059: from
5060: ame_item_classes,
5061: ame_item_class_usages
5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 5064: ame_item_class_usages.application_id = applicationIdIn and

5060: ame_item_classes,
5061: ame_item_class_usages
5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5068: engEffectiveRuleDate between

Line 5069: ame_item_class_usages.start_date and

5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5068: engEffectiveRuleDate between
5069: ame_item_class_usages.start_date and
5070: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5071: /*
5072: The order-by conditions are both critical. The second is to break
5073: item_class_order_number ties in a determinate order. Compare the

Line 5070: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5068: engEffectiveRuleDate between
5069: ame_item_class_usages.start_date and
5070: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5071: /*
5072: The order-by conditions are both critical. The second is to break
5073: item_class_order_number ties in a determinate order. Compare the
5074: attributeCursor cursor in the procedure fetchAttributeValues.

Line 5077: ame_item_class_usages.item_class_order_number,

5073: item_class_order_number ties in a determinate order. Compare the
5074: attributeCursor cursor in the procedure fetchAttributeValues.
5075: */
5076: order by
5077: ame_item_class_usages.item_class_order_number,
5078: ame_item_class_usages.item_class_id;
5079: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5080: select distinct item_id
5081: from ame_test_trans_att_values

Line 5078: ame_item_class_usages.item_class_id;

5074: attributeCursor cursor in the procedure fetchAttributeValues.
5075: */
5076: order by
5077: ame_item_class_usages.item_class_order_number,
5078: ame_item_class_usages.item_class_id;
5079: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5080: select distinct item_id
5081: from ame_test_trans_att_values
5082: where