APPS.PO_REQIMP_S SQL Statements

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

Line: 20

    select rowid, item_id,rate_date, gl_date, creation_date, source_organization_id
    from po_requisitions_interface
    where source_type_code = 'INVENTORY'
    and unit_price is NULL
    and item_id is not NULL
    and source_organization_id is not null
    and request_id = x_request_id;

Line: 42

       Select round(gl_currency_api.get_closest_rate_sql(x_set_of_books_id,glsob.currency_code,
           trunc(nvl(nvl(nvl(x_rate_date,x_gl_date),x_creation_date),sysdate)),
                       psp.DEFAULT_RATE_TYPE, 30),10)
	INTO x_list_price_conv_temp
	FROM gl_sets_of_books glsob,org_organization_definitions ood,po_system_parameters psp
	WHERE  x_currency_code <> glsob.currency_code
	    AND  glsob.set_of_books_id = ood.set_of_books_id
	    AND ood.organization_id = x_source_org_id
	    AND psp.DEFAULT_RATE_TYPE in (select DEFAULT_RATE_TYPE from po_system_parameters);

Line: 60

     	update po_requisitions_interface
	     set unit_price = (select  msi.list_price_per_unit
                         FROM mtl_system_items msi
                        WHERE msi.inventory_item_id = x_item_id
                          AND msi.organization_id = x_source_org_id)
		where rowid = x_rowid;

Line: 69

	update po_requisitions_interface
	     set unit_price = (select ( msi.list_price_per_unit * x_list_price_conv_temp)
                         FROM mtl_system_items msi
                        WHERE msi.inventory_item_id = x_item_id
                          AND msi.organization_id = x_source_org_id)
     		where rowid = x_rowid;

Line: 97

    select rowid, item_id,unit_of_measure
    from po_requisitions_interface
    where source_type_code = 'VENDOR'
    and unit_price is NULL
    and request_id = x_request_id;

Line: 120

       SELECT  round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
	INTO x_uom_conversion_temp
             FROM mtl_system_items msi
            WHERE msi.inventory_item_id = x_item_id
            AND x_inventory_org_id = msi.organization_id
            AND msi.primary_unit_of_measure <> x_uom;

Line: 133

       UPDATE po_requisitions_interface pri
       --Bug# 1347733
       --togeorge 12/05/2000
       --List price is multiplied with uom conversion instead of dividing.
       --This is done to avoid inaccurate value after conversion.
       --SET pri.unit_price = (SELECT round(msi.list_price_per_unit / (x_uom_conversion_temp),10)
               SET pri.unit_price = (SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
                             FROM mtl_system_items msi,
                                  po_line_types plt
                            WHERE msi.inventory_item_id = pri.item_id
                              AND x_inventory_org_id
                                         = msi.organization_id
                              AND pri.line_type_id = plt.line_type_id
                              AND plt.order_type_lookup_code = 'QUANTITY')
             WHERE rowid = x_rowid;

Line: 182

    SELECT transaction_id
         , destination_organization_id
         , item_id
      FROM po_requisitions_interface
     WHERE request_id = p_request_id
       AND transaction_reason_code IS NULL;

Line: 221

    SELECT org_id
         , inventory_organization_id
      INTO l_org_id
         , l_fsp_inv_org_id
      FROM financials_system_parameters;

Line: 266

                UPDATE po_requisitions_interface
                   SET transaction_reason_code = l_trx_reason_code_tbl(i)
                 WHERE transaction_id = l_transaction_id_tbl(i)
                   AND l_error_code_tbl(i) = 0;

Line: 345

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.unit_of_measure,
	pri.preferred_grade
From	po_requisitions_interface pri
Where   pri.request_id = p_request_id
FOR UPDATE OF pri.secondary_unit_of_measure;

Line: 362

Select	m.tracking_quantity_ind,
	m.secondary_uom_code,
	m.secondary_default_ind
From	mtl_system_items m
Where	m.inventory_item_id = p_inv_item_id
And     m.organization_id = p_organization_id;

Line: 436

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

Line: 483

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

Line: 521

             select unit_of_measure
             into   l_unit_of_measure_s
             from   mtl_units_of_measure
             where  uom_code = l_item_um2_s;

Line: 576

       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;