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_ATTRIBUTE_USAGES

Line 808: ame_attribute_usages,

804: begin
805: select count(*)
806: into lineItemCount
807: from
808: ame_attribute_usages,
809: ame_attributes,
810: ame_conditions
811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and

Line 816: ame_attribute_usages.application_id = applicationIdIn and

812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,

Line 817: ((sysdate between ame_attribute_usages.start_date and

813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and

Line 818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or

814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and

Line 819: (sysdate < ame_attribute_usages.start_date and

815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and
823: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,

816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and
823: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
824: sysdate between ame_conditions.start_date and

Line 821: ame_attribute_usages.start_date + ame_util.oneSecond))) and

817: ((sysdate between ame_attribute_usages.start_date and
818: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
819: (sysdate < ame_attribute_usages.start_date and
820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and
823: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
824: sysdate between ame_conditions.start_date and
825: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;

Line 1726: ame_attribute_usages,

1722: ame_attributes.name,
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

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 1732: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and

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
1736: sysdate between ame_conditions.start_date and

Line 1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

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
1736: sysdate between ame_conditions.start_date and
1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1740: sysdate between ame_attribute_usages.start_date and

1736: sysdate between ame_conditions.start_date and
1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) 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,

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

1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) 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,