DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on GR_ITEM_PROPERTIES

Line 129: FROM gr_item_properties

125: /* ------------------ CURSORS ---------------------- */
126: /* Cursor used retrieve the hazard class */
127: CURSOR c_get_hazard_class IS
128: SELECT alpha_value
129: FROM gr_item_properties
130: WHERE label_code = '14002'
131: AND property_id = 'UNCLSS'
132: AND item_code = p_item_code;
133:

Line 226: FROM gr_item_properties

222: /* ------------------ CURSORS ---------------------- */
223: /* Cursor used retrieve the un_number */
224: CURSOR c_get_un_number IS
225: SELECT 'UN'||TO_CHAR(number_value)
226: FROM gr_item_properties
227: WHERE label_code = '14001'
228: AND property_id = 'UNNUMB'
229: AND item_code = p_item_code;
230:

Line 867: FROM gr_item_properties

863: creation_date,
864: last_updated_by,
865: last_update_date,
866: last_update_login
867: FROM gr_item_properties
868: WHERE label_code <> '14001' and
869: label_code <> '14002' and
870: item_code = l_reg_item_rec.item_code;
871: