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_CLASS_USAGES

Line 3812: ame_item_class_usages i

3808: u.approver_category
3809: from
3810: ame_rule_usages u,
3811: ame_rules r,
3812: ame_item_class_usages i
3813: where
3814: u.rule_id = r.rule_id and
3815: r.item_class_id = i.item_class_id and
3816: u.item_id = applicationIdIn and

Line 4317: ame_item_class_usages

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
4321: ame_item_classes.item_class_id <> itemClassIdIn 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 4320: ame_item_class_usages.application_id = applicationIdIn and

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
4324: sysdate between ame_item_class_usages.start_date and

Line 4324: sysdate between ame_item_class_usages.start_date 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
4328: open itemClassesCursor(itemClassIdIn => itemClassIdIn);

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

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
4328: open itemClassesCursor(itemClassIdIn => itemClassIdIn);
4329: fetch itemClassesCursor bulk collect