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_ATTRIBUTE_USAGES

Line 3920: ame_attribute_usages.query_string,

3916: ame_attributes.attribute_id attribute_id,
3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static
3922: from
3923: ame_attributes,
3924: ame_attribute_usages,

Line 3921: ame_attribute_usages.is_static

3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static
3922: from
3923: ame_attributes,
3924: ame_attribute_usages,
3925: ame_item_class_usages

Line 3924: ame_attribute_usages,

3920: ame_attribute_usages.query_string,
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

Line 3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

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

Line 3929: ame_attribute_usages.application_id = applicationIdIn and

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

Line 3933: ame_attribute_usages.use_count > 0 or

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
3936: from
3937: ame_attributes ame_attributes2,

Line 3952: ame_attribute_usages.start_date and

3948: engEffectiveRuleDate between
3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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)

Line 3953: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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: /*

Line 4345: ame_attribute_usages.query_string,

4341: ame_attributes.attribute_id attribute_id,
4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static
4347: from
4348: ame_attributes,
4349: ame_attribute_usages,

Line 4346: ame_attribute_usages.is_static

4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static
4347: from
4348: ame_attributes,
4349: ame_attribute_usages,
4350: ame_item_class_usages

Line 4349: ame_attribute_usages,

4345: ame_attribute_usages.query_string,
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

Line 4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

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

Line 4354: ame_attribute_usages.application_id = applicationIdIn and

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

Line 4357: (ame_attribute_usages.use_count = 0 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
4361: ame_attributes ame_attributes2,

Line 4376: ame_attribute_usages.start_date and

4372: sysdate between
4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) 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

Line 4377: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) 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