APPS.CSI_T_UI_PVT SQL Statements

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

Line: 122

      SELECT oel.inventory_item_id,
             oel.ship_from_org_id,
             oel.source_document_type_id,
             oel.source_document_line_id,
             oel.org_id
      INTO   l_inventory_item_id,
             l_organization_id,
             l_source_doc_type_id,
             l_source_doc_line_id,
             l_org_id
      FROM   oe_order_lines_all oel
      WHERE  oel.line_id = p_order_line_id;

Line: 143

        SELECT nvl(shippable_item_flag,'N')
        INTO   l_shippable_flag
        FROM   mtl_system_items
        WHERE  inventory_item_id = l_inventory_item_id
        AND    organization_id   = l_organization_id;

Line: 163

          SELECT destination_type_code
          INTO   l_destination_type_code
          FROM   po_requisition_lines_all
          WHERE  requisition_line_id = l_source_doc_line_id;