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_ITEM_CLASSES

Line 4314: select to_char(ame_item_classes.item_class_id),

4310: itemClassIdIn in integer,
4311: itemClassIdsOut out nocopy ame_util.stringList,
4312: itemClassNamesOut out nocopy ame_util.stringList) as
4313: cursor itemClassesCursor(itemClassIdIn in integer) is
4314: select to_char(ame_item_classes.item_class_id),
4315: name
4316: from ame_item_classes,
4317: ame_item_class_usages
4318: where

Line 4316: from ame_item_classes,

4312: itemClassNamesOut out nocopy ame_util.stringList) as
4313: cursor itemClassesCursor(itemClassIdIn in integer) is
4314: select to_char(ame_item_classes.item_class_id),
4315: name
4316: from ame_item_classes,
4317: ame_item_class_usages
4318: where
4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
4320: ame_item_class_usages.application_id = applicationIdIn and

Line 4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

4315: name
4316: from ame_item_classes,
4317: ame_item_class_usages
4318: where
4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
4320: ame_item_class_usages.application_id = applicationIdIn and
4321: ame_item_classes.item_class_id <> itemClassIdIn and
4322: sysdate between ame_item_classes.start_date and
4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

Line 4321: ame_item_classes.item_class_id <> itemClassIdIn and

4317: ame_item_class_usages
4318: where
4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
4320: ame_item_class_usages.application_id = applicationIdIn and
4321: ame_item_classes.item_class_id <> itemClassIdIn and
4322: sysdate between ame_item_classes.start_date and
4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
4324: sysdate between ame_item_class_usages.start_date and
4325: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 4322: sysdate between ame_item_classes.start_date and

4318: where
4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
4320: ame_item_class_usages.application_id = applicationIdIn and
4321: ame_item_classes.item_class_id <> itemClassIdIn and
4322: sysdate between ame_item_classes.start_date and
4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
4324: sysdate between ame_item_class_usages.start_date and
4325: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
4326: order by ame_item_classes.item_class_id;

Line 4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and

4319: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
4320: ame_item_class_usages.application_id = applicationIdIn and
4321: ame_item_classes.item_class_id <> itemClassIdIn and
4322: sysdate between ame_item_classes.start_date and
4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
4324: sysdate between ame_item_class_usages.start_date and
4325: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
4326: order by ame_item_classes.item_class_id;
4327: begin

Line 4326: order by ame_item_classes.item_class_id;

4322: sysdate between ame_item_classes.start_date and
4323: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
4324: sysdate between ame_item_class_usages.start_date and
4325: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
4326: order by ame_item_classes.item_class_id;
4327: begin
4328: open itemClassesCursor(itemClassIdIn => itemClassIdIn);
4329: fetch itemClassesCursor bulk collect
4330: into itemClassIdsOut,