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 3252: ame_item_class_usages

3248: ame_rule_usages.approver_category approver_category
3249: from
3250: ame_rules,
3251: ame_rule_usages,
3252: ame_item_class_usages
3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and
3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and

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

3252: ame_item_class_usages
3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and
3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3257: ame_item_class_usages.application_id = engAmeApplicationId and
3258: (processPrioritiesIn = ame_util.booleanFalse or
3259: (ame_rules.rule_type = ame_util.combinationRuleType and
3260: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3257: ame_item_class_usages.application_id = engAmeApplicationId and

3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and
3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3257: ame_item_class_usages.application_id = engAmeApplicationId and
3258: (processPrioritiesIn = ame_util.booleanFalse or
3259: (ame_rules.rule_type = ame_util.combinationRuleType and
3260: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3261: combinationRuleThresholdIn >= ame_rule_usages.priority)) or

Line 3308: ame_item_class_usages.start_date and

3304: engEffectiveRuleDate between
3305: ame_rule_usages.start_date and
3306: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3307: engEffectiveRuleDate between
3308: ame_item_class_usages.start_date and
3309: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3310: order by
3311: ame_item_class_usages.item_class_order_number,
3312: item_class_id,

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

3305: ame_rule_usages.start_date and
3306: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3307: engEffectiveRuleDate between
3308: ame_item_class_usages.start_date and
3309: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3310: order by
3311: ame_item_class_usages.item_class_order_number,
3312: item_class_id,
3313: ame_rules.rule_type,

Line 3311: ame_item_class_usages.item_class_order_number,

3307: engEffectiveRuleDate between
3308: ame_item_class_usages.start_date and
3309: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3310: order by
3311: ame_item_class_usages.item_class_order_number,
3312: item_class_id,
3313: ame_rules.rule_type,
3314: ame_rules.rule_id;
3315: conditionlessItemClassIds ame_util.idList;

Line 3965: ame_item_class_usages

3961: ame_attribute_usages.is_static
3962: from
3963: ame_attributes,
3964: ame_attribute_usages,
3965: ame_item_class_usages
3966: where
3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and

Line 3970: ame_item_class_usages.application_id = applicationIdIn and

3966: where
3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and
3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or
3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in

Line 3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and
3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or
3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in
3975: (select ame_attributes2.attribute_id

Line 3995: ame_item_class_usages.start_date and

3991: engEffectiveRuleDate between
3992: ame_attribute_usages.start_date and
3993: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3994: engEffectiveRuleDate between
3995: ame_item_class_usages.start_date and
3996: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3997: /*
3998: The order-by conditions are all necessary. The second is to break
3999: item_class_order_number ties in a determinate order. The third is

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

3992: ame_attribute_usages.start_date and
3993: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3994: engEffectiveRuleDate between
3995: ame_item_class_usages.start_date and
3996: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3997: /*
3998: The order-by conditions are all necessary. The second is to break
3999: item_class_order_number ties in a determinate order. The third is
4000: to display attribute names in alphabetical order on the test tab.

Line 4004: ame_item_class_usages.item_class_order_number,

4000: to display attribute names in alphabetical order on the test tab.
4001: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4002: */
4003: order by
4004: ame_item_class_usages.item_class_order_number,
4005: ame_item_class_usages.item_class_id,
4006: ame_attributes.name;
4007: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4008: select

Line 4005: ame_item_class_usages.item_class_id,

4001: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4002: */
4003: order by
4004: ame_item_class_usages.item_class_order_number,
4005: ame_item_class_usages.item_class_id,
4006: ame_attributes.name;
4007: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4008: select
4009: attribute_value_1,

Line 4390: ame_item_class_usages

4386: ame_attribute_usages.is_static
4387: from
4388: ame_attributes,
4389: ame_attribute_usages,
4390: ame_item_class_usages
4391: where
4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and

Line 4395: ame_item_class_usages.application_id = applicationIdIn and

4391: where
4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id

Line 4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id
4400: from

Line 4419: ame_item_class_usages.start_date and

4415: sysdate between
4416: ame_attribute_usages.start_date and
4417: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4418: sysdate between
4419: ame_item_class_usages.start_date and
4420: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) and
4421: -- Condition to check whether the attribute is used in the rule
4422: exists
4423: (

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

4416: ame_attribute_usages.start_date and
4417: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4418: sysdate between
4419: ame_item_class_usages.start_date and
4420: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate) and
4421: -- Condition to check whether the attribute is used in the rule
4422: exists
4423: (
4424: select 1

Line 4474: ame_item_class_usages.item_class_order_number,

4470: to display attribute names in alphabetical order on the test tab.
4471: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4472: */
4473: order by
4474: ame_item_class_usages.item_class_order_number,
4475: ame_item_class_usages.item_class_id,
4476: ame_attributes.name;
4477: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4478: select

Line 4475: ame_item_class_usages.item_class_id,

4471: Compare the itemClassUsageCursor cursor in the procedure updateTransactionState.
4472: */
4473: order by
4474: ame_item_class_usages.item_class_order_number,
4475: ame_item_class_usages.item_class_id,
4476: ame_attributes.name;
4477: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4478: select
4479: attribute_value_1,

Line 5095: ame_item_class_usages.item_id_query,

5091: cursor itemClassUsageCursor(applicationIdIn in integer) is
5092: select
5093: ame_item_classes.item_class_id,
5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from

Line 5096: ame_item_class_usages.item_class_order_number,

5092: select
5093: ame_item_classes.item_class_id,
5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from
5100: ame_item_classes,

Line 5097: ame_item_class_usages.item_class_par_mode,

5093: ame_item_classes.item_class_id,
5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from
5100: ame_item_classes,
5101: ame_item_class_usages

Line 5098: ame_item_class_usages.item_class_sublist_mode

5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from
5100: ame_item_classes,
5101: ame_item_class_usages
5102: where

Line 5101: ame_item_class_usages

5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from
5100: ame_item_classes,
5101: ame_item_class_usages
5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between

Line 5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

5099: from
5100: ame_item_classes,
5101: ame_item_class_usages
5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 5104: ame_item_class_usages.application_id = applicationIdIn and

5100: ame_item_classes,
5101: ame_item_class_usages
5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5108: engEffectiveRuleDate between

Line 5109: ame_item_class_usages.start_date and

5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5108: engEffectiveRuleDate between
5109: ame_item_class_usages.start_date and
5110: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5111: /*
5112: The order-by conditions are both critical. The second is to break
5113: item_class_order_number ties in a determinate order. Compare the

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

5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5108: engEffectiveRuleDate between
5109: ame_item_class_usages.start_date and
5110: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5111: /*
5112: The order-by conditions are both critical. The second is to break
5113: item_class_order_number ties in a determinate order. Compare the
5114: attributeCursor cursor in the procedure fetchAttributeValues.

Line 5117: ame_item_class_usages.item_class_order_number,

5113: item_class_order_number ties in a determinate order. Compare the
5114: attributeCursor cursor in the procedure fetchAttributeValues.
5115: */
5116: order by
5117: ame_item_class_usages.item_class_order_number,
5118: ame_item_class_usages.item_class_id;
5119: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5120: select distinct item_id
5121: from ame_test_trans_att_values

Line 5118: ame_item_class_usages.item_class_id;

5114: attributeCursor cursor in the procedure fetchAttributeValues.
5115: */
5116: order by
5117: ame_item_class_usages.item_class_order_number,
5118: ame_item_class_usages.item_class_id;
5119: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5120: select distinct item_id
5121: from ame_test_trans_att_values
5122: where