APPS.GR_EURO_CLASSIFICATION dependencies on GR_ITEM_PROPERTIES

Line 11: G_PROPERTY_ID GR_ITEM_PROPERTIES.property_id%TYPE;

7:
8: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
9: G_INGREDIENT_ITEM GR_ITEM_CONCENTRATIONS.ingredient_item_code%TYPE;
10: G_LABEL_CODE GR_LABELS_B.label_code%TYPE;
11: G_PROPERTY_ID GR_ITEM_PROPERTIES.property_id%TYPE;
12: G_CURRENT_DATE DATE := sysdate;
13: G_PRODUCT_CLASS GR_PRODUCT_CLASSES.product_class%TYPE;
14:
15: /* Global Numeric Variables */

Line 66: FROM gr_item_properties ip

62: SELECT ip.alpha_value,
63: ip.number_value,
64: ip.date_value,
65: ip.property_id
66: FROM gr_item_properties ip
67: WHERE ip.item_code = g_current_item
68: AND ip.label_code = g_label_code;
69: GlobalPropertyRecord g_get_item_properties%ROWTYPE;
70: