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_API3 dependencies on AME_ACTIONS

Line 1876: ame_actions.description

1872: cursor actionCursor is
1873: select
1874: ame_action_types.name,
1875: ame_action_types.description,
1876: ame_actions.description
1877: from
1878: ame_action_usages,
1879: ame_action_types,
1880: ame_actions

Line 1880: ame_actions

1876: ame_actions.description
1877: from
1878: ame_action_usages,
1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 1883: ame_actions.action_id = ame_action_usages.action_id and

1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1884: ame_action_types.action_type_id = ame_actions.action_type_id and

1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between

Line 1892: ame_actions.start_date and

1888: sysdate between
1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1891: sysdate between
1892: ame_actions.start_date and
1893: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1894: cursor conditionCursor(ruleIdIn in integer) is
1895: select condition_id
1896: from ame_condition_usages

Line 1893: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1891: sysdate between
1892: ame_actions.start_date and
1893: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1894: cursor conditionCursor(ruleIdIn in integer) is
1895: select condition_id
1896: from ame_condition_usages
1897: where

Line 1949: ame_actions.description

1945: cursor actionCursor is
1946: select
1947: ame_action_types.name,
1948: ame_action_types.description,
1949: ame_actions.description
1950: from
1951: ame_action_usages,
1952: ame_action_types,
1953: ame_actions

Line 1953: ame_actions

1949: ame_actions.description
1950: from
1951: ame_action_usages,
1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 1956: ame_actions.action_id = ame_action_usages.action_id and

1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1957: ame_action_types.action_type_id = ame_actions.action_type_id and

1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between

Line 1965: ame_actions.start_date and

1961: sysdate between
1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1964: sysdate between
1965: ame_actions.start_date and
1966: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1967: cursor conditionCursor(ruleIdIn in integer) is
1968: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1969: from ame_condition_usages

Line 1966: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1964: sysdate between
1965: ame_actions.start_date and
1966: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1967: cursor conditionCursor(ruleIdIn in integer) is
1968: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1969: from ame_condition_usages
1970: where

Line 2024: ame_actions.description

2020: cursor actionCursor is
2021: select
2022: ame_action_types.name,
2023: ame_action_types.description,
2024: ame_actions.description
2025: from
2026: ame_action_usages,
2027: ame_action_types,
2028: ame_actions

Line 2028: ame_actions

2024: ame_actions.description
2025: from
2026: ame_action_usages,
2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 2031: ame_actions.action_id = ame_action_usages.action_id and

2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 2032: ame_action_types.action_type_id = ame_actions.action_type_id and

2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between

Line 2040: ame_actions.start_date and

2036: sysdate between
2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2039: sysdate between
2040: ame_actions.start_date and
2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
2042: cursor conditionCursor(ruleIdIn in integer) is
2043: select
2044: ame_conditions.condition_id,

Line 2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2039: sysdate between
2040: ame_actions.start_date and
2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
2042: cursor conditionCursor(ruleIdIn in integer) is
2043: select
2044: ame_conditions.condition_id,
2045: ame_condition_pkg.getDescription(ame_conditions.condition_id),