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_CONDITION_USAGES

Line 1739: from ame_condition_usages

1735: ame_actions.start_date and
1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1737: cursor conditionCursor(ruleIdIn in integer) is
1738: select condition_id
1739: from ame_condition_usages
1740: where
1741: ame_condition_usages.rule_id = ruleIdIn and
1742: sysdate between
1743: start_date and

Line 1741: ame_condition_usages.rule_id = ruleIdIn and

1737: cursor conditionCursor(ruleIdIn in integer) is
1738: select condition_id
1739: from ame_condition_usages
1740: where
1741: ame_condition_usages.rule_id = ruleIdIn and
1742: sysdate between
1743: start_date and
1744: nvl(end_date - ame_util.oneSecond, sysdate);
1745: cursor ruleCursor is

Line 1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)

1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between

Line 1812: from ame_condition_usages

1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
1816: ame_condition_usages.start_date and

Line 1814: ame_condition_usages.rule_id = ruleIdIn and

1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
1816: ame_condition_usages.start_date and
1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1818: cursor ruleCursor is

Line 1816: ame_condition_usages.start_date and

1812: from ame_condition_usages
1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
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,

Line 1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);

1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
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

Line 1894: ame_condition_usages,

1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,
1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 1897: ame_condition_usages.rule_id = ruleIdIn and

1893: ame_conditions,
1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and

Line 1898: ame_conditions.condition_id = ame_condition_usages.condition_id and

1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1901: ame_condition_usages.start_date and

1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and

1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between