APPS.PO_GML_CONV_MIG dependencies on GR_ITEM_PROPERTIES

Line 467: FROM gr_item_properties

463: /* ------------------ CURSORS ---------------------- */
464: /* Cursor used retrieve the un number values */
465: CURSOR c_get_un_numbers IS
466: SELECT DISTINCT(number_value)
467: FROM gr_item_properties
468: WHERE migration_ind IS NULL and
469: property_id = 'UNNUMB' and
470: label_code = '14001';
471:

Line 474: FROM gr_item_properties

470: label_code = '14001';
471:
472: CURSOR c_get_un_number_details IS
473: SELECT *
474: FROM gr_item_properties
475: WHERE migration_ind IS NULL and
476: number_value = l_un_number and
477: property_id = 'UNNUMB' and
478: label_code = '14001'

Line 607: UPDATE gr_item_properties

603:
604: CLOSE c_check_existence;
605:
606: /* Set record status to migrated */
607: UPDATE gr_item_properties
608: SET migration_ind = l_mig_status
609: WHERE number_value = l_un_number_rec.number_value and
610: property_id = 'UNNUMB' and
611: label_code = '14001';