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_RULE_USAGES

Line 739: ame_rule_usages,

735: begin
736: select count(*)
737: into useCount
738: from
739: ame_rule_usages,
740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and

Line 742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

738: from
739: ame_rule_usages,
740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 743: ame_rule_usages.item_id <> applicationIdIn and

739: ame_rule_usages,
740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and

Line 745: ((sysdate between ame_rule_usages.start_date and

741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and

Line 746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and

Line 747: (sysdate < ame_rule_usages.start_date and

743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and

Line 749: ame_rule_usages.start_date + ame_util.oneSecond))) and

745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 1958: ame_rule_usages,

1954: applicationIdIn in integer) is
1955: select distinct ame_calling_apps.application_name
1956: from
1957: ame_rules,
1958: ame_rule_usages,
1959: ame_calling_apps,
1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and

Line 1962: ame_rules.rule_id = ame_rule_usages.rule_id and

1958: ame_rule_usages,
1959: ame_calling_apps,
1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and

Line 1964: ame_rule_usages.item_id = ame_calling_apps.application_id and

1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or

Line 1965: ame_rule_usages.item_id <> applicationIdIn and

1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and

Line 1972: ((sysdate between ame_rule_usages.start_date and

1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and

Line 1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and

Line 1974: (sysdate < ame_rule_usages.start_date and

1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and

Line 1976: ame_rule_usages.start_date + ame_util.oneSecond))) and

1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,