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

1723: ame_attributes.attribute_type
1724: from ame_conditions,
1725: ame_attributes,
1726: ame_attribute_usages,
1727: ame_item_class_usages
1728: where
1729: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1730: ame_item_class_usages.application_id = applicationIdIn and
1731: ame_item_class_usages.item_class_id = itemClassIdIn and

Line 1729: ame_attribute_usages.application_id = ame_item_class_usages.application_id and

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

Line 1730: ame_item_class_usages.application_id = applicationIdIn and

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

Line 1731: ame_item_class_usages.item_class_id = itemClassIdIn and

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

Line 1742: sysdate between ame_item_class_usages.start_date and

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

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

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