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 811: ame_attribute_usages,

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

Line 818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

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

Line 819: ame_attribute_usages.application_id = applicationIdIn and

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

Line 820: ((sysdate between ame_attribute_usages.start_date and

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

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

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

Line 822: (sysdate < ame_attribute_usages.start_date and

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

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

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

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

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

Line 1729: ame_attribute_usages,

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

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

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

Line 1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

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

Line 1743: sysdate between ame_attribute_usages.start_date and

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

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

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