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 742: ame_rule_usages,

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

Line 745: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

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

Line 746: ame_rule_usages.item_id <> applicationIdIn and

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

Line 748: ((sysdate between ame_rule_usages.start_date and

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

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

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

Line 750: (sysdate < ame_rule_usages.start_date and

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

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

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

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

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

Line 1961: ame_rule_usages,

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

Line 1965: ame_rules.rule_id = ame_rule_usages.rule_id and

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

Line 1967: ame_rule_usages.item_id = ame_calling_apps.application_id and

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

Line 1968: ame_rule_usages.item_id <> applicationIdIn and

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

Line 1975: ((sysdate between ame_rule_usages.start_date and

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

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

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

Line 1977: (sysdate < ame_rule_usages.start_date and

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

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

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

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

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