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_RULE_API dependencies on AME_ATTRIBUTE_USAGES

Line 904: from ame_attribute_usages

900: ,use_count
901: ,start_date
902: ,end_date
903: ,object_version_number
904: from ame_attribute_usages
905: where attribute_id in (
906: select ame_conditions.attribute_id
907: from ame_conditions
908: ,ame_condition_usages

Line 921: and l_effective_date between ame_attribute_usages.start_date

917: and l_effective_date between ame_conditions.start_date
918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)
919: )
920: and application_id = p_application_id
921: and l_effective_date between ame_attribute_usages.start_date
922: and nvl(ame_attribute_usages.end_date - ame_util.oneSecond, l_effective_date);
923: --+
924: cursor getAttributeUsages2(p_attribute_id in number) is
925: select attribute_id, use_count, start_date, end_date, object_version_number

Line 922: and nvl(ame_attribute_usages.end_date - ame_util.oneSecond, l_effective_date);

918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)
919: )
920: and application_id = p_application_id
921: and l_effective_date between ame_attribute_usages.start_date
922: and nvl(ame_attribute_usages.end_date - ame_util.oneSecond, l_effective_date);
923: --+
924: cursor getAttributeUsages2(p_attribute_id in number) is
925: select attribute_id, use_count, start_date, end_date, object_version_number
926: from ame_attribute_usages

Line 926: from ame_attribute_usages

922: and nvl(ame_attribute_usages.end_date - ame_util.oneSecond, l_effective_date);
923: --+
924: cursor getAttributeUsages2(p_attribute_id in number) is
925: select attribute_id, use_count, start_date, end_date, object_version_number
926: from ame_attribute_usages
927: where attribute_id = p_attribute_id
928: and application_id = p_application_id
929: and l_effective_date between start_date and
930: nvl(end_date - ame_util.oneSecond,l_effective_date);

Line 1466: from ame_attribute_usages

1462: select use_count
1463: ,start_date
1464: ,end_date
1465: ,object_version_number
1466: from ame_attribute_usages
1467: where attribute_id = l_attribute_id
1468: and l_effective_date between start_date
1469: and nvl(end_date - ame_util.oneSecond,l_effective_date )
1470: and application_id = p_application_id;

Line 1852: from ame_attribute_usages

1848: ,p_action_type_id in integer) is
1849: select attribute_id
1850: from ame_mandatory_attributes ama
1851: where ama.attribute_id not in (select attribute_id
1852: from ame_attribute_usages
1853: where application_id = p_application_id
1854: and l_effective_date between start_date
1855: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1856: and l_effective_date between ama.start_date

Line 1894: from ame_attribute_usages

1890: ,use_count
1891: ,start_date
1892: ,end_date
1893: ,object_version_number
1894: from ame_attribute_usages
1895: where attribute_id = attributeIdIn
1896: and application_id = applicationIdIn
1897: and l_effective_date between start_date
1898: and nvl(end_date - ame_util.oneSecond,l_effective_date);

Line 2784: from ame_attribute_usages

2780: );
2781: --+
2782: cursor getAttributeUsages(p_attribute_id in number) is
2783: select attribute_id, use_count, start_date, end_date, object_version_number
2784: from ame_attribute_usages
2785: where attribute_id = p_attribute_id
2786: and application_id = p_application_id
2787: and l_effective_date between start_date and
2788: nvl(end_date - ame_util.oneSecond,l_effective_date);

Line 3059: from ame_attribute_usages

3055: and nvl(end_date - ame_util.oneSecond,l_effective_date);
3056: --+
3057: cursor getAttributeUsages(p_application_id in integer) is
3058: select use_count, start_date, end_date, object_version_number
3059: from ame_attribute_usages
3060: where attribute_id = l_attribute_id
3061: and l_effective_date between start_date and
3062: nvl(end_date - ame_util.oneSecond,l_effective_date )
3063: and application_id = p_application_id;

Line 3407: from ame_attribute_usages

3403: ,use_count
3404: ,start_date
3405: ,end_date
3406: ,object_version_number
3407: from ame_attribute_usages
3408: where attribute_id = attributeIdIn
3409: and application_id = applicationIdIn
3410: and l_effective_date between start_date
3411: and nvl(end_date - ame_util.oneSecond, l_effective_date);