APPS.GML_REQIMPORT_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 88

Select	pri.rowid,
        pri.transaction_id,
        pri.source_type_code,
	pri.source_organization_id,
	pri.destination_organization_id,
	pri.item_id,
	pri.secondary_unit_of_measure,
	pri.secondary_uom_code,
	pri.secondary_quantity,
	pri.quantity,
	pri.preferred_grade
From	po_requisitions_interface pri
Where   pri.request_id = p_request_id
FOR UPDATE OF pri.secondary_unit_of_measure;

Line: 104

Select	i.item_id,
	i.item_no,
	i.dualum_ind,
	i.grade_ctl,
	i.item_um,
	i.item_um2
From	ic_item_mst i,
	mtl_system_items m
Where	m.inventory_item_id = p_inv_item_id
And	m.segment1 = i.item_no
And     m.organization_id = p_organization_id;

Line: 309

               SELECT mum.unit_of_measure
               INTO   l_passed_secondary_uom
               FROM   mtl_units_of_measure mum
               WHERE  mum.uom_code = cr_rec.secondary_uom_code;

Line: 351

               UPDATE po_requisitions_interface pri
               SET    pri.secondary_unit_of_measure = l_secondary_unit_of_measure
               WHERE  rowid = cr_rec.rowid;

Line: 364

            UPDATE po_requisitions_interface pri
            SET pri.secondary_unit_of_measure = l_secondary_unit_of_measure
            WHERE  rowid = cr_rec.rowid;

Line: 419

                UPDATE po_requisitions_interface
                SET  secondary_unit_of_measure = nvl(secondary_unit_of_measure,l_secondary_unit_of_measure),
                     secondary_quantity = l_secondary_quantity
                WHERE  rowid = cr_rec.rowid;

Line: 492

	      --if dual um 1 then update the secondary quantity since its fixed conversion.
	      ELSIF  v_dualum_ind = 1 THEN

	         po_gml_db_common.VALIDATE_QUANTITY(
                                v_opm_item_id,
                                v_dualum_ind,
                                cr_rec.quantity,
                                v_item_um,
                                v_item_um2,
                                l_secondary_quantity) ;

Line: 503

                 UPDATE po_requisitions_interface
                 SET    secondary_quantity = l_secondary_quantity
                 WHERE  rowid = cr_rec.rowid;

Line: 544

              Select	qc_grade
              Into      v_qc_grade
              From 	qc_grad_mst
              Where	qc_grade = cr_rec.preferred_grade
              And       delete_mark <> 1;

Line: 582

           UPDATE po_requisitions_interface
           SET    secondary_quantity = NULL,
                  secondary_uom_code = NULL,
                  secondary_unit_of_measure = NULL
           WHERE  rowid = cr_rec.rowid;

Line: 593

         UPDATE po_requisitions_interface
         SET    secondary_quantity = NULL,
                secondary_uom_code = NULL,
                secondary_unit_of_measure = NULL,
                preferred_grade = NULL
         WHERE  rowid = cr_rec.rowid;

Line: 605

     UPDATE po_requisitions_interface
     SET    secondary_quantity = NULL,
            secondary_uom_code = NULL,
            secondary_unit_of_measure = NULL,
            preferred_grade = NULL
     WHERE  rowid = cr_rec.rowid;