APPS.PO_GML_CONV_MIG dependencies on GR_ITEM_PROPERTIES

Line 493: FROM gr_item_properties

489: /* ------------------ CURSORS ---------------------- */
490: /* Cursor used retrieve the un number values */
491: CURSOR c_get_un_numbers IS
492: SELECT DISTINCT(number_value)
493: FROM gr_item_properties
494: WHERE migration_ind IS NULL and
495: property_id = 'UNNUMB' and
496: label_code = '14001';
497:

Line 500: FROM gr_item_properties

496: label_code = '14001';
497:
498: CURSOR c_get_un_number_details IS
499: SELECT *
500: FROM gr_item_properties
501: WHERE migration_ind IS NULL and
502: number_value = l_un_number and
503: property_id = 'UNNUMB' and
504: label_code = '14001'

Line 633: UPDATE gr_item_properties

629:
630: CLOSE c_check_existence;
631:
632: /* Set record status to migrated */
633: UPDATE gr_item_properties
634: SET migration_ind = l_mig_status
635: WHERE number_value = l_un_number_rec.number_value and
636: property_id = 'UNNUMB' and
637: label_code = '14001';