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_RULE_PKG dependencies on AME_ATTRIBUTES

Line 1229: ame_attributes,

1225: cursor getSubItemClassIdCur(ruleIdIn in integer,
1226: headerItemClassIdIn in integer) is
1227: select item_class_id
1228: from ame_conditions,
1229: ame_attributes,
1230: ame_condition_usages
1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 1233: ame_conditions.attribute_id = ame_attributes.attribute_id and

1229: ame_attributes,
1230: ame_condition_usages
1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

Line 1235: ame_attributes.item_class_id <> headerItemClassIdIn and

1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1238: (sysdate between ame_condition_usages.start_date and
1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and

Line 1240: (sysdate between ame_attributes.start_date and

1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1238: (sysdate between ame_condition_usages.start_date and
1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
1240: (sysdate between ame_attributes.start_date and
1241: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));
1242: headerItemClassId integer;
1243: itemIds ame_util.idList;
1244: begin

Line 1241: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));

1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1238: (sysdate between ame_condition_usages.start_date and
1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
1240: (sysdate between ame_attributes.start_date and
1241: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));
1242: headerItemClassId integer;
1243: itemIds ame_util.idList;
1244: begin
1245: headerItemClassId :=

Line 2020: lineItemAttribute ame_attributes.line_item%type;

2016: currentUserId integer;
2017: endDate date;
2018: errorCode integer;
2019: errorMessage varchar2(200);
2020: lineItemAttribute ame_attributes.line_item%type;
2021: newStartDate date;
2022: queryString ame_attribute_usages.query_string%type;
2023: staticUsage ame_attribute_usages.is_static%type;
2024: stripingAttributeIds ame_util.idList;

Line 2745: ame_attributes,

2741: ame_util.headerItemClassName);
2742: select count(*)
2743: into tempCount
2744: from ame_conditions,
2745: ame_attributes,
2746: ame_condition_usages
2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 2749: ame_conditions.attribute_id = ame_attributes.attribute_id and

2745: ame_attributes,
2746: ame_condition_usages
2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

Line 2751: ame_attributes.item_class_id <> headerItemClassId and

2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
2754: (sysdate between ame_condition_usages.start_date and
2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and

Line 2756: (sysdate between ame_attributes.start_date and

2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
2754: (sysdate between ame_condition_usages.start_date and
2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
2756: (sysdate between ame_attributes.start_date and
2757: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));
2758: if(tempCount > 0) then
2759: return(true);
2760: else

Line 2757: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));

2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
2754: (sysdate between ame_condition_usages.start_date and
2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
2756: (sysdate between ame_attributes.start_date and
2757: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));
2758: if(tempCount > 0) then
2759: return(true);
2760: else
2761: return(false);