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_CONDITION_PKG dependencies on AME_ITEM_CLASS_USAGES

Line 1730: ame_item_class_usages

1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,
1729: ame_attribute_usages,
1730: ame_item_class_usages
1731: where
1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and

Line 1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and

1728: ame_attributes,
1729: ame_attribute_usages,
1730: ame_item_class_usages
1731: where
1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and
1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 1733: ame_item_class_usages.application_id = applicationIdIn and

1729: ame_attribute_usages,
1730: ame_item_class_usages
1731: where
1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and
1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1737: ame_attributes.item_class_id = itemClassIdIn and

Line 1734: ame_item_class_usages.item_class_id = itemClassIdIn and

1730: ame_item_class_usages
1731: where
1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and
1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1737: ame_attributes.item_class_id = itemClassIdIn and
1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and

Line 1745: sysdate between ame_item_class_usages.start_date and

1741: sysdate between ame_attributes.start_date and
1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1743: sysdate between ame_attribute_usages.start_date and
1744: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1745: sysdate between ame_item_class_usages.start_date and
1746: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
1747: order by ame_conditions.condition_type,
1748: ame_attributes.attribute_type,
1749: ame_attributes.name;

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

1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1743: sysdate between ame_attribute_usages.start_date and
1744: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1745: sysdate between ame_item_class_usages.start_date and
1746: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
1747: order by ame_conditions.condition_type,
1748: ame_attributes.attribute_type,
1749: ame_attributes.name;
1750: tempOutputIndex integer;