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_RULES

Line 1747: ame_rules.rule_type,

1743: start_date and
1744: nvl(end_date - ame_util.oneSecond, sysdate);
1745: cursor ruleCursor is
1746: select
1747: ame_rules.rule_type,
1748: ame_rules.description
1749: from
1750: ame_rules
1751: where

Line 1748: ame_rules.description

1744: nvl(end_date - ame_util.oneSecond, sysdate);
1745: cursor ruleCursor is
1746: select
1747: ame_rules.rule_type,
1748: ame_rules.description
1749: from
1750: ame_rules
1751: where
1752: ame_rules.rule_id = ruleIdIn and

Line 1750: ame_rules

1746: select
1747: ame_rules.rule_type,
1748: ame_rules.description
1749: from
1750: ame_rules
1751: where
1752: ame_rules.rule_id = ruleIdIn and
1753: sysdate between
1754: ame_rules.start_date and

Line 1752: ame_rules.rule_id = ruleIdIn and

1748: ame_rules.description
1749: from
1750: ame_rules
1751: where
1752: ame_rules.rule_id = ruleIdIn and
1753: sysdate between
1754: ame_rules.start_date and
1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1756: begin

Line 1754: ame_rules.start_date and

1750: ame_rules
1751: where
1752: ame_rules.rule_id = ruleIdIn and
1753: sysdate between
1754: ame_rules.start_date and
1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1756: begin
1757: open ruleCursor;
1758: fetch ruleCursor into

Line 1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1751: where
1752: ame_rules.rule_id = ruleIdIn and
1753: sysdate between
1754: ame_rules.start_date and
1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1756: begin
1757: open ruleCursor;
1758: fetch ruleCursor into
1759: ruleTypeOut,

Line 1820: ame_rules.rule_type,

1816: ame_condition_usages.start_date and
1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1818: cursor ruleCursor is
1819: select
1820: ame_rules.rule_type,
1821: ame_rules.description
1822: from
1823: ame_rules
1824: where

Line 1821: ame_rules.description

1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1818: cursor ruleCursor is
1819: select
1820: ame_rules.rule_type,
1821: ame_rules.description
1822: from
1823: ame_rules
1824: where
1825: ame_rules.rule_id = ruleIdIn and

Line 1823: ame_rules

1819: select
1820: ame_rules.rule_type,
1821: ame_rules.description
1822: from
1823: ame_rules
1824: where
1825: ame_rules.rule_id = ruleIdIn and
1826: sysdate between
1827: ame_rules.start_date and

Line 1825: ame_rules.rule_id = ruleIdIn and

1821: ame_rules.description
1822: from
1823: ame_rules
1824: where
1825: ame_rules.rule_id = ruleIdIn and
1826: sysdate between
1827: ame_rules.start_date and
1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1829: begin

Line 1827: ame_rules.start_date and

1823: ame_rules
1824: where
1825: ame_rules.rule_id = ruleIdIn and
1826: sysdate between
1827: ame_rules.start_date and
1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1829: begin
1830: open ruleCursor;
1831: fetch ruleCursor into

Line 1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1824: where
1825: ame_rules.rule_id = ruleIdIn and
1826: sysdate between
1827: ame_rules.start_date and
1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1829: begin
1830: open ruleCursor;
1831: fetch ruleCursor into
1832: ruleTypeOut,

Line 1911: ame_rules.rule_type,

1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is
1910: select
1911: ame_rules.rule_type,
1912: ame_rules.description
1913: from
1914: ame_rules
1915: where

Line 1912: ame_rules.description

1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is
1910: select
1911: ame_rules.rule_type,
1912: ame_rules.description
1913: from
1914: ame_rules
1915: where
1916: ame_rules.rule_id = ruleIdIn and

Line 1914: ame_rules

1910: select
1911: ame_rules.rule_type,
1912: ame_rules.description
1913: from
1914: ame_rules
1915: where
1916: ame_rules.rule_id = ruleIdIn and
1917: sysdate between
1918: ame_rules.start_date and

Line 1916: ame_rules.rule_id = ruleIdIn and

1912: ame_rules.description
1913: from
1914: ame_rules
1915: where
1916: ame_rules.rule_id = ruleIdIn and
1917: sysdate between
1918: ame_rules.start_date and
1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1920: begin

Line 1918: ame_rules.start_date and

1914: ame_rules
1915: where
1916: ame_rules.rule_id = ruleIdIn and
1917: sysdate between
1918: ame_rules.start_date and
1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1920: begin
1921: open ruleCursor;
1922: fetch ruleCursor into

Line 1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1915: where
1916: ame_rules.rule_id = ruleIdIn and
1917: sysdate between
1918: ame_rules.start_date and
1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1920: begin
1921: open ruleCursor;
1922: fetch ruleCursor into
1923: ruleTypeOut,