2800: ame_attributes.name
2801: from
2802: ame_attributes,
2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
2812: (select attribute_id from ame_mandatory_attributes
2816: sysdate between ame_attributes.start_date and
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
2824: tempIndex integer;
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
2824: tempIndex integer;
2825: begin